How to use ado.net dataset datatable in linq query

Here we learn how to write LINQ query with ado.net dataset, some real-time example of using LINQ in asp.net

Though LINQ was not designed to use with ADO.Net objects;
Because ADO.Net was based on different approach that we have used so far in application development.

But just consider if you have any application already developed using ADO.Net, now can you write LINQ queries on your existing ado.net code? The answer is Yes!

Use LINQ with Ado.Net Objects

In previous tutorial we have already learned about ADO.Net Objects, Now you learn how to write LINQ queries with ADO.Net object like dataset, datatable etc.

Here is the code

var _students = from dt in _ds.Tables[0].AsEnumerable()
where (dt.Field<string>("FullName").StartsWith("A"))
select new
{
    Name = dt.Field<string>("FullName"),
    Address = dt.Field<string>("Address")
};

Now simply assign the collection object to a gridview

gvStudents.DataSource = _students;
gvStudents.DataBind();

Now you have basic idea about how LINQ works, in LINQ you can query to any data source like SQL, XML, Entity Framework, ADO.Net and more, but Ado.Net works differently where you can execute query using any ado.net objects which can work with any RDBMS like Oracle, SQL etc.

In this section we will try to a comparative overview of Ado.Net and LINQ