LINQ Providers
So, with the assistance of C# 3.0, LINQ acts as an intermediary between C# and any data store. The libraries in System.Linq implement the various query clauses and operators listed earlier in Tables Table 10-1 through Table 10-6, which in turn talk to LINQ providers, which know how to apply these queries to a specific data source, as shown in Figure 10-10.

Figure 10-10. The LINQ stack and predefined providers
The .NET Framework v3.5 comes with four LINQ providers built in:
The ability to query over arrays, lists, dictionaries, and other in-memory sources of information demonstrated so far in this chapter is known as LINQ to Objects and is also part of
System.Linq.The ability to query over any XML document is known as LINQ to XML and is implemented in
System.Xml.Linq.The ability to query over any SQL Server database is known as LINQ to SQL and is implemented in
System.Data.Linq.The ability to query over any other type of database is currently implemented by pulling data into an in-memory
DataSetobject from the database and then querying theDataSetobject. A set of extensions implemented inSystem.Data.DataSetExtensionsmakes this possible.
A fifth LINQ provider, known as LINQ to Entities, is also available as part of .NET 3.5 Service Pack 1. This is an “enterprise-level” version of LINQ to SQL.
As Figure 10-10 suggests, a number of third-party LINQ providers also provide ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access