What is benefit of using LINQ on Dataset?The major objective to use LINQ to Dataset is to execute strongly typed queries over Dataset.Consider the scenario that you require to merge the results from two Datasets, or you require to take a distinct value from a Dataset, then we can use LINQ.Usually we can use the SQL queries to execute on the database to get the Dataset, but we can’t use SQL queries on a Dataset to retrieve a single value, for which use ofADO.NET features is necessary.While, in case of LINQ, it supports better dignified way to execute queries on Dataset and gives some new functionalities than ADO.NET.
Quick turn around for development Queries can be dynamically Tables are automatically created into class Columns are automatically created into properties Relationship are automatically appeaded to classes Lambda expressions are awesome Data is easy to setup and use
http://www.codeproject.com/Questions/676075/Linq-Benefit-over-Sql-datatable-dataset