Difference between LINQ to SQL and ADO.NET

 Posted by Ddd on 2/13/2011 | Category: ADO.NET Interview questions | Views: 15258 | Points: 40
Answer:

LINQ TO SQL

1)Used for data handling with SQL Server databases only.

2)Uses the extension methods of System.Linq.Queryable class.

3)Introduced in .net Framework 3.0

4)DataContext is used for Database connectivity.

5)Syntax and coding is somewhat complex.

6)Uses Entity classes.

ADO.NET

1)Used for data handling with any database: SQL Server/Access/Oracle/Excel etc.

2)Does not use the extension methods of System.Linq.Queryable class.

3)There since the .net Framework 1.0

4)SqlConnection/OleDbConnection are used for database connectivity

5)Easier syntax and coding.


Note: Both LINQ TO SQL and ADO.NET have connexted/disconnected modes of data
handling


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response