Microsoft.Data.SqlClient 7.0.0-preview4.26064.3

Microsoft.Data.SqlClient

NuGet NuGet Downloads

Description

Microsoft.Data.SqlClient is the official .NET data provider for Microsoft SQL Server and Azure SQL databases. It provides access to SQL Server and encapsulates database-specific protocols, including Tabular Data Stream (TDS).

This library grew from a union of the two System.Data.SqlClient components which live independently in .NET and .NET Framework. Going forward, support for new SQL Server and Azure SQL features will only be implemented in Microsoft.Data.SqlClient.

Supportability

This package supports:

  • .NET Framework 4.6.2+
  • .NET 8.0+

Installation

Install the package via NuGet:

dotnet add package Microsoft.Data.SqlClient

Or via the Package Manager Console:

Install-Package Microsoft.Data.SqlClient

Getting Started

Basic Connection

using Microsoft.Data.SqlClient;

var connectionString = "Server=myserver;Database=mydb;Integrated Security=true;";

using var connection = new SqlConnection(connectionString);
await connection.OpenAsync();

Console.WriteLine("Connected successfully!");

Execute a Query

using Microsoft.Data.SqlClient;

var connectionString = "Server=myserver;Database=mydb;Integrated Security=true;";

using var connection = new SqlConnection(connectionString);
await connection.OpenAsync();

using var command = new SqlCommand("SELECT Id, Name FROM Customers", connection);
using var reader = await command.ExecuteReaderAsync();

while (await reader.ReadAsync())
{
    Console.WriteLine($"Id: {reader.GetInt32(0)}, Name: {reader.GetString(1)}");
}

Parameterized Query

using Microsoft.Data.SqlClient;

var connectionString = "Server=myserver;Database=mydb;Integrated Security=true;";

using var connection = new SqlConnection(connectionString);
await connection.OpenAsync();

using var command = new SqlCommand("SELECT * FROM Customers WHERE Id = @id", connection);
command.Parameters.AddWithValue("@id", customerId);

using var reader = await command.ExecuteReaderAsync();
// Process results...

Using Transactions

using Microsoft.Data.SqlClient;

using var connection = new SqlConnection(connectionString);
await connection.OpenAsync();

using var transaction = connection.BeginTransaction();

try
{
    using var command = new SqlCommand("INSERT INTO Orders (CustomerId, Total) VALUES (@customerId, @total)", connection, transaction);
    command.Parameters.AddWithValue("@customerId", customerId);
    command.Parameters.AddWithValue("@total", orderTotal);
    
    await command.ExecuteNonQueryAsync();
    await transaction.CommitAsync();
}
catch
{
    await transaction.RollbackAsync();
    throw;
}

Key Features

Feature Description
Cross-Platform Runs on Windows, Linux, and macOS
Azure AD Authentication Multiple Azure Active Directory authentication modes
Always Encrypted Client-side encryption for sensitive data
Connection Pooling Efficient connection management
TLS 1.3 Support Enhanced security with strict encryption mode
MARS Multiple Active Result Sets on a single connection
Async Programming Full async/await support
SqlBatch Batch multiple commands for improved performance
JSON/Vector Support Native support for JSON and Vector data types (SQL Server 2025+)

Commonly Used Types

Microsoft.Data.SqlClient.SqlConnection
Microsoft.Data.SqlClient.SqlCommand
Microsoft.Data.SqlClient.SqlDataReader
Microsoft.Data.SqlClient.SqlParameter
Microsoft.Data.SqlClient.SqlTransaction
Microsoft.Data.SqlClient.SqlException
Microsoft.Data.SqlClient.SqlParameterCollection
Microsoft.Data.SqlClient.SqlClientFactory
Microsoft.Data.SqlClient.SqlBulkCopy
Microsoft.Data.SqlClient.SqlConnectionStringBuilder

Authentication Methods

Method Connection String
SQL Server Authentication User ID=user;Password=pass;
Windows Authentication Integrated Security=true;
Azure AD Password Authentication=Active Directory Password;User ID=user;Password=pass;
Azure AD Integrated Authentication=Active Directory Integrated;
Azure AD Interactive Authentication=Active Directory Interactive;
Azure AD Managed Identity Authentication=Active Directory Managed Identity;
Azure AD Service Principal Authentication=Active Directory Service Principal;User ID=clientId;Password=clientSecret;
Azure AD Default Authentication=Active Directory Default;

Encryption Modes

Mode Description
Encrypt=Optional Encryption is used if available
Encrypt=Mandatory Encryption is required (default)
Encrypt=Strict TDS 8.0 with TLS 1.3 support

SNI (SQL Server Network Interface)

Two implementations are available:

Documentation

Release Notes

Release notes are available at: https://go.microsoft.com/fwlink/?linkid=2090501

Migrating from System.Data.SqlClient

If you're migrating from System.Data.SqlClient, see the porting cheat sheet for guidance.

Key changes:

  1. Change namespace from System.Data.SqlClient to Microsoft.Data.SqlClient
  2. Update package reference to Microsoft.Data.SqlClient
  3. Review connection string defaults (e.g., Encrypt=Mandatory is now the default)

License

This package is licensed under the MIT License.

Showing the top 20 packages that depend on Microsoft.Data.SqlClient.

Packages Downloads
EFCore.BulkExtensions
EntityFramework .Net EFCore EF Core Bulk Batch Extensions for Insert Update Delete Read (CRUD) operations on SQL Server, PostgreSQL, MySQL, SQLite
 108
EFCore.BulkExtensions
EntityFramework .Net EFCore EF Core Bulk Batch Extensions for Insert Update Delete Read (CRUD) operations on SQL Server, PostgreSQL, MySQL, SQLite
 163
EFCore.BulkExtensions
EntityFramework EF Core Bulk Batch Extensions for Insert Update Delete and Read (CRUD) operations on SQL Server and SQLite
 27
EFCore.BulkExtensions
EntityFramework EF Core Bulk Batch Extensions for Insert Update Delete and Read (CRUD) operations on SQL Server and SQLite
 28
EFCore.BulkExtensions
EntityFramework EF Core Bulk Batch Extensions for Insert Update Delete and Read (CRUD) operations on SQL Server and SQLite
 30
EFCore.BulkExtensions
EntityFramework EF Core Bulk Batch Extensions for Insert Update Delete and Read (CRUD) operations on SQL Server, PostgreSQL and SQLite
 27
EFCore.BulkExtensions
EntityFramework EF Core Bulk Batch Extensions for Insert Update Delete Read (CRUD) operations on SQL Server, PostgreSQL, MySQL, SQLite
 29
EFCore.BulkExtensions
EntityFramework EF Core Bulk Batch Extensions for Insert Update Delete Read (CRUD) operations on SQL Server, PostgreSQL, SQLite
 29
Kros.Utils
General utilities and helpers.
 27
Microsoft.EntityFrameworkCore.SqlServer
Microsoft SQL Server database provider for Entity Framework Core.
 29
Microsoft.EntityFrameworkCore.SqlServer
Microsoft SQL Server database provider for Entity Framework Core.
 32
Microsoft.EntityFrameworkCore.SqlServer
Microsoft SQL Server database provider for Entity Framework Core.
 34
Microsoft.EntityFrameworkCore.SqlServer
Microsoft SQL Server database provider for Entity Framework Core.
 44
Microsoft.EntityFrameworkCore.SqlServer
Microsoft SQL Server database provider for Entity Framework Core.
 107
Microsoft.EntityFrameworkCore.SqlServer
Microsoft SQL Server database provider for Entity Framework Core.
 165
Microsoft.EntityFrameworkCore.SqlServer
Microsoft SQL Server database provider for Entity Framework Core.
 635
Microsoft.SqlServer.SqlManagementObjects
The SQL Server Management Objects (SMO) Framework is a set of objects designed for programmatic management of Microsoft SQL Server and Microsoft Azure SQL Database.
 35

https://go.microsoft.com/fwlink/?linkid=2090501

.NET Framework 4.6.2

.NET 9.0

.NET Standard 2.0

.NET 8.0

Version Downloads Last updated
7.0.0-preview4.26064.3 2 03/11/2026
7.0.0-preview3.25342.7 6 12/11/2025
7.0.0-preview2.25289.6 8 10/19/2025
7.0.0-preview1.25257.1 10 09/15/2025
6.1.4 4 01/19/2026
6.1.3 8 11/15/2025
6.1.2 10 10/10/2025
6.1.1 15 08/20/2025
6.1.0 14 08/05/2025
6.1.0-preview2.25178.5 9 08/09/2025
6.1.0-preview1.25120.4 12 05/16/2025
6.0.5 4 01/19/2026
6.0.4 9 11/19/2025
6.0.3 12 10/10/2025
6.0.2 16 04/29/2025
6.0.1 19 01/31/2025
6.0.0-preview3.24332.3 13 01/18/2025
6.0.0-preview2.24304.8 13 12/22/2024
6.0.0-preview1.24240.8 14 01/18/2025
5.2.3 15 05/16/2025
5.2.2 23 01/13/2025
5.2.1 22 01/18/2025
5.2.0 22 03/06/2024
5.2.0-preview5.24024.3 16 03/20/2024
5.2.0-preview4.23342.2 17 03/18/2024
5.2.0-preview3.23201.1 19 11/08/2023
5.2.0-preview2.23159.1 15 03/10/2024
5.2.0-preview1.23109.1 15 11/11/2023
5.1.9 5 01/17/2026
5.1.8 8 11/16/2025
5.1.7 14 04/29/2025
5.1.6 24 01/18/2025
5.1.5 33 02/09/2024
5.1.4 21 01/23/2024
5.1.3 20 03/13/2024
5.1.2 25 11/12/2023
5.1.1 253 08/18/2023
5.1.0 35 02/08/2024
5.1.0-preview2.22314.2 14 03/28/2024
5.1.0-preview1.22279.3 15 11/12/2023
5.0.2 59 08/24/2023
5.0.1 625 08/18/2023
5.0.0 25 03/01/2024
5.0.0-preview3.22168.1 16 11/14/2023
5.0.0-preview2.22096.2 16 03/04/2024
5.0.0-preview1.22069.1 15 11/13/2023
4.1.1 23 03/13/2024
4.1.0 22 01/04/2024
4.0.6 22 01/18/2025
4.0.5 22 03/13/2024
4.0.4 21 03/05/2024
4.0.3 22 03/06/2024
4.0.2 22 03/08/2024
4.0.1 25 11/09/2023
4.0.0 23 03/01/2024
4.0.0-preview3.21293.2 16 03/17/2024
4.0.0-preview2.21264.2 17 03/09/2024
4.0.0-preview1.21237.2 15 03/17/2024
3.1.7 19 01/18/2025
3.1.5 24 03/12/2024
3.1.4 23 03/05/2024
3.1.3 21 01/28/2024
3.1.2 23 03/06/2024
3.1.1 23 03/12/2024
3.1.0 19 01/18/2025
3.0.1 22 03/16/2024
3.0.0 23 03/05/2024
3.0.0-preview3.21140.5 17 03/03/2024
3.0.0-preview2.21106.5 17 11/08/2023
3.0.0-preview1.21075.2 15 03/17/2024
2.1.7 22 03/14/2024
2.1.6 22 11/09/2023
2.1.5 24 08/18/2023
2.1.4 38 08/18/2023
2.1.3 21 03/05/2024
2.1.2 22 03/13/2024
2.1.1 24 03/13/2024
2.1.0 21 03/04/2024
2.1.0-preview2.20297.7 15 03/18/2024
2.1.0-preview1.20235.1 21 03/04/2024
2.0.1 24 11/12/2023
2.0.0 24 03/01/2024
2.0.0-preview4.20142.4 15 03/03/2024
2.0.0-preview3.20122.2 17 03/03/2024
2.0.0-preview2.20084.1 14 03/10/2024
2.0.0-preview1.20021.1 16 03/06/2024
1.1.4 23 03/06/2024
1.1.3 23 03/14/2024
1.1.2 21 03/16/2024
1.1.1 23 08/18/2023
1.1.0 26 02/26/2024
1.1.0-preview2.19309.1 17 03/10/2024
1.1.0-preview1.19275.1 17 03/10/2024
1.0.19269.1 26 08/18/2023
1.0.19249.1 18 03/09/2024
1.0.19239.1 16 03/10/2024
1.0.19221.1-Preview 17 01/18/2025
1.0.19189.1-Preview 15 03/10/2024
1.0.19128.1-Preview 17 03/28/2024
1.0.19123.2-Preview 16 03/14/2024