Wednesday, 3 October 2012

LINQ Data Providers



LINQ Data Providers

The Following lists the core data types LINQ supports in the .Net Framework

Provider
Description
LINQ to Objects
The LINQ to Objects provider enables you to query in-memory collections and arrays. If an object supports either the IEnumerable or IEnumerable(Of T) interface, the LINQ to Objects provider enables you to query it.
You can enable the LINQ to Objects provider by importing the System.Linq namespace, which is imported by default for all Visual Basic projects.
LINQ to SQL
The LINQ to SQL provider enables you to query and modify data in a SQL Server database. This makes it easy to map the object model for an application to the tables and objects in a database.
Visual Basic makes it easier to work with LINQ to SQL by including the Object Relational Designer (O/R Designer). This designer is used to create an object model in an application that maps to objects in a database. The O/R Designer also provides functionality to map stored procedures and functions to the DataContext object, which manages communication with the database and stores state for optimistic concurrency checks.
System.data.Linq
LINQ to XML
The LINQ to XML provider enables you to query and modify XML. You can modify in-memory XML, or you can load XML from and save XML to a file.
LINQ to Dataset
The LINQ to Dataset provider enables you to query and update data in an ADO.NET dataset. You can add the power of LINQ to applications that use datasets in order to simplify and extend your capabilities for querying, aggregating, and updating the data in your dataset.
LINQ to Entities
This LINQ to Entities allows you to write queries against data modeled by using the Entity Framework.

No comments: