Microsoft.Data.SqlClient
5.2.2
Prefix Reserved
See the version list below for details.
Requires NuGet 2.12 or higher.
dotnet add package Microsoft.Data.SqlClient --version 5.2.2
NuGet\Install-Package Microsoft.Data.SqlClient -Version 5.2.2
<PackageReference Include="Microsoft.Data.SqlClient" Version="5.2.2" />
paket add Microsoft.Data.SqlClient --version 5.2.2
#r "nuget: Microsoft.Data.SqlClient, 5.2.2"
// Install Microsoft.Data.SqlClient as a Cake Addin #addin nuget:?package=Microsoft.Data.SqlClient&version=5.2.2 // Install Microsoft.Data.SqlClient as a Cake Tool #tool nuget:?package=Microsoft.Data.SqlClient&version=5.2.2
The current data provider for SQL Server and Azure SQL databases. This has replaced System.Data.SqlClient. These classes provide access to SQL and encapsulate database-specific protocols, including tabular data stream (TDS).
Commonly Used Types:
Microsoft.Data.SqlClient.SqlConnection
Microsoft.Data.SqlClient.SqlException
Microsoft.Data.SqlClient.SqlParameter
Microsoft.Data.SqlClient.SqlDataReader
Microsoft.Data.SqlClient.SqlCommand
Microsoft.Data.SqlClient.SqlTransaction
Microsoft.Data.SqlClient.SqlParameterCollection
Microsoft.Data.SqlClient.SqlClientFactory
When using NuGet 3.x this package requires at least version 3.4.
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET | net5.0 was computed. net5.0-windows was computed. net6.0 is compatible. net6.0-android was computed. net6.0-ios was computed. net6.0-maccatalyst was computed. net6.0-macos was computed. net6.0-tvos was computed. net6.0-windows was computed. net7.0 was computed. net7.0-android was computed. net7.0-ios was computed. net7.0-maccatalyst was computed. net7.0-macos was computed. net7.0-tvos was computed. net7.0-windows was computed. net8.0 is compatible. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed. |
.NET Core | netcoreapp2.0 was computed. netcoreapp2.1 was computed. netcoreapp2.2 was computed. netcoreapp3.0 was computed. netcoreapp3.1 was computed. |
.NET Standard | netstandard2.0 is compatible. netstandard2.1 is compatible. |
.NET Framework | net461 was computed. net462 is compatible. net463 was computed. net47 was computed. net471 was computed. net472 was computed. net48 was computed. net481 was computed. |
MonoAndroid | monoandroid was computed. |
MonoMac | monomac was computed. |
MonoTouch | monotouch was computed. |
Tizen | tizen40 was computed. tizen60 was computed. |
Xamarin.iOS | xamarinios was computed. |
Xamarin.Mac | xamarinmac was computed. |
Xamarin.TVOS | xamarintvos was computed. |
Xamarin.WatchOS | xamarinwatchos was computed. |
-
.NETFramework 4.6.2
- Azure.Identity (>= 1.11.4)
- Microsoft.Data.SqlClient.SNI (>= 5.2.0)
- Microsoft.Identity.Client (>= 4.61.3)
- Microsoft.IdentityModel.JsonWebTokens (>= 6.35.0)
- Microsoft.IdentityModel.Protocols.OpenIdConnect (>= 6.35.0)
- System.Buffers (>= 4.5.1)
- System.Configuration.ConfigurationManager (>= 6.0.1)
- System.Runtime.InteropServices.RuntimeInformation (>= 4.3.0)
- System.Text.Encodings.Web (>= 6.0.0)
-
.NETStandard 2.0
- Azure.Identity (>= 1.11.4)
- Microsoft.Data.SqlClient.SNI.runtime (>= 5.2.0)
- Microsoft.Identity.Client (>= 4.61.3)
- Microsoft.IdentityModel.JsonWebTokens (>= 6.35.0)
- Microsoft.IdentityModel.Protocols.OpenIdConnect (>= 6.35.0)
- Microsoft.SqlServer.Server (>= 1.0.0)
- Microsoft.Win32.Registry (>= 5.0.0)
- System.Buffers (>= 4.5.1)
- System.Configuration.ConfigurationManager (>= 6.0.1)
- System.Diagnostics.DiagnosticSource (>= 6.0.1)
- System.Runtime.Caching (>= 6.0.0)
- System.Runtime.Loader (>= 4.3.0)
- System.Security.Cryptography.Cng (>= 5.0.0)
- System.Security.Principal.Windows (>= 5.0.0)
- System.Text.Encoding.CodePages (>= 6.0.0)
- System.Text.Encodings.Web (>= 6.0.0)
-
.NETStandard 2.1
- Azure.Identity (>= 1.11.4)
- Microsoft.Data.SqlClient.SNI.runtime (>= 5.2.0)
- Microsoft.Identity.Client (>= 4.61.3)
- Microsoft.IdentityModel.JsonWebTokens (>= 6.35.0)
- Microsoft.IdentityModel.Protocols.OpenIdConnect (>= 6.35.0)
- Microsoft.SqlServer.Server (>= 1.0.0)
- Microsoft.Win32.Registry (>= 5.0.0)
- System.Configuration.ConfigurationManager (>= 6.0.1)
- System.Diagnostics.DiagnosticSource (>= 6.0.1)
- System.Runtime.Caching (>= 6.0.0)
- System.Runtime.Loader (>= 4.3.0)
- System.Security.Cryptography.Cng (>= 5.0.0)
- System.Security.Principal.Windows (>= 5.0.0)
- System.Text.Encoding.CodePages (>= 6.0.0)
- System.Text.Encodings.Web (>= 6.0.0)
-
net6.0
- Azure.Identity (>= 1.11.4)
- Microsoft.Data.SqlClient.SNI.runtime (>= 5.2.0)
- Microsoft.Identity.Client (>= 4.61.3)
- Microsoft.IdentityModel.JsonWebTokens (>= 6.35.0)
- Microsoft.IdentityModel.Protocols.OpenIdConnect (>= 6.35.0)
- Microsoft.SqlServer.Server (>= 1.0.0)
- System.Configuration.ConfigurationManager (>= 6.0.1)
- System.Runtime.Caching (>= 6.0.0)
-
net8.0
- Azure.Identity (>= 1.11.4)
- Microsoft.Data.SqlClient.SNI.runtime (>= 5.2.0)
- Microsoft.Identity.Client (>= 4.61.3)
- Microsoft.IdentityModel.JsonWebTokens (>= 6.35.0)
- Microsoft.IdentityModel.Protocols.OpenIdConnect (>= 6.35.0)
- Microsoft.SqlServer.Server (>= 1.0.0)
- System.Configuration.ConfigurationManager (>= 8.0.0)
- System.Runtime.Caching (>= 8.0.0)
NuGet packages (1.9K)
Showing the top 5 NuGet packages that depend on Microsoft.Data.SqlClient:
Package | Downloads |
---|---|
Microsoft.EntityFrameworkCore.SqlServer
Microsoft SQL Server database provider for Entity Framework Core. |
|
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/af22effae4069a5dfb9b0735859de48820104f5b |
|
AspNetCore.HealthChecks.SqlServer
HealthChecks.SqlServer is the health check package for SqlServer. |
|
Microsoft.EntityFrameworkCore.SqlServer.NetTopologySuite
NetTopologySuite support for the Microsoft SQL Server database provider for Entity Framework Core. |
|
Serilog.Sinks.MSSqlServer
A Serilog sink that writes events to Microsoft SQL Server and Azure SQL |
GitHub repositories (188)
Showing the top 5 popular GitHub repositories that depend on Microsoft.Data.SqlClient:
Repository | Stars |
---|---|
microsoft/semantic-kernel
Integrate cutting-edge LLM technology quickly and easily into your apps
|
|
DapperLib/Dapper
Dapper - a simple object mapper for .Net
|
|
jasontaylordev/CleanArchitecture
Clean Architecture Solution Template for ASP.NET Core
|
|
bitwarden/server
Bitwarden infrastructure/backend (API, database, Docker, etc).
|
|
dotnet/efcore
EF Core is a modern object-database mapper for .NET. It supports LINQ queries, change tracking, updates, and schema migrations.
|
Version | Downloads | Last updated | |
---|---|---|---|
6.0.0-preview3.24332.3 | 14,699 | 11/28/2024 | |
6.0.0-preview2.24304.8 | 23,399 | 10/30/2024 | |
6.0.0-preview1.24240.8 | 54,480 | 8/27/2024 | |
5.2.2 | 11,412,871 | 8/27/2024 | |
5.2.1 | 12,116,885 | 5/31/2024 | |
5.2.0 | 20,975,713 | 2/28/2024 | |
5.2.0-preview5.24024.3 | 459,195 | 1/25/2024 | |
5.2.0-preview4.23342.2 | 353,154 | 12/8/2023 | |
5.2.0-preview3.23201.1 | 616,321 | 7/20/2023 | |
5.2.0-preview2.23159.1 | 42,155 | 6/8/2023 | |
5.2.0-preview1.23109.1 | 58,057 | 4/20/2023 | |
5.1.6 | 2,677,827 | 8/27/2024 | |
5.1.5 | 43,781,955 | 1/29/2024 | |
5.1.4 | 21,505,156 | 1/9/2024 | |
5.1.3 | 2,427,338 | 1/9/2024 | |
5.1.2 | 6,641,331 | 10/26/2023 | |
5.1.1 | 46,573,559 | 3/28/2023 | |
5.1.0 | 11,318,920 | 1/19/2023 | |
5.1.0-preview2.22314.2 | 140,072 | 11/10/2022 | |
5.1.0-preview1.22279.3 | 35,409 | 10/6/2022 | |
5.0.2 | 11,628,950 | 3/31/2023 | |
5.0.1 | 47,319,033 | 10/8/2022 | |
5.0.0 | 6,185,238 | 8/5/2022 | |
5.0.0-preview3.22168.1 | 12,551 | 6/17/2022 | |
5.0.0-preview2.22096.2 | 169,441 | 4/6/2022 | |
5.0.0-preview1.22069.1 | 11,256 | 3/10/2022 | |
4.1.1 | 2,849,938 | 9/13/2022 | |
4.1.0 | 19,791,998 | 1/31/2022 | |
4.0.6 | 7,818 | 8/21/2024 | |
4.0.5 | 4,169,848 | 1/9/2024 | |
4.0.4 | 8,356 | 10/30/2023 | |
4.0.3 | 13,917 | 4/20/2023 | |
4.0.2 | 180,190 | 9/13/2022 | |
4.0.1 | 4,237,819 | 1/17/2022 | |
4.0.0 | 12,339,672 | 11/19/2021 | |
4.0.0-preview3.21293.2 | 124,697 | 10/20/2021 | |
4.0.0-preview2.21264.2 | 14,530 | 9/21/2021 | |
4.0.0-preview1.21237.2 | 219,758 | 8/25/2021 | |
3.1.7 | 87,379 | 8/21/2024 | |
3.1.5 | 1,042,706 | 1/9/2024 | |
3.1.4 | 94,484 | 10/31/2023 | |
3.1.3 | 331,015 | 3/10/2023 | |
3.1.2 | 110,775 | 2/3/2023 | |
3.1.1 | 1,165,533 | 8/12/2022 | |
3.1.0 | 1,552,093 | 3/30/2022 | |
3.0.1 | 34,418,076 | 9/24/2021 | |
3.0.0 | 18,235,816 | 6/9/2021 | |
3.0.0-preview3.21140.5 | 9,364 | 5/20/2021 | |
3.0.0-preview2.21106.5 | 34,740 | 4/16/2021 | |
3.0.0-preview1.21075.2 | 117,967 | 3/16/2021 | |
2.1.7 | 5,324,036 | 1/9/2024 | |
2.1.6 | 2,380,351 | 4/27/2023 | |
2.1.5 | 2,731,222 | 8/30/2022 | |
2.1.4 | 108,204,148 | 9/21/2021 | |
2.1.3 | 3,075,488 | 5/21/2021 | |
2.1.2 | 25,959,220 | 3/3/2021 | |
2.1.1 | 12,580,325 | 12/18/2020 | |
2.1.0 | 3,730,422 | 11/19/2020 | |
2.1.0-preview2.20297.7 | 138,902 | 10/24/2020 | |
2.1.0-preview1.20235.1 | 173,257 | 8/22/2020 | |
2.0.1 | 66,212,188 | 8/25/2020 | |
2.0.0 | 16,156,007 | 6/16/2020 | |
2.0.0-preview4.20142.4 | 47,541 | 5/21/2020 | |
2.0.0-preview3.20122.2 | 98,517 | 5/1/2020 | |
2.0.0-preview2.20084.1 | 60,881 | 3/24/2020 | |
2.0.0-preview1.20021.1 | 280,792 | 1/21/2020 | |
1.1.4 | 1,863,362 | 3/10/2021 | |
1.1.3 | 55,605,983 | 5/15/2020 | |
1.1.2 | 1,854,834 | 4/15/2020 | |
1.1.1 | 13,825,446 | 2/14/2020 | |
1.1.0 | 6,986,675 | 11/20/2019 | |
1.1.0-preview2.19309.1 | 11,632 | 11/5/2019 | |
1.1.0-preview1.19275.1 | 82,039 | 10/2/2019 | |
1.0.19269.1 | 43,108,465 | 9/26/2019 | |
1.0.19249.1 | 12,662,393 | 9/6/2019 | |
1.0.19239.1 | 4,982,291 | 8/27/2019 | |
1.0.19221.1-Preview | 59,740 | 8/9/2019 | |
1.0.19189.1-Preview | 122,750 | 7/8/2019 | |
1.0.19128.1-Preview | 256,078 | 5/8/2019 | |
1.0.19123.2-Preview | 2,990 | 5/6/2019 |