What is the difference between LINQ and ADO.net

Question

what's the difference between LINQ and ADO.net

Answer 1

Linq is a language function (Language INtegrated Query) that allows you to query objects. It is often combined with Linq to Sql, which is a series of extension methods and other code that allows you to query the Sql Server database using Linq statements.

You can write a Linq provider to query a data source, for example, there is a Linq to Amazon provider that allows you to retrieve results from the Amazon public API.

ADO.Net is a series of technologies for data extraction, I propose to start here: http://en.wikipedia.org/wiki/ADO.NET

Answer 2

, , , LINQ-to-SQL. ADO.NET - , DataTables, DataReaders .. . , , ..

LINQ-to-SQL ORM (Object Relationship Mapper), -, DataTables. LINQ-to-SQL ADO.NET . !

LINQ - , LINQ-to-SQL ,

ClientSet.Where(q=>q.ID==1).First();

Answer 3

LINQ to SQL LINQ " , SQL" , , LINQ . LINQ to Entities LINQ Entity-Data, ++-.

:

http://blogs.microsoft.co.il/blogs/gilf/archive/2008/04/20/linq-to-sql-vs-entity-framework.aspx