SQL Server data operations in ADO.NET

Download ADO.NET

This section describes SQL Server features and functionality that are specific to the Microsoft SqlClient Data Provider for SQL Server (Microsoft.Data.SqlClient).

In this section

Bulk copy operations in SQL Server
Describes the bulk copy functionality for the .NET Data Provider for SQL Server.

Multiple Active Result Sets (MARS)
Describes how to have more than one SqlDataReader open on a connection when each instance of SqlDataReader is started from a separate command.

Asynchronous operations
Describes how to perform asynchronous database operations by using an API that is modeled after the asynchronous model used by the .NET Framework.

Table-valued parameters
Describes how to work with table-valued parameters, which were introduced in SQL Server 2008.

Next steps

• SQL Server and ADO.NET