Microsoft.Data.SqlClient 7.0.0-preview4.26064.3
Microsoft.Data.SqlClient
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:
- Native SNI: Windows-only, provided via Microsoft.Data.SqlClient.SNI (.NET Framework) or Microsoft.Data.SqlClient.SNI.runtime (.NET on Windows)
- Managed SNI: Cross-platform managed implementation, used by default on Unix platforms
Documentation
- Microsoft.Data.SqlClient Documentation
- Connection String Syntax
- Connection Pooling
- Always Encrypted
- Azure AD Authentication
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:
- Change namespace from
System.Data.SqlClienttoMicrosoft.Data.SqlClient - Update package reference to
Microsoft.Data.SqlClient - Review connection string defaults (e.g.,
Encrypt=Mandatoryis now the default)
License
This package is licensed under the MIT License.
Related Packages
- Microsoft.Data.SqlClient.AlwaysEncrypted.AzureKeyVaultProvider - Azure Key Vault integration for Always Encrypted
- Microsoft.SqlServer.Server - SQL CLR UDT support
- Microsoft.Data.SqlClient.SNI - Native SNI for .NET Framework
- Microsoft.Data.SqlClient.SNI.runtime - Native SNI runtime for .NET on Windows
Showing the top 20 packages that depend on Microsoft.Data.SqlClient.
| Packages | Downloads |
|---|---|
|
FluentMigrator.Runner.SqlServer
FluentMigrator is a database migration framework for .NET written in C#. The basic idea is that you can create migrations which are simply classes that derive from the Migration base class and have a Migration attribute with a unique version number attached to them. Upon executing FluentMigrator, you tell it which version to migrate to and it will run all necessary migrations in order to bring your database up to that version. In addition to forward migration support, FluentMigrator also supports different ways to execute the migrations along with selective migrations called profiles and executing arbitrary SQL.
|
129 |
|
Microsoft.EntityFrameworkCore.SqlServer
Microsoft SQL Server database provider for Entity Framework Core.
|
126 |
|
Microsoft.EntityFrameworkCore.SqlServer
Microsoft SQL Server database provider for Entity Framework Core.
|
127 |
|
Microsoft.EntityFrameworkCore.SqlServer
Microsoft SQL Server database provider for Entity Framework Core.
|
128 |
|
Microsoft.EntityFrameworkCore.SqlServer
Microsoft SQL Server database provider for Entity Framework Core.
|
130 |
|
Microsoft.EntityFrameworkCore.SqlServer
Microsoft SQL Server database provider for Entity Framework Core.
|
131 |
|
Microsoft.EntityFrameworkCore.SqlServer
Microsoft SQL Server database provider for Entity Framework Core.
|
133 |
|
Microsoft.EntityFrameworkCore.SqlServer
Microsoft SQL Server database provider for Entity Framework Core.
|
134 |
|
Microsoft.EntityFrameworkCore.SqlServer
Microsoft SQL Server database provider for Entity Framework Core.
|
135 |
|
Microsoft.EntityFrameworkCore.SqlServer
Microsoft SQL Server database provider for Entity Framework Core.
|
136 |
|
Microsoft.EntityFrameworkCore.SqlServer
Microsoft SQL Server database provider for Entity Framework Core.
|
139 |
|
Microsoft.EntityFrameworkCore.SqlServer
Microsoft SQL Server database provider for Entity Framework Core.
|
196 |
|
Microsoft.EntityFrameworkCore.SqlServer
Microsoft SQL Server database provider for Entity Framework Core.
|
214 |
|
Microsoft.EntityFrameworkCore.SqlServer
Microsoft SQL Server database provider for Entity Framework Core.
|
229 |
|
Microsoft.Extensions.Caching.SqlServer
Distributed cache implementation of Microsoft.Extensions.Caching.Distributed.IDistributedCache using Microsoft SQL Server.
|
129 |
|
Microsoft.Extensions.Caching.SqlServer
Distributed cache implementation of Microsoft.Extensions.Caching.Distributed.IDistributedCache using Microsoft SQL Server.
This package was built from the source code at https://github.com/dotnet/aspnetcore/tree/3dfc6fda80a10797b8c8fda1970e7b377fd8ed8d
|
125 |
https://go.microsoft.com/fwlink/?linkid=2090501
.NET Framework 4.6.2
- Microsoft.Bcl.Cryptography (>= 8.0.0)
- Microsoft.Data.SqlClient.Extensions.Abstractions (>= 1.0.0-preview1.26064.3)
- Microsoft.Data.SqlClient.Extensions.Logging (>= 1.0.0-preview1.26064.3)
- Microsoft.Data.SqlClient.SNI (>= 6.0.2)
- Microsoft.Extensions.Caching.Memory (>= 8.0.1)
- Microsoft.IdentityModel.JsonWebTokens (>= 8.14.0)
- Microsoft.IdentityModel.Protocols.OpenIdConnect (>= 8.14.0)
- System.Buffers (>= 4.6.1)
- System.Diagnostics.DiagnosticSource (>= 8.0.1)
- System.Memory (>= 4.6.3)
- System.Security.Cryptography.Pkcs (>= 8.0.1)
- System.Runtime.InteropServices.RuntimeInformation (>= 4.3.0)
- System.Threading.Channels (>= 8.0.0)
- System.ValueTuple (>= 4.6.1)
- System.Text.Json (>= 8.0.6)
.NET 9.0
- Microsoft.Data.SqlClient.Extensions.Logging (>= 1.0.0-preview1.26064.3)
- Microsoft.Data.SqlClient.SNI.runtime (>= 6.0.2)
- Microsoft.Extensions.Caching.Memory (>= 9.0.9)
- Microsoft.IdentityModel.JsonWebTokens (>= 8.14.0)
- Microsoft.IdentityModel.Protocols.OpenIdConnect (>= 8.14.0)
- Microsoft.SqlServer.Server (>= 1.0.0)
- System.Configuration.ConfigurationManager (>= 9.0.9)
- System.Security.Cryptography.Pkcs (>= 9.0.9)
- Microsoft.Data.SqlClient.Extensions.Abstractions (>= 1.0.0-preview1.26064.3)
- Microsoft.Bcl.Cryptography (>= 9.0.9)
.NET Standard 2.0
- Microsoft.Bcl.Cryptography (>= 8.0.0)
- Microsoft.Data.SqlClient.Extensions.Abstractions (>= 1.0.0-preview1.26064.3)
- Microsoft.Data.SqlClient.SNI.runtime (>= 6.0.2)
- Microsoft.Extensions.Caching.Memory (>= 8.0.1)
- Microsoft.IdentityModel.JsonWebTokens (>= 8.14.0)
- Microsoft.IdentityModel.Protocols.OpenIdConnect (>= 8.14.0)
- Microsoft.SqlServer.Server (>= 1.0.0)
- System.Configuration.ConfigurationManager (>= 8.0.1)
- System.Security.Cryptography.Pkcs (>= 8.0.1)
- System.Text.Json (>= 8.0.6)
- System.Threading.Channels (>= 8.0.0)
- Microsoft.Data.SqlClient.Extensions.Logging (>= 1.0.0-preview1.26064.3)
.NET 8.0
- System.Security.Cryptography.Pkcs (>= 8.0.1)
- Microsoft.SqlServer.Server (>= 1.0.0)
- System.Configuration.ConfigurationManager (>= 8.0.1)
- Microsoft.Bcl.Cryptography (>= 8.0.0)
- Microsoft.Data.SqlClient.Extensions.Abstractions (>= 1.0.0-preview1.26064.3)
- Microsoft.Data.SqlClient.Extensions.Logging (>= 1.0.0-preview1.26064.3)
- Microsoft.Data.SqlClient.SNI.runtime (>= 6.0.2)
- Microsoft.Extensions.Caching.Memory (>= 8.0.1)
- Microsoft.IdentityModel.JsonWebTokens (>= 8.14.0)
- Microsoft.IdentityModel.Protocols.OpenIdConnect (>= 8.14.0)
| Version | Downloads | Last updated |
|---|---|---|
| 7.0.0-preview4.26064.3 | 5 | 03/06/2026 |
| 7.0.0-preview3.25342.7 | 32 | 12/09/2025 |
| 7.0.0-preview2.25289.6 | 59 | 10/17/2025 |
| 7.0.0-preview1.25257.1 | 71 | 09/15/2025 |
| 6.1.4 | 9 | 01/16/2026 |
| 6.1.3 | 66 | 11/13/2025 |
| 6.1.2 | 60 | 10/08/2025 |
| 6.1.1 | 73 | 08/15/2025 |
| 6.1.0 | 71 | 07/26/2025 |
| 6.1.0-preview2.25178.5 | 83 | 06/30/2025 |
| 6.1.0-preview1.25120.4 | 91 | 05/01/2025 |
| 6.0.5 | 10 | 01/16/2026 |
| 6.0.4 | 37 | 11/16/2025 |
| 6.0.3 | 49 | 10/08/2025 |
| 6.0.2 | 79 | 04/25/2025 |
| 6.0.1 | 86 | 03/30/2025 |
| 6.0.0-preview3.24332.3 | 78 | 12/02/2024 |
| 6.0.0-preview2.24304.8 | 95 | 11/14/2024 |
| 6.0.0-preview1.24240.8 | 88 | 09/19/2024 |
| 5.2.3 | 91 | 04/30/2025 |
| 5.2.2 | 77 | 09/01/2024 |
| 5.2.1 | 137 | 07/22/2024 |
| 5.2.0 | 122 | 07/22/2024 |
| 5.2.0-preview5.24024.3 | 122 | 07/22/2024 |
| 5.2.0-preview4.23342.2 | 133 | 07/22/2024 |
| 5.2.0-preview3.23201.1 | 120 | 07/22/2024 |
| 5.2.0-preview2.23159.1 | 116 | 07/22/2024 |
| 5.2.0-preview1.23109.1 | 112 | 07/22/2024 |
| 5.1.9 | 13 | 01/13/2026 |
| 5.1.8 | 39 | 11/15/2025 |
| 5.1.7 | 74 | 04/25/2025 |
| 5.1.6 | 120 | 09/01/2024 |
| 5.1.5 | 129 | 07/22/2024 |
| 5.1.4 | 129 | 07/22/2024 |
| 5.1.3 | 119 | 07/22/2024 |
| 5.1.2 | 96 | 07/22/2024 |
| 5.1.1 | 120 | 07/22/2024 |
| 5.1.0 | 118 | 07/17/2024 |
| 5.1.0-preview2.22314.2 | 113 | 07/22/2024 |
| 5.1.0-preview1.22279.3 | 125 | 07/22/2024 |
| 5.0.2 | 114 | 07/22/2024 |
| 5.0.1 | 123 | 02/04/2024 |
| 5.0.0 | 110 | 07/22/2024 |
| 5.0.0-preview3.22168.1 | 120 | 07/22/2024 |
| 5.0.0-preview2.22096.2 | 119 | 07/22/2024 |
| 5.0.0-preview1.22069.1 | 113 | 07/22/2024 |
| 4.1.1 | 111 | 07/22/2024 |
| 4.1.0 | 127 | 07/22/2024 |
| 4.0.6 | 100 | 08/22/2024 |
| 4.0.5 | 123 | 07/22/2024 |
| 4.0.4 | 101 | 07/22/2024 |
| 4.0.3 | 122 | 07/22/2024 |
| 4.0.2 | 108 | 07/22/2024 |
| 4.0.1 | 131 | 07/22/2024 |
| 4.0.0 | 106 | 06/24/2024 |
| 4.0.0-preview3.21293.2 | 117 | 07/22/2024 |
| 4.0.0-preview2.21264.2 | 124 | 07/22/2024 |
| 4.0.0-preview1.21237.2 | 98 | 07/22/2024 |
| 3.1.7 | 109 | 08/22/2024 |
| 3.1.6 | 81 | 09/21/2024 |
| 3.1.5 | 108 | 07/22/2024 |
| 3.1.4 | 123 | 07/22/2024 |
| 3.1.3 | 117 | 07/22/2024 |
| 3.1.2 | 105 | 07/22/2024 |
| 3.1.1 | 122 | 07/22/2024 |
| 3.1.0 | 111 | 07/22/2024 |
| 3.0.1 | 107 | 07/22/2024 |
| 3.0.0 | 105 | 07/22/2024 |
| 3.0.0-preview3.21140.5 | 113 | 07/22/2024 |
| 3.0.0-preview2.21106.5 | 104 | 07/22/2024 |
| 3.0.0-preview1.21075.2 | 97 | 07/22/2024 |
| 2.1.7 | 120 | 07/22/2024 |
| 2.1.6 | 116 | 07/22/2024 |
| 2.1.5 | 125 | 07/22/2024 |
| 2.1.4 | 140 | 02/04/2024 |
| 2.1.3 | 120 | 07/22/2024 |
| 2.1.2 | 112 | 07/22/2024 |
| 2.1.1 | 103 | 07/22/2024 |
| 2.1.0 | 114 | 07/22/2024 |
| 2.1.0-preview2.20297.7 | 121 | 07/22/2024 |
| 2.1.0-preview1.20235.1 | 132 | 07/22/2024 |
| 2.0.1 | 122 | 07/22/2024 |
| 2.0.0 | 128 | 07/22/2024 |
| 2.0.0-preview4.20142.4 | 129 | 07/22/2024 |
| 2.0.0-preview3.20122.2 | 114 | 07/22/2024 |
| 2.0.0-preview2.20084.1 | 109 | 07/22/2024 |
| 2.0.0-preview1.20021.1 | 118 | 07/21/2024 |
| 1.1.4 | 121 | 07/22/2024 |
| 1.1.3 | 114 | 07/22/2024 |
| 1.1.2 | 123 | 07/22/2024 |
| 1.1.1 | 109 | 07/22/2024 |
| 1.1.0 | 117 | 07/22/2024 |
| 1.1.0-preview2.19309.1 | 100 | 07/22/2024 |
| 1.1.0-preview1.19275.1 | 104 | 07/22/2024 |
| 1.0.19269.1 | 123 | 07/22/2024 |
| 1.0.19249.1 | 120 | 07/22/2024 |
| 1.0.19239.1 | 108 | 07/22/2024 |
| 1.0.19221.1-Preview | 115 | 07/22/2024 |
| 1.0.19189.1-Preview | 107 | 07/22/2024 |
| 1.0.19128.1-Preview | 101 | 07/22/2024 |
| 1.0.19123.2-Preview | 115 | 07/22/2024 |