SQL Server and ADO.NET

This section describes features and behaviors that are specific to the .NET Framework Data Provider for SQL Server (System.Data.SqlClient).

System.Data.SqlClient provides access to versions of SQL Server starting with SQL Server 7.0, which encapsulates database-specific protocols. The functionality of the data provider is designed to be similar to that of the .NET Framework data providers for OLE DB, ODBC, and Oracle. System.Data.SqlClient includes a tabular data stream (TDS) parser to communicate directly with SQL Server.


To use the .NET Framework Data Provider for SQL Server, an application must reference the System.Data.SqlClient namespace.

In This Section

For complete documentation of the SQL Server Database Engine, see SQL Server Books Online for the version of SQL Server you are using.

SQL Server 2000

SQL Server 2005

SQL Server 2008

SQL Server 2000 Books Online

SQL Server 2005 Books Online

SQL Server 2008 Books Online

See Also

Other Resources

Securing ADO.NET Applications

Data Type Mappings in ADO.NET

DataSets, DataTables, and DataViews (ADO.NET)

Retrieving and Modifying Data in ADO.NET

ADO.NET Managed Providers and DataSet Developer Center