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.
This section describes SQL Server features available through Microsoft.Data.SqlClient. For standalone client applications, install the Microsoft.Data.SqlClient NuGet package. The examples use version 7.1.1. Import Microsoft.Data.SqlClient for connection, command, reader, adapter, and bulk-copy types. Continue to use System.Data for provider-independent types such as DataTable, SqlDbType, and IsolationLevel.
In This Section
Bulk Copy Operations in SQL Server
Describes the bulk copy functionality for Microsoft.Data.SqlClient.
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.