System.Data.SqlClient
4.9.0
Prefix Reserved
.NET 6.0
This package targets .NET 6.0. The package is compatible with this framework or higher.
.NET Standard 2.0
This package targets .NET Standard 2.0. The package is compatible with this framework or higher.
.NET Framework 4.6.2
This package targets .NET Framework 4.6.2. The package is compatible with this framework or higher.
dotnet add package System.Data.SqlClient --version 4.9.0
NuGet\Install-Package System.Data.SqlClient -Version 4.9.0
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="System.Data.SqlClient" Version="4.9.0" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
<PackageVersion Include="System.Data.SqlClient" Version="4.9.0" />
<PackageReference Include="System.Data.SqlClient" />
For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package.
paket add System.Data.SqlClient --version 4.9.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: System.Data.SqlClient, 4.9.0"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
#addin nuget:?package=System.Data.SqlClient&version=4.9.0
#tool nuget:?package=System.Data.SqlClient&version=4.9.0
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
About
The legacy .NET Data Provider for SQL Server. These classes provide access to versions of SQL Server and encapsulate database-specific protocols, including tabular data stream (TDS).
System.Data.SqlClient is deprecated. Please use Microsoft.Data.SqlClient instead.
Main Types
The main types provided by this library are:
- System.Data.SqlClient.SqlConnection
- System.Data.SqlClient.SqlException
- System.Data.SqlClient.SqlParameter
- System.Data.SqlDbType
- System.Data.SqlClient.SqlDataReader
- System.Data.SqlClient.SqlCommand
- System.Data.SqlClient.SqlTransaction
- System.Data.SqlClient.SqlParameterCollection
- System.Data.SqlClient.SqlClientFactory
Additional Documentation
- Introducing the new Microsoft.Data.SqlClient
- [https://techcommunity.microsoft.com/t5/sql-server-blog/announcement-system-data-sqlclient-package-is-now-deprecated/ba-p/4227205](Announcement: System.Data.SqlClient package is now deprecated)
- For conceptual information about using this namespace when programming with .NET, see SQL Server and ADO.NET.
- API reference for System.Data.SqlClient can be found in: https://learn.microsoft.com/en-us/dotnet/api/system.data.sqlclient?view=netframework-4.8.1
- API reference for Microsoft.Data.SqlClient can be found in: https://learn.microsoft.com/en-us/dotnet/api/microsoft.data.sqlclient
Related Packages
License
System.Data.SqlClient is released as open source under the MIT license.
| 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. net9.0 was computed. 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 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 was computed. |
| .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. |
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.
-
.NETFramework 4.6.2
- No dependencies.
-
.NETStandard 2.0
- No dependencies.
-
net6.0
- runtime.native.System.Data.SqlClient.sni (>= 4.4.0)
-
net8.0
- runtime.native.System.Data.SqlClient.sni (>= 4.4.0)
NuGet packages (3.8K)
Showing the top 5 NuGet packages that depend on System.Data.SqlClient:
| Package | Downloads |
|---|---|
|
EntityFramework
Entity Framework 6 (EF6) is a tried and tested object-relational mapper for .NET with many years of feature development and stabilization. |
|
|
Microsoft.Windows.Compatibility
This Windows Compatibility Pack provides access to APIs that were previously available only for .NET Framework. It can be used from both .NET as well as .NET Standard. |
|
|
Microsoft.PowerShell.SDK
Runtime for hosting PowerShell |
|
|
EPPlus.Core
EPPlus.Core is an unofficial port of the EPPlus library to .NET Core. |
|
|
ApprovalUtilities
Common helper classes developed with ApprovalTests |
GitHub repositories (253)
Showing the top 5 popular GitHub repositories that depend on System.Data.SqlClient:
| Repository | Stars |
|---|---|
|
microsoft/PowerToys
Windows system utilities to maximize productivity
|
|
|
PowerShell/PowerShell
PowerShell for every system!
|
|
|
DapperLib/Dapper
Dapper - a simple object mapper for .Net
|
|
|
dotnet/runtime
.NET is a cross-platform runtime for cloud, mobile, desktop, and IoT apps.
|
|
|
dotnet/AspNetCore.Docs
Documentation for ASP.NET Core
|
| Version | Downloads | Last updated | |
|---|---|---|---|
| 4.9.0 | 4,778,869 | 11/12/2024 | |
| 4.8.6 | 67,336,194 | 1/9/2024 | |
| 4.8.5 | 70,808,318 | 11/8/2022 | |
| 4.8.4 | 4,451,044 | 10/14/2022 | |
| 4.8.3 | 81,694,755 | 9/14/2021 | |
| 4.8.2 | 76,338,848 | 8/11/2020 | |
| 4.8.1 | 101,472,083 | 2/18/2020 | |
| 4.8.0 | 26,575,645 | 12/3/2019 | |
| 4.8.0-preview3.19551.4 | 85,197 | 11/13/2019 | |
| 4.8.0-preview2.19523.17 | 26,898 | 11/1/2019 | |
| 4.8.0-preview1.19504.10 | 49,616 | 10/15/2019 | |
| 4.7.0 | 34,822,018 | 9/23/2019 | |
| 4.7.0-rc1.19456.4 | 17,168 | 9/16/2019 | |
| 4.7.0-preview9.19421.4 | 19,257 | 9/4/2019 | |
| 4.7.0-preview9.19416.11 | 1,230 | 9/4/2019 | |
| 4.7.0-preview8.19405.3 | 70,631 | 8/13/2019 | |
| 4.7.0-preview7.19362.9 | 125,670 | 7/23/2019 | |
| 4.7.0-preview6.19303.8 | 1,094,022 | 6/12/2019 | |
| 4.7.0-preview6.19264.9 | 3,329 | 9/4/2019 | |
| 4.7.0-preview5.19224.8 | 139,091 | 5/6/2019 | |
| 4.7.0-preview4.19212.13 | 313,069 | 4/18/2019 | |
| 4.7.0-preview3.19128.7 | 94,419 | 3/6/2019 | |
| 4.7.0-preview.19073.11 | 59,372 | 1/29/2019 | |
| 4.7.0-preview.18571.3 | 84,492 | 12/3/2018 | |
| 4.6.1 | 39,376,673 | 5/14/2019 | |
| 4.6.0 | 57,638,606 | 12/3/2018 | |
| 4.6.0-preview3-27014-02 | 183,958 | 10/17/2018 | |
| 4.6.0-preview2-26905-02 | 129,131 | 9/12/2018 | |
| 4.5.3 | 810,044 | 2/18/2020 | |
| 4.5.1 | 53,472,480 | 6/18/2018 | |
| 4.5.0 | 29,100,697 | 5/29/2018 | |
| 4.5.0-rc1 | 180,829 | 5/6/2018 | |
| 4.5.0-preview2-26406-04 | 236,870 | 4/10/2018 | |
| 4.5.0-preview1-26216-02 | 269,816 | 2/26/2018 | |
| 4.4.3 | 26,549,256 | 3/13/2018 | |
| 4.4.2 | 29,419,819 | 12/12/2017 | |
| 4.4.1 | 63,696 | 12/12/2017 | |
| 4.4.0 | 125,162,073 | 8/11/2017 | |
| 4.4.0-preview2-25405-01 | 263,016 | 6/27/2017 | |
| 4.4.0-preview1-25305-02 | 175,842 | 5/9/2017 | |
| 4.3.1 | 50,909,757 | 5/9/2017 | |
| 4.3.0 | 13,930,038 | 11/15/2016 | |
| 4.3.0-preview1-24530-04 | 35,624 | 10/24/2016 | |
| 4.1.0 | 19,132,179 | 6/27/2016 | |
| 4.1.0-rc2-24027 | 149,685 | 5/16/2016 | |
| 4.0.0-beta-23516 | 139,274 | 11/18/2015 | |
| 4.0.0-beta-23409 | 28,406 | 10/15/2015 | |
| 4.0.0-beta-23225 | 18,565 | 9/1/2015 | |
| 4.0.0-beta-23123 | 11,745 | 7/29/2015 | |
| 4.0.0-beta-23109 | 14,998 | 7/27/2015 | |
| 4.0.0-beta-23019 | 25,352 | 6/30/2015 | |
| 4.0.0-beta-22816 | 28,961 | 4/24/2015 | |
| 4.0.0-beta-22605 | 15,580 | 2/13/2015 | |
| 1.0.0-beta2 | 18,429 | 1/16/2015 | |
| 1.0.0-beta1 | 22,071 | 11/11/2014 |