Difference between System.Data.SQL and System.Data.SQLClient?

The System.Data.Sql namespace contains classes that support SQL Server-specific functionality and System.Data.SqlClient namespace is the.NET Framework Data Provider for SQL Server. The.NET Framework Data Provider for SQL Server describes a collection of classes used to access a SQL Server database in the managed space.

For more info you can go through....

http://msdn2.microsoft.com/en-us/library/system.data.sqlclient.aspx
http://msdn2.microsoft.com/en-us/library/system.data.sql.aspx

G. S.
.Net Developer

Naraayanan, if this helps please login to Mark As Answer. | Alert Moderator

System.Data.Sql
System.Data.Sql namespace contains classes that support SQL Server-specific functionality
For more info go through this url : http://msdn.microsoft.com/en-us/library/a6t1z9x2(v=vs.80).aspx

System.Data.SqlClient
The types in the System.Data.SqlClient namespace are used by the SQL-managed providers that connect to Microsoft SQL Server.

Naraayanan, if this helps please login to Mark As Answer. | Alert Moderator

The System.Data.Sql namespace contains classes that support SQL Server-specific functionality and System.Data.SqlClient namespace is the.NET Framework Data Provider for SQL Server. The.NET Framework Data Provider for SQL Server describes a collection of classes used to access a SQL Server database in the managed space. Using the SqlDataAdapter, you can fill a memory-resident DataSet .

Naraayanan, if this helps please login to Mark As Answer. | Alert Moderator