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 |
|---|---|
|
DevExpress.DataAccess
This package enables you to connect to various data providers (such as databases, Excel and CSV files, Entity Framework and object data sources).
|
27 |
|
DevExpress.DataAccess
This package enables you to connect to various data providers (such as databases, Excel and CSV files, Entity Framework and object data sources).
|
18 |
|
DevExpress.DataAccess
This package enables you to connect to various data providers (such as databases, Excel and CSV files, Entity Framework and object data sources).
|
15 |
|
DevExpress.DataAccess
This package enables you to connect to various data providers (such as databases, Excel and CSV files, Entity Framework and object data sources).
|
13 |
|
DevExpress.Xpo
eXpress Persistent Objects (XPO) is an Object-Relational Mapping (ORM) tool that handles all aspects of database creation and object persistence, allowing you to concentrate on your application's business logic. XPO supports more than a dozen database management systems and implements a common high-level API. Whether using MS SQL Server, PostgreSQL, MySQL, Oracle, or others, you will use the same code to implement data access and management operations. Should you decide to move your storage to a different database system, you’ll only need to change the connection string. For more information, see https://DevExpress.com/XPO.
|
6 |
|
DevExpress.Xpo
eXpress Persistent Objects (XPO) is an Object-Relational Mapping (ORM) tool that handles all aspects of database creation and object persistence, allowing you to concentrate on your application's business logic. XPO supports more than a dozen database management systems and implements a common high-level API. Whether using MS SQL Server, PostgreSQL, MySQL, Oracle, or others, you will use the same code to implement data access and management operations. Should you decide to move your storage to a different database system, you’ll only need to change the connection string. For more information, see https://DevExpress.com/XPO.
|
5 |
|
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 |
|
DevExpress.DataAccess
This package enables you to connect to various data providers (such as databases, Excel and CSV files, Entity Framework and object data sources).
|
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).
|
3 |
|
SqlTableDependency
SqlTableDependency is a high-level implementation to access table record change notifications from SQL Server. This class allows you to detect changes on a database table. Every change will send a notification messages contains values for the updated, inserted or deleted record, avoid you to execute a further select to update your application data. If you want to use record change notifications without paying attention to the underlying Service Broker infrastructure, the SqlTableDependency class is your choice. The SqlTableDependency class represents a notification dependency between an application and a SQL Server Table. When you use SqlTableDependency to get notifications, this componenet provides the low-level implementation creating the Queue and Service Broker. In this way SqlTableDependency class provides access to notifications without knowing anything about the underlying Service Broker infrastructure. Once a record change happens, SqlTableDependency's event subscribers are notified.
|
3 |
|
DevExpress.Xpo
eXpress Persistent Objects (XPO) is an Object-Relational Mapping (ORM) tool that handles all aspects of database creation and object persistence, allowing you to concentrate on your application's business logic. XPO supports more than a dozen database management systems and implements a common high-level API. Whether using MS SQL Server, PostgreSQL, MySQL, Oracle, or others, you will use the same code to implement data access and management operations. Should you decide to move your storage to a different database system, you’ll only need to change the connection string. For more information, see https://DevExpress.com/XPO.
|
3 |
|
EntityFramework
Entity Framework 6 (EF6) is a tried and tested object-relational mapper for .NET with many years of feature development and stabilization.
|
2 |
|
DevExpress.ExpressApp.AuditTrail.EFCore
The Audit Trail module for Entity Framework Core-based XAF apps.
|
2 |
|
DevExpress.Win.Map
This package provides functionality for DevExpress Map Control that allows your end-users to browse terrain data.
|
2 |
|
DevExpress.Xpo
eXpress Persistent Objects (XPO) is an Object-Relational Mapping (ORM) tool that handles all aspects of database creation and object persistence, allowing you to concentrate on your application's business logic. XPO supports more than a dozen database management systems and implements a common high-level API. Whether using MS SQL Server, PostgreSQL, MySQL, Oracle, or others, you will use the same code to implement data access and management operations. Should you decide to move your storage to a different database system, you’ll only need to change the connection string. For more information, see https://DevExpress.com/XPO.
|
2 |
|
Microsoft.Extensions.Caching.SqlServer
Distributed cache implementation of Microsoft.Extensions.Caching.Distributed.IDistributedCache using Microsoft SQL Server.
|
2 |
|
AspNetCore.Reporting
Description:
AspNetCore.Reporting, LocalReport, ServerReport, SSRS, ReportViewer
|
2 |
|
AspNetCore.ReportingServices
AspNetCore.ReportingServices
used for AspNetCore.Reporting
|
2 |
.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.