Microsoft.Data.SqlClient
6.0.0-preview2.24304.8
Prefix Reserved
Requires NuGet 2.12 or higher.
dotnet add package Microsoft.Data.SqlClient --version 6.0.0-preview2.24304.8
NuGet\Install-Package Microsoft.Data.SqlClient -Version 6.0.0-preview2.24304.8
<PackageReference Include="Microsoft.Data.SqlClient" Version="6.0.0-preview2.24304.8" />
paket add Microsoft.Data.SqlClient --version 6.0.0-preview2.24304.8
#r "nuget: Microsoft.Data.SqlClient, 6.0.0-preview2.24304.8"
// Install Microsoft.Data.SqlClient as a Cake Addin #addin nuget:?package=Microsoft.Data.SqlClient&version=6.0.0-preview2.24304.8&prerelease // Install Microsoft.Data.SqlClient as a Cake Tool #tool nuget:?package=Microsoft.Data.SqlClient&version=6.0.0-preview2.24304.8&prerelease
Microsoft SqlClient Data Provider for SQL Server
Microsoft.Data.SqlClient is a .NET data provider for Microsoft SQL Server and the Azure SQL family of databases. It grew from a union of the two System.Data.SqlClient components which live independently in .NET Framework and .NET Core. Going forward, support for new SQL Server and Azure SQL features will only be implemented in Microsoft.Data.SqlClient.
Supportability
The Microsoft.Data.SqlClient package supports the following environments:
- .NET Framework 4.6.2+
- .NET 6.0+
Download
The Microsoft.Data.SqlClient NuGet package is available on NuGet.org.
SNI Package References
When targeting .NET Framework on Windows, a package reference to Microsoft.Data.SqlClient.SNI loads native Microsoft.Data.SqlClient.SNI.<platform>.dll
libraries into the client's build directories.
When targeting .NET on Windows, a package reference to Microsoft.Data.SqlClient.SNI.runtime loads arm64
, x64
and x86
native Microsoft.Data.SqlClient.SNI.dll
libraries into subdirectories in the client's build directory.
Helpful Links
Topic | Link to File |
---|---|
Coding Style | coding-style.md |
Guidelines for building the driver | BUILDGUIDE.md |
Guidelines for Contributors | CONTRIBUTING.md |
Changelog for all driver releases | CHANGELOG.md |
Support Policy | SUPPORT.md |
Code of Conduct | CODE_OF_CONDUCT.md |
Copyright Information | COPYRIGHT.md |
Our Featured Contributors
Special thanks to everyone who has contributed to the project. We thank you for your continuous support in improving the SqlClient library!
- Wraith (@Wraith2)
- Erik Ejlskov Jensen (@ErikEJ)
- Simon Cropp (@SimonCropp)
- Stefán Jökull Sigurðarson (@stebet)
- Shay Rojansky (@roji)
- Stephen Toub (@stephentoub)
- Rasmus Melchior Jacobsen (@rmja)
- Phillip Haydon (@phillip-haydon)
- Robin Sue (@Suchiman)
Up-to-date list of contributors: Contributor Insights
Release Notes
All preview and stable driver release notes are available under release-notes.
Porting from System.Data.SqlClient
Refer to porting-cheat-sheet.md for a safe porting experience from System.Data.SqlClient to Microsoft.Data.SqlClient and share your experience with us by enhancing this guide for future developers.
Still have questions?
Check out our FAQ. Still not answered? Create an issue to ask a question.
Security
Microsoft takes the security of our software products and services seriously, which includes all source code repositories managed through our GitHub organizations, which include Microsoft, Azure, DotNet, AspNet, Xamarin, and our GitHub organizations.
If you believe you have found a security vulnerability in any Microsoft-owned repository that meets Microsoft's Microsoft's definition of a security vulnerability, please report it to us as described below.
Reporting Security Issues
Please do not report security vulnerabilities through public GitHub issues.
Instead, please report them to the Microsoft Security Response Center (MSRC) at https://msrc.microsoft.com/create-report.
If you prefer to submit without logging in, send email to secure@microsoft.com. If possible, encrypt your message with our PGP key; please download it from the Microsoft Security Response Center PGP Key page.
You should receive a response within 24 hours. If for some reason you do not, please follow up via email to ensure we received your original message. Additional information can be found at microsoft.com/msrc.
Please include the requested information listed below (as much as you can provide) to help us better understand the nature and scope of the possible issue:
- Type of issue (e.g. buffer overflow, SQL injection, cross-site scripting, etc.)
- Full paths of source file(s) related to the manifestation of the issue
- The location of the affected source code (tag/branch/commit or direct URL)
- Any special configuration required to reproduce the issue
- Step-by-step instructions to reproduce the issue
- Proof-of-concept or exploit code (if possible)
- Impact of the issue, including how an attacker might exploit the issue
This information will help us triage your report more quickly.
If you are reporting for a bug bounty, more complete reports can contribute to a higher bounty award. Please visit our Microsoft Bug Bounty Program page for more details about our active programs.
Preferred Languages
We prefer all communications to be in English.
Policy
Microsoft follows the principle of Coordinated Vulnerability Disclosure.
License
The Microsoft.Data.SqlClient Driver for SQL Server is licensed under the MIT license. See the LICENSE file for more details.
Trademarks
This project may contain trademarks or logos for projects, products, or services. Authorized use of Microsoft trademarks or logos is subject to and must follow Microsoft's Trademark & Brand Guidelines. Use of Microsoft trademarks or logos in modified versions of this project must not cause confusion or imply Microsoft sponsorship. Any use of third-party trademarks or logos are subject to those third-party's policies.
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET | 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 Framework | net462 is compatible. net463 was computed. net47 was computed. net471 was computed. net472 was computed. net48 was computed. net481 was computed. |
-
.NETFramework 4.6.2
- Azure.Identity (>= 1.11.4)
- Microsoft.Data.SqlClient.SNI (>= 6.0.0-preview1.24226.4)
- Microsoft.Extensions.Caching.Memory (>= 6.0.1)
- Microsoft.IdentityModel.JsonWebTokens (>= 7.5.0)
- Microsoft.IdentityModel.Protocols.OpenIdConnect (>= 7.5.0)
- System.Buffers (>= 4.5.1)
- System.Text.Encodings.Web (>= 6.0.0)
- System.Text.Json (>= 6.0.10)
-
net6.0
- Azure.Identity (>= 1.11.4)
- Microsoft.Data.SqlClient.SNI.runtime (>= 6.0.0-preview1.24226.4)
- Microsoft.Extensions.Caching.Memory (>= 6.0.1)
- Microsoft.IdentityModel.JsonWebTokens (>= 7.5.0)
- Microsoft.IdentityModel.Protocols.OpenIdConnect (>= 7.5.0)
- Microsoft.SqlServer.Server (>= 1.0.0)
- System.Configuration.ConfigurationManager (>= 6.0.1)
- System.Text.Json (>= 6.0.10)
-
net8.0
- Azure.Identity (>= 1.11.4)
- Microsoft.Data.SqlClient.SNI.runtime (>= 6.0.0-preview1.24226.4)
- Microsoft.Extensions.Caching.Memory (>= 8.0.1)
- Microsoft.IdentityModel.JsonWebTokens (>= 7.5.0)
- Microsoft.IdentityModel.Protocols.OpenIdConnect (>= 7.5.0)
- Microsoft.SqlServer.Server (>= 1.0.0)
- System.Configuration.ConfigurationManager (>= 8.0.1)
- System.Text.Json (>= 8.0.5)
NuGet packages (1.8K)
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 (182)
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
|
|
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.
|
|
HangfireIO/Hangfire
An easy way to perform background job processing in .NET and .NET Core applications. No Windows Service or separate process required
|
Version | Downloads | Last updated | |
---|---|---|---|
6.0.0-preview2.24304.8 | 10,656 | 10/30/2024 | |
6.0.0-preview1.24240.8 | 44,957 | 8/27/2024 | |
5.2.2 | 6,911,168 | 8/27/2024 | |
5.2.1 | 10,616,403 | 5/31/2024 | |
5.2.0 | 18,682,224 | 2/28/2024 | |
5.2.0-preview5.24024.3 | 421,932 | 1/25/2024 | |
5.2.0-preview4.23342.2 | 342,904 | 12/8/2023 | |
5.2.0-preview3.23201.1 | 591,191 | 7/20/2023 | |
5.2.0-preview2.23159.1 | 40,982 | 6/8/2023 | |
5.2.0-preview1.23109.1 | 56,445 | 4/20/2023 | |
5.1.6 | 682,839 | 8/27/2024 | |
5.1.5 | 38,119,292 | 1/29/2024 | |
5.1.4 | 19,776,038 | 1/9/2024 | |
5.1.3 | 2,220,945 | 1/9/2024 | |
5.1.2 | 6,387,829 | 10/26/2023 | |
5.1.1 | 44,963,962 | 3/28/2023 | |
5.1.0 | 11,097,021 | 1/19/2023 | |
5.1.0-preview2.22314.2 | 139,388 | 11/10/2022 | |
5.1.0-preview1.22279.3 | 34,092 | 10/6/2022 | |
5.0.2 | 11,367,867 | 3/31/2023 | |
5.0.1 | 46,468,724 | 10/8/2022 | |
5.0.0 | 6,093,139 | 8/5/2022 | |
5.0.0-preview3.22168.1 | 12,477 | 6/17/2022 | |
5.0.0-preview2.22096.2 | 167,795 | 4/6/2022 | |
5.0.0-preview1.22069.1 | 11,123 | 3/10/2022 | |
4.1.1 | 2,751,185 | 9/13/2022 | |
4.1.0 | 19,543,408 | 1/31/2022 | |
4.0.6 | 5,320 | 8/21/2024 | |
4.0.5 | 3,511,742 | 1/9/2024 | |
4.0.4 | 8,047 | 10/30/2023 | |
4.0.3 | 13,704 | 4/20/2023 | |
4.0.2 | 179,230 | 9/13/2022 | |
4.0.1 | 4,141,022 | 1/17/2022 | |
4.0.0 | 12,079,706 | 11/19/2021 | |
4.0.0-preview3.21293.2 | 124,647 | 10/20/2021 | |
4.0.0-preview2.21264.2 | 14,228 | 9/21/2021 | |
4.0.0-preview1.21237.2 | 219,563 | 8/25/2021 | |
3.1.7 | 53,829 | 8/21/2024 | |
3.1.5 | 952,931 | 1/9/2024 | |
3.1.4 | 91,211 | 10/31/2023 | |
3.1.3 | 320,918 | 3/10/2023 | |
3.1.2 | 106,157 | 2/3/2023 | |
3.1.1 | 1,151,341 | 8/12/2022 | |
3.1.0 | 1,527,855 | 3/30/2022 | |
3.0.1 | 33,832,304 | 9/24/2021 | |
3.0.0 | 17,911,785 | 6/9/2021 | |
3.0.0-preview3.21140.5 | 9,201 | 5/20/2021 | |
3.0.0-preview2.21106.5 | 34,527 | 4/16/2021 | |
3.0.0-preview1.21075.2 | 117,755 | 3/16/2021 | |
2.1.7 | 4,802,931 | 1/9/2024 | |
2.1.6 | 2,285,130 | 4/27/2023 | |
2.1.5 | 2,668,003 | 8/30/2022 | |
2.1.4 | 106,550,082 | 9/21/2021 | |
2.1.3 | 3,051,562 | 5/21/2021 | |
2.1.2 | 25,653,211 | 3/3/2021 | |
2.1.1 | 12,460,713 | 12/18/2020 | |
2.1.0 | 3,713,254 | 11/19/2020 | |
2.1.0-preview2.20297.7 | 137,974 | 10/24/2020 | |
2.1.0-preview1.20235.1 | 173,215 | 8/22/2020 | |
2.0.1 | 65,735,085 | 8/25/2020 | |
2.0.0 | 15,989,033 | 6/16/2020 | |
2.0.0-preview4.20142.4 | 47,202 | 5/21/2020 | |
2.0.0-preview3.20122.2 | 98,184 | 5/1/2020 | |
2.0.0-preview2.20084.1 | 60,807 | 3/24/2020 | |
2.0.0-preview1.20021.1 | 280,234 | 1/21/2020 | |
1.1.4 | 1,824,260 | 3/10/2021 | |
1.1.3 | 54,945,485 | 5/15/2020 | |
1.1.2 | 1,836,264 | 4/15/2020 | |
1.1.1 | 13,723,568 | 2/14/2020 | |
1.1.0 | 6,932,430 | 11/20/2019 | |
1.1.0-preview2.19309.1 | 11,581 | 11/5/2019 | |
1.1.0-preview1.19275.1 | 82,020 | 10/2/2019 | |
1.0.19269.1 | 42,880,186 | 9/26/2019 | |
1.0.19249.1 | 12,558,357 | 9/6/2019 | |
1.0.19239.1 | 4,933,242 | 8/27/2019 | |
1.0.19221.1-Preview | 59,591 | 8/9/2019 | |
1.0.19189.1-Preview | 122,571 | 7/8/2019 | |
1.0.19128.1-Preview | 255,358 | 5/8/2019 | |
1.0.19123.2-Preview | 2,968 | 5/6/2019 |