views:

36

answers:

2

What is ADO.NET and what difference between it and SQL Server?

+2  A: 

ADO.NET is a .NET technology designed to make writing code against the database more easy.

It's not a database (SQL Server is a Database server), it's a tool used to access a database. ADO.NET last incarnation comes with "Entity Framework", an Object Relational Mapper (an other tool designed to make the developper life easier too)

Maupertuis
+1  A: 

ADO.net is more like an API included in the .net library , to allow programmers to access relational (or sometimes non relational databases) through code. That is , it frees programmers from the necessity of interacting directly with the database. It is more like a wrapper for all the SQL actions you might do in the SQL server .

MIkhail