Contents
The LINQ to SharePoint Provider is defined in the Microsoft.SharePoint.Linq namespace. It translates LINQ queries into Collaborative Application Markup Language (CAML) queries. It is no longer necessary for developers to know how to write CAML queries. LINQ queries can be used in server code.
All coding against the LINQ to SharePoint provider must begin by creating a DataContext object. This object represents a subset of a content database, specifically, the lists and list items of a SharePoint Foundation Web site.
The gateway class for the LINQ to SharePoint provider is Microsoft.SharePoint.Linq.DataContext which represents the data of a SharePoint Foundation Web site. It is parallel in use and function to the System.Data.Linq.DataContext class in the LINQ to SQL provider.
Can a LINQ to SharePoint query join two lists?
In particular, there is a limit on list joins, whether implicit or explicit, in queries that use the LINQ to SharePoint provider. A LINQ to SharePoint query can join two lists, either explicitly or implicitly, but only if one has a Lookup type column that looks up to a column in the other table.
What is a LINQ provider in Microsoft.NET?
A LINQ provider is an implementation of the System.Linq.IQueryable and System.Linq.IQueryProvider interfaces that are included with Microsoft .NET Framework (System.Core.dll). The implementing classes must be public in a managed code assembly.
Is the LINQ compiler included in Visual Studio?
LINQ is a feature of the programming languages C# and Microsoft Visual Basic .NET. Compilers are included with Visual Studio. LINQ adds a SQL-like syntax and vocabulary to each of the languages, which can be used to query data sources.
What does the log property do in LINQ?
The Log property is a TextWriter that can write the CAML query into which your LINQ query is translated. Being able to see the CAML query can be a helpful when debugging. To do this, assign a TextWriter object to the Log property. In the following example, the Out TextWriter is assigned to Log.