Linq to Dataset

Hi Shubham,

LINQ to DataSet makes it easier and faster to query over data cached in a DataSet object. Specifically, LINQ to DataSet simplifies querying by enabling developers to write queries from the programming language itself, instead of by using a separate query language. This is especially useful for Visual Studio developers, who can now take advantage of the compile-time syntax checking, static typing, and IntelliSense support provided by the Visual Studio in their queries.

LINQ to DataSet can also be used to query over data that has been consolidated from one or more data sources. This enables many scenarios that require flexibility in how data is represented and handled, such as querying locally aggregated data and middle-tier caching in Web applications. In particular, generic reporting, analysis, and business intelligence applications require this method of manipulation.

The LINQ to DataSet functionality is exposed primarily through the extension methods in the DataRowExtensions and DataTableExtensions classes. LINQ to DataSet builds on and uses the existing ADO.NET 2.0 architecture, and is not meant to replace ADO.NET 2.0 in application code. Existing ADO.NET 2.0 code will continue to function in a LINQ to DataSet application.

For more info:
http://msdn.microsoft.com/en-us/library/bb386977.aspx
http://www.danielmoth.com/Blog/linq-to-dataset.aspx

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ajay Patel14y ago
Here you will find simple example of Linq To Dataset and other simple queries in Linq

http://ajaypatelfromsanthal.blogspot.in/2012/05/linq-to-dataset.html

Enjoy......
Jignesh Trivedi14y ago
hi,

please refer

http://msdn.microsoft.com/en-us/vstudio/bb688086

it contail all posible example.

http://msdn.microsoft.com/en-us/library/bb399401.aspx

hope this help.
MuthuMari M14y ago
Hi,

pls refer the attached document

thanks

If this post is useful then mark it as "Accepted Answer"
Senthilkumar14y ago
Hi Shubham,

LINQ to DataSet makes it easier and faster to query over data cached in a DataSet object. Specifically, LINQ to DataSet simplifies querying by enabling developers to write queries from the programming language itself, instead of by using a separate query language. This is especially useful for Visual Studio developers, who can now take advantage of the compile-time syntax checking, static typing, and IntelliSense support provided by the Visual Studio in their queries.

LINQ to DataSet can also be used to query over data that has been consolidated from one or more data sources. This enables many scenarios that require flexibility in how data is represented and handled, such as querying locally aggregated data and middle-tier caching in Web applications. In particular, generic reporting, analysis, and business intelligence applications require this method of manipulation.

The LINQ to DataSet functionality is exposed primarily through the extension methods in the DataRowExtensions and DataTableExtensions classes. LINQ to DataSet builds on and uses the existing ADO.NET 2.0 architecture, and is not meant to replace ADO.NET 2.0 in application code. Existing ADO.NET 2.0 code will continue to function in a LINQ to DataSet application.

For more info:
http://msdn.microsoft.com/en-us/library/bb386977.aspx
http://www.danielmoth.com/Blog/linq-to-dataset.aspx