Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
For new SQL Server applications, use the Microsoft.Data.SqlClient NuGet package. For runnable C# and Visual Basic examples, see ADO.NET code examples. For current provider documentation, see Microsoft SqlClient Data Provider for SQL Server.
This section describes SQL Server features and behaviors exposed through Microsoft.Data.SqlClient. The provider communicates directly with SQL Server through the tabular data stream (TDS) protocol.
Some .NET Framework integrations, including LINQ to SQL and SQL Server common language runtime (CLR) context connections, still require System.Data.SqlClient. The relevant articles explain these provider requirements.
In This Section
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
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 technical documentation.