System.Data.SqlClient
                              
                            
                                4.9.0
                            
                        
                            
                                
                                
                                    Prefix Reserved
                                
                            
                    dotnet add package System.Data.SqlClient --version 4.9.0
NuGet\Install-Package System.Data.SqlClient -Version 4.9.0
<PackageReference Include="System.Data.SqlClient" Version="4.9.0" />
<PackageVersion Include="System.Data.SqlClient" Version="4.9.0" />
<PackageReference Include="System.Data.SqlClient" />
paket add System.Data.SqlClient --version 4.9.0
#r "nuget: System.Data.SqlClient, 4.9.0"
#:package System.Data.SqlClient@4.9.0
#addin nuget:?package=System.Data.SqlClient&version=4.9.0
#tool nuget:?package=System.Data.SqlClient&version=4.9.0
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. net10.0 was computed. net10.0-android was computed. net10.0-browser was computed. net10.0-ios was computed. net10.0-maccatalyst was computed. net10.0-macos was computed. net10.0-tvos was computed. net10.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. | 
- 
                                                    .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 (251)
Showing the top 20 popular GitHub repositories that depend on System.Data.SqlClient:
| Repository | Stars | 
|---|---|
| microsoft/PowerToys 
                                                            Microsoft PowerToys is a collection of utilities that help you customize Windows and streamline everyday tasks
                                                         | |
| 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
                                                         | |
| kgrzybek/modular-monolith-with-ddd 
                                                            Full Modular Monolith application with Domain-Driven Design approach.
                                                         | |
| dotnet/orleans 
                                                            Cloud Native application framework for .NET
                                                         | |
| HangfireIO/Hangfire 
                                                            An easy way to perform background job processing in .NET and .NET Core applications. No Windows Service or separate process required
                                                         | |
| unoplatform/uno 
                                                            Open-source platform for building cross-platform native Mobile, Web, Desktop and Embedded apps quickly.  Create rich, C#/XAML, single-codebase apps from any IDE. Hot Reload included! 90m+ NuGet Downloads!!
                                                         | |
| dotnet/machinelearning 
                                                            ML.NET is an open source and cross-platform machine learning framework for .NET.
                                                         | |
| 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. 
                                                         | |
| danielgerlag/workflow-core 
                                                            Lightweight workflow engine for .NET Standard
                                                         | |
| DotNetNext/SqlSugar 
                                                            .Net aot ORM   SqlServer ORM Mongodb ORM MySql  瀚高 Postgresql ORM  DB2 Hana 高斯 Duckdb C# VB.NET Sqlite  ORM Oracle ORM Mysql Orm 虚谷数据库 达梦 ORM 人大金仓 ORM 神通ORM  C# ORM , C# ORM .NET ORM NET9 ORM .NET8 ORM ClickHouse ORM QuestDb ,TDengine ORM,OceanBase ORM,GaussDB ORM,Tidb ORM Object/Relational Mapping
                                                         | |
| microsoft/WPF-Samples 
                                                            Repository for WPF related samples
                                                         | |
| ServiceStack/ServiceStack 
                                                            Thoughtfully architected, obscenely fast, thoroughly enjoyable web services for all
                                                         | |
| ClosedXML/ClosedXML 
                                                            ClosedXML is a .NET library for reading, manipulating and writing Excel 2007+ (.xlsx, .xlsm) files. It aims to provide an intuitive and user-friendly interface to dealing with the underlying OpenXML API.
                                                         | |
| protobuf-net/protobuf-net 
                                                            Protocol Buffers library for idiomatic .NET 
                                                         | |
| dotnet/winforms 
                                                            Windows Forms is a .NET UI framework for building Windows desktop applications.
                                                         | |
| Azure/azure-powershell 
                                                            Microsoft Azure PowerShell
                                                         | |
| opserver/Opserver 
                                                            Stack Exchange's Monitoring System
                                                         | 
| Version | Downloads | Last Updated | |
|---|---|---|---|
| 4.9.0 | 18,289,453 | 11/12/2024 | |
| 4.8.6 | 108,941,554 | 1/9/2024 | |
| 4.8.5 | 80,930,161 | 11/8/2022 | |
| 4.8.4 | 4,851,035 | 10/14/2022 | |
| 4.8.3 | 88,779,477 | 9/14/2021 | |
| 4.8.2 | 80,943,918 | 8/11/2020 | |
| 4.8.1 | 110,872,055 | 2/18/2020 | |
| 4.8.0 | 28,504,392 | 12/3/2019 | |
| 4.8.0-preview3.19551.4 | 90,051 | 11/13/2019 | |
| 4.8.0-preview2.19523.17 | 28,400 | 11/1/2019 | |
| 4.8.0-preview1.19504.10 | 50,633 | 10/15/2019 | |
| 4.7.0 | 38,104,306 | 9/23/2019 | |
| 4.7.0-rc1.19456.4 | 17,922 | 9/16/2019 | |
| 4.7.0-preview9.19421.4 | 19,947 | 9/4/2019 | |
| 4.7.0-preview9.19416.11 | 1,571 | 9/4/2019 | |
| 4.7.0-preview8.19405.3 | 75,729 | 8/13/2019 | |
| 4.7.0-preview7.19362.9 | 189,441 | 7/23/2019 | |
| 4.7.0-preview6.19303.8 | 1,434,828 | 6/12/2019 | |
| 4.7.0-preview6.19264.9 | 3,680 | 9/4/2019 | |
| 4.7.0-preview5.19224.8 | 143,245 | 5/6/2019 | |
| 4.7.0-preview4.19212.13 | 341,411 | 4/18/2019 | |
| 4.7.0-preview3.19128.7 | 96,432 | 3/6/2019 | |
| 4.7.0-preview.19073.11 | 61,497 | 1/29/2019 | |
| 4.7.0-preview.18571.3 | 86,720 | 12/3/2018 | |
| 4.6.1 | 41,235,303 | 5/14/2019 | |
| 4.6.0 | 60,845,822 | 12/3/2018 | |
| 4.6.0-preview3-27014-02 | 185,811 | 10/17/2018 | |
| 4.6.0-preview2-26905-02 | 130,917 | 9/12/2018 | |
| 4.5.3 | 907,692 | 2/18/2020 | |
| 4.5.1 | 57,505,053 | 6/18/2018 | |
| 4.5.0 | 30,944,907 | 5/29/2018 | |
| 4.5.0-rc1 | 185,938 | 5/6/2018 | |
| 4.5.0-preview2-26406-04 | 247,913 | 4/10/2018 | |
| 4.5.0-preview1-26216-02 | 276,437 | 2/26/2018 | |
| 4.4.3 | 28,095,636 | 3/13/2018 | |
| 4.4.2 | 32,807,605 | 12/12/2017 | |
| 4.4.1 | 69,733 | 12/12/2017 | |
| 4.4.0 | 135,400,204 | 8/11/2017 | |
| 4.4.0-preview2-25405-01 | 319,825 | 6/27/2017 | |
| 4.4.0-preview1-25305-02 | 181,880 | 5/9/2017 | |
| 4.3.1 | 52,446,680 | 5/9/2017 | |
| 4.3.0 | 15,182,298 | 11/15/2016 | |
| 4.3.0-preview1-24530-04 | 36,487 | 10/24/2016 | |
| 4.1.0 | 21,104,647 | 6/27/2016 | |
| 4.1.0-rc2-24027 | 153,840 | 5/16/2016 | |
| 4.0.0-beta-23516 | 139,756 | 11/18/2015 | |
| 4.0.0-beta-23409 | 28,845 | 10/15/2015 | |
| 4.0.0-beta-23225 | 19,003 | 9/1/2015 | |
| 4.0.0-beta-23123 | 12,230 | 7/29/2015 | |
| 4.0.0-beta-23109 | 15,442 | 7/27/2015 | |
| 4.0.0-beta-23019 | 25,950 | 6/30/2015 | |
| 4.0.0-beta-22816 | 29,705 | 4/24/2015 | |
| 4.0.0-beta-22605 | 16,499 | 2/13/2015 | |
| 1.0.0-beta2 | 18,935 | 1/16/2015 | |
| 1.0.0-beta1 | 23,692 | 11/11/2014 |