Microsoft.Data.SqlClient
6.0.1
Prefix Reserved
Requires NuGet 2.12 or higher.
dotnet add package Microsoft.Data.SqlClient --version 6.0.1
NuGet\Install-Package Microsoft.Data.SqlClient -Version 6.0.1
<PackageReference Include="Microsoft.Data.SqlClient" Version="6.0.1" />
<PackageVersion Include="Microsoft.Data.SqlClient" Version="6.0.1" />
<PackageReference Include="Microsoft.Data.SqlClient" />
paket add Microsoft.Data.SqlClient --version 6.0.1
#r "nuget: Microsoft.Data.SqlClient, 6.0.1"
#addin nuget:?package=Microsoft.Data.SqlClient&version=6.0.1
#tool nuget:?package=Microsoft.Data.SqlClient&version=6.0.1
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 8.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!
- Edward Neal (@edwardneal)
- Erik Ejlskov Jensen (@ErikEJ)
- Michel Zehnder (@MichelZ)
- Shay Rojansky (@roji)
- Phillip Haydon (@phillip-haydon)
- Rasmus Melchior Jacobsen (@rmja)
- Robin Sue (@Suchiman)
- Simon Cropp (@SimonCropp)
- Stefán Jökull Sigurðarson (@stebet)
- Stephen Toub (@stephentoub)
- Wraith (@Wraith2)
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 | 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. net9.0 is compatible. net9.0-android was computed. net9.0-browser was computed. net9.0-ios was computed. net9.0-maccatalyst was computed. net9.0-macos was computed. net9.0-tvos was computed. net9.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.Bcl.Cryptography (>= 8.0.0)
- Microsoft.Data.SqlClient.SNI (>= 6.0.2)
- Microsoft.Extensions.Caching.Memory (>= 8.0.1)
- Microsoft.IdentityModel.JsonWebTokens (>= 7.5.0)
- Microsoft.IdentityModel.Protocols.OpenIdConnect (>= 7.5.0)
- System.Buffers (>= 4.5.1)
- System.Security.Cryptography.Pkcs (>= 8.0.1)
- System.Text.Encodings.Web (>= 6.0.0)
- System.Text.Json (>= 6.0.10)
-
net8.0
- Azure.Identity (>= 1.11.4)
- Microsoft.Bcl.Cryptography (>= 8.0.0)
- Microsoft.Data.SqlClient.SNI.runtime (>= 6.0.2)
- 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.Security.Cryptography.Pkcs (>= 8.0.1)
-
net9.0
- Azure.Identity (>= 1.11.4)
- Microsoft.Bcl.Cryptography (>= 9.0.0)
- Microsoft.Data.SqlClient.SNI.runtime (>= 6.0.2)
- Microsoft.Extensions.Caching.Memory (>= 9.0.0)
- Microsoft.IdentityModel.JsonWebTokens (>= 7.5.0)
- Microsoft.IdentityModel.Protocols.OpenIdConnect (>= 7.5.0)
- Microsoft.SqlServer.Server (>= 1.0.0)
- System.Configuration.ConfigurationManager (>= 9.0.0)
- System.Security.Cryptography.Pkcs (>= 9.0.0)
NuGet packages (2.2K)
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/763b4ef31ca4df6dae07c7ee8f39ea259b6980fa |
|
|
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 (213)
Showing the top 20 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
|
|
|
jasontaylordev/CleanArchitecture
Clean Architecture Solution Template for ASP.NET Core
|
|
|
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.
|
|
|
Sonarr/Sonarr
Smart PVR for newsgroup and bittorrent users.
|
|
|
Radarr/Radarr
Movie organizer/manager for usenet and torrent users.
|
|
|
HangfireIO/Hangfire
An easy way to perform background job processing in .NET and .NET Core applications. No Windows Service or separate process required
|
|
|
nopSolutions/nopCommerce
ASP.NET Core eCommerce software. nopCommerce is a free and open-source shopping cart.
|
|
|
mRemoteNG/mRemoteNG
mRemoteNG is the next generation of mRemote, open source, tabbed, multi-protocol, remote connections manager.
|
|
|
MassTransit/MassTransit
Distributed Application Framework for .NET
|
|
|
elsa-workflows/elsa-core
A .NET workflows library
|
|
|
dotnetcore/CAP
Distributed transaction solution in micro-service base on eventually consistency, also an eventbus with Outbox pattern
|
|
|
quartznet/quartznet
Quartz Enterprise Scheduler .NET
|
|
|
NLog/NLog
NLog - Advanced and Structured Logging for Various .NET Platforms
|
|
|
Azure/azure-sdk-for-net
This repository is for active development of the Azure SDK for .NET. For consumers of the SDK we recommend visiting our public developer docs at https://learn.microsoft.com/dotnet/azure/ or our versioned developer docs at https://azure.github.io/azure-sdk-for-net.
|
|
|
DotNetNext/SqlSugar
.Net aot ORM Fastest ORM DB2 Hana Simple Easy VB.NET Sqlite orm Oracle ORM Mysql Orm 虚谷数据库 postgresql ORm SqlServer oRm 达梦 ORM 人大金仓 ORM 神通ORM C# ORM , C# ORM .NET ORM NET5 ORM .NET6 ORM ClickHouse orm QuestDb ,TDengine ORM,OceanBase orm,GaussDB orm ,Tidb orm Object/Relational Mapping
|
|
|
ServiceStack/ServiceStack
Thoughtfully architected, obscenely fast, thoroughly enjoyable web services for all
|
|
|
TechnitiumSoftware/DnsServer
Technitium DNS Server
|
|
|
umbraco/Umbraco-CMS
Umbraco is a free and open source .NET content management system helping you deliver delightful digital experiences.
|
| Version | Downloads | Last updated | |
|---|---|---|---|
| 6.0.1 | 4,371,854 | 3 months ago | |
| 6.0.0-preview3.24332.3 | 64,254 | 4 months ago | |
| 6.0.0-preview2.24304.8 | 46,236 | 5 months ago | |
| 6.0.0-preview1.24240.8 | 91,183 | 7 months ago | |
| 5.2.2 | 29,696,285 | 7 months ago | |
| 5.2.1 | 16,522,330 | 5/31/2024 | |
| 5.2.0 | 27,960,151 | 2/28/2024 | |
| 5.2.0-preview5.24024.3 | 592,954 | 1/25/2024 | |
| 5.2.0-preview4.23342.2 | 387,562 | 12/8/2023 | |
| 5.2.0-preview3.23201.1 | 671,370 | 7/20/2023 | |
| 5.2.0-preview2.23159.1 | 45,519 | 6/8/2023 | |
| 5.2.0-preview1.23109.1 | 63,792 | 4/20/2023 | |
| 5.1.6 | 15,701,190 | 7 months ago | |
| 5.1.5 | 59,391,313 | 1/29/2024 | |
| 5.1.4 | 27,567,230 | 1/9/2024 | |
| 5.1.3 | 3,058,637 | 1/9/2024 | |
| 5.1.2 | 7,436,093 | 10/26/2023 | |
| 5.1.1 | 51,791,940 | 3/28/2023 | |
| 5.1.0 | 12,004,648 | 1/19/2023 | |
| 5.1.0-preview2.22314.2 | 142,636 | 11/10/2022 | |
| 5.1.0-preview1.22279.3 | 40,487 | 10/6/2022 | |
| 5.0.2 | 12,376,690 | 3/31/2023 | |
| 5.0.1 | 49,943,773 | 10/8/2022 | |
| 5.0.0 | 6,495,707 | 8/5/2022 | |
| 5.0.0-preview3.22168.1 | 13,092 | 6/17/2022 | |
| 5.0.0-preview2.22096.2 | 175,906 | 4/6/2022 | |
| 5.0.0-preview1.22069.1 | 11,684 | 3/10/2022 | |
| 4.1.1 | 3,116,952 | 9/13/2022 | |
| 4.1.0 | 20,684,736 | 1/31/2022 | |
| 4.0.6 | 29,823 | 8 months ago | |
| 4.0.5 | 6,720,552 | 1/9/2024 | |
| 4.0.4 | 9,512 | 10/30/2023 | |
| 4.0.3 | 14,943 | 4/20/2023 | |
| 4.0.2 | 183,769 | 9/13/2022 | |
| 4.0.1 | 4,496,192 | 1/17/2022 | |
| 4.0.0 | 13,106,433 | 11/19/2021 | |
| 4.0.0-preview3.21293.2 | 125,020 | 10/20/2021 | |
| 4.0.0-preview2.21264.2 | 15,678 | 9/21/2021 | |
| 4.0.0-preview1.21237.2 | 220,222 | 8/25/2021 | |
| 3.1.7 | 224,627 | 8 months ago | |
| 3.1.5 | 1,336,975 | 1/9/2024 | |
| 3.1.4 | 104,488 | 10/31/2023 | |
| 3.1.3 | 363,508 | 3/10/2023 | |
| 3.1.2 | 118,928 | 2/3/2023 | |
| 3.1.1 | 1,221,439 | 8/12/2022 | |
| 3.1.0 | 1,624,741 | 3/30/2022 | |
| 3.0.1 | 36,470,551 | 9/24/2021 | |
| 3.0.0 | 19,280,643 | 6/9/2021 | |
| 3.0.0-preview3.21140.5 | 9,678 | 5/20/2021 | |
| 3.0.0-preview2.21106.5 | 35,492 | 4/16/2021 | |
| 3.0.0-preview1.21075.2 | 118,693 | 3/16/2021 | |
| 2.1.7 | 6,905,074 | 1/9/2024 | |
| 2.1.6 | 2,662,350 | 4/27/2023 | |
| 2.1.5 | 2,915,182 | 8/30/2022 | |
| 2.1.4 | 113,062,680 | 9/21/2021 | |
| 2.1.3 | 3,152,866 | 5/21/2021 | |
| 2.1.2 | 26,894,712 | 3/3/2021 | |
| 2.1.1 | 12,957,794 | 12/18/2020 | |
| 2.1.0 | 3,777,431 | 11/19/2020 | |
| 2.1.0-preview2.20297.7 | 143,893 | 10/24/2020 | |
| 2.1.0-preview1.20235.1 | 173,585 | 8/22/2020 | |
| 2.0.1 | 67,677,520 | 8/25/2020 | |
| 2.0.0 | 16,696,747 | 6/16/2020 | |
| 2.0.0-preview4.20142.4 | 48,811 | 5/21/2020 | |
| 2.0.0-preview3.20122.2 | 99,979 | 5/1/2020 | |
| 2.0.0-preview2.20084.1 | 61,143 | 3/24/2020 | |
| 2.0.0-preview1.20021.1 | 282,459 | 1/21/2020 | |
| 1.1.4 | 1,965,194 | 3/10/2021 | |
| 1.1.3 | 57,825,472 | 5/15/2020 | |
| 1.1.2 | 1,920,861 | 4/15/2020 | |
| 1.1.1 | 14,139,811 | 2/14/2020 | |
| 1.1.0 | 7,158,733 | 11/20/2019 | |
| 1.1.0-preview2.19309.1 | 11,850 | 11/5/2019 | |
| 1.1.0-preview1.19275.1 | 82,338 | 10/2/2019 | |
| 1.0.19269.1 | 43,861,536 | 9/26/2019 | |
| 1.0.19249.1 | 12,983,684 | 9/6/2019 | |
| 1.0.19239.1 | 5,148,543 | 8/27/2019 | |
| 1.0.19221.1-Preview | 60,025 | 8/9/2019 | |
| 1.0.19189.1-Preview | 123,164 | 7/8/2019 | |
| 1.0.19128.1-Preview | 258,119 | 5/8/2019 | |
| 1.0.19123.2-Preview | 3,206 | 5/6/2019 |