System.Data.SqlClient 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.
Showing the top 20 packages that depend on System.Data.SqlClient.
| Packages | Downloads |
|---|---|
|
Hangfire.SqlServer
SQL Server 2008+ (including Express), SQL Server LocalDB and SQL Azure storage support for Hangfire (background job system for ASP.NET applications).
|
16 |
|
EntityFramework
Entity Framework 6 (EF6) is a tried and tested object-relational mapper for .NET with many years of feature development and stabilization.
|
6 |
|
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.
|
6 |
|
Dapper
A high performance Micro-ORM supporting SQL Server, MySQL, Sqlite, SqlCE, Firebird etc..
|
5 |
|
dotMorten.Microsoft.SqlServer.Types
Allows you to use SQL Server spatial SqlHierarchy types on a machine without SQL Server installed and decode these UDT types in any .NET Standard client
|
5 |
|
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.
|
5 |
|
Serilog.Sinks.MSSqlServer
A Serilog sink that writes events to Microsoft SQL Server
|
5 |
|
Microsoft.Extensions.Caching.SqlServer
Distributed cache implementation of Microsoft.Extensions.Caching.Distributed.IDistributedCache using Microsoft SQL Server.
|
4 |
|
Z.Expressions.Eval
Evaluate, Compile and Execute C# code at runtime.
Support: Dynamic LINQ, Extension Method, Expando Object, and more!
Online Example: https://dotnetfiddle.net/COq6FC
Include free and prime features.
|
4 |
|
Microsoft.EntityFrameworkCore.SqlServer
Microsoft SQL Server database provider for Entity Framework Core.
|
4 |
|
OpenTracing.Contrib.NetCore
Adds OpenTracing instrumentation for .NET Core apps that use the `Microsoft.Extensions.*` stack.
Instrumented components: HttpClient calls, ASP.NET Core, Entity Framework Core and any other library that uses DiagnosticSource events.
|
4 |
|
dotMorten.Microsoft.SqlServer.Types
Allows you to use SQL Server spatial SqlHierarchy types on a machine without SQL Server installed and decode these UDT types in any .NET Standard client
|
4 |
|
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 Core as well as .NET Standard.
When using NuGet 3.x this package requires at least version 3.4.
|
4 |
|
Hangfire.SqlServer
SQL Server 2008+ (including Express), SQL Server LocalDB and SQL Azure storage support for Hangfire (background job system for ASP.NET applications).
|
4 |
|
Serilog.Sinks.MSSqlServer
A Serilog sink that writes events to Microsoft SQL Server
|
4 |
|
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 Core as well as .NET Standard.
|
4 |
.NET Framework 4.6.2
- No dependencies.
.NET 6.0
- runtime.native.System.Data.SqlClient.sni (>= 4.4.0)
.NET 8.0
- runtime.native.System.Data.SqlClient.sni (>= 4.4.0)
.NET Standard 2.0
- No dependencies.
| Version | Downloads | Last updated |
|---|---|---|
| 4.9.0 | 1 | 11/30/2024 |
| 4.8.6 | 5 | 10/05/2024 |
| 4.8.5 | 6 | 03/04/2024 |
| 4.8.4 | 4 | 10/06/2024 |
| 4.8.3 | 5 | 12/11/2022 |
| 4.8.2 | 4 | 10/06/2024 |
| 4.8.1 | 3 | 11/06/2024 |
| 4.8.0 | 4 | 10/06/2024 |
| 4.8.0-preview3.19551.4 | 3 | 10/28/2024 |
| 4.8.0-preview2.19523.17 | 4 | 10/06/2024 |
| 4.8.0-preview1.19504.10 | 2 | 10/06/2024 |
| 4.7.0 | 4 | 10/06/2024 |
| 4.7.0-rc1.19456.4 | 1 | 11/19/2024 |
| 4.7.0-preview9.19421.4 | 3 | 10/06/2024 |
| 4.7.0-preview9.19416.11 | 2 | 11/19/2024 |
| 4.7.0-preview8.19405.3 | 2 | 10/06/2024 |
| 4.7.0-preview7.19362.9 | 2 | 11/19/2024 |
| 4.7.0-preview6.19303.8 | 3 | 10/06/2024 |
| 4.7.0-preview6.19264.9 | 2 | 11/19/2024 |
| 4.7.0-preview5.19224.8 | 2 | 11/19/2024 |
| 4.7.0-preview4.19212.13 | 1 | 11/19/2024 |
| 4.7.0-preview3.19128.7 | 2 | 11/19/2024 |
| 4.7.0-preview.19073.11 | 2 | 11/19/2024 |
| 4.7.0-preview.18571.3 | 2 | 10/06/2024 |
| 4.6.1 | 3 | 10/24/2024 |
| 4.6.0 | 3 | 11/04/2024 |
| 4.6.0-preview3-27014-02 | 2 | 11/03/2024 |
| 4.6.0-preview2-26905-02 | 3 | 10/06/2024 |
| 4.5.3 | 3 | 11/30/2024 |
| 4.5.1 | 3 | 10/12/2024 |
| 4.5.0 | 3 | 10/11/2024 |
| 4.5.0-rc1 | 3 | 11/30/2024 |
| 4.5.0-preview2-26406-04 | 2 | 11/19/2024 |
| 4.5.0-preview1-26216-02 | 2 | 10/06/2024 |
| 4.4.3 | 5 | 11/09/2022 |
| 4.4.2 | 3 | 10/26/2024 |
| 4.4.1 | 2 | 11/04/2024 |
| 4.4.0 | 7 | 04/20/2022 |
| 4.4.0-preview2-25405-01 | 3 | 10/19/2024 |
| 4.4.0-preview1-25305-02 | 2 | 11/19/2024 |
| 4.3.1 | 3 | 10/10/2024 |
| 4.3.0 | 4 | 10/06/2024 |
| 4.3.0-preview1-24530-04 | 3 | 10/06/2024 |
| 4.1.0 | 5 | 04/20/2022 |
| 4.1.0-rc2-24027 | 1 | 11/30/2024 |
| 4.0.0-beta-23516 | 3 | 10/06/2024 |
| 4.0.0-beta-23409 | 3 | 10/06/2024 |
| 4.0.0-beta-23225 | 3 | 10/06/2024 |
| 4.0.0-beta-23123 | 2 | 11/30/2024 |
| 4.0.0-beta-23109 | 3 | 10/06/2024 |
| 4.0.0-beta-23019 | 3 | 10/06/2024 |
| 4.0.0-beta-22816 | 3 | 10/06/2024 |
| 4.0.0-beta-22605 | 3 | 10/06/2024 |
| 1.0.0-beta2 | 4 | 10/06/2024 |
| 1.0.0-beta1 | 4 | 10/06/2024 |