SQL Server and ADO.NET

Collapse All

This page is specific to

Microsoft Visual Studio 2010/.NET Framework 4

Other versions are also available for the following:

.NET Framework 4

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.

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

In This Section

New Features in SQL Server 2008 (ADO.NET): Describes SqlClient support for functionality introduced in SQL Server SQL Server 2008.
SQL Server Security (ADO.NET): Provides an overview of SQL Server security features, and application scenarios for creating secure ADO.NET applications that target SQL Server.
SQL Server Data Types and ADO.NET: Describes how to work with SQL Server data types and how they interact with .NET Framework data types.
SQL Server Binary and Large-Value Data (ADO.NET): Describes how to work with large value data in SQL Server.
SQL Server Data Operations in ADO.NET: Describes how to work with data in SQL Server. Contains sections about bulk copy operations, MARS, asynchronous operations, and table-valued parameters.
SQL Server Features and ADO.NET: Describes SQL Server features that are useful for ADO.NET application developers.
LINQ to SQL: Describes the basic building blocks, processes, and techniques required for creating LINQ to SQL applications.

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

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