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 |
|---|---|
|
Masuit.Tools.Core
包含一些常用的操作类，大都是静态类，加密解密，反射操作，硬件信息，字符串扩展方法，日期时间扩展操作，大文件拷贝，图像裁剪，html处理，验证码、NoSql等常用封装。
示例代码：
1.检验字符串是否是Email
bool isEmail="1170397736@qq.com".MatchEmail();
2.获取线程内唯一对象
CallContext<T>.GetData("db");
3.获取当前请求上下文
var context=HttpContext2.Current;
4.获取IP详细地理信息
var address="114.114.114.114".GetPhysicsAddress();
5.大文件操作
FileStream fs = new FileStream(@"D:\boot.vmdk", FileMode.OpenOrCreate, FileAccess.ReadWrite);
{
//fs.CopyToFile(@"D:\1.bak");//同步复制大文件
fs.CopyToFileAsync(@"D:\1.bak");//异步复制大文件
string md5 = fs.GetFileMD5Async().Result;//异步获取文件的MD5
}
6.html的防XSS处理：
string html = @"<link href="/Content/font-awesome/css" rel="stylesheet" />
<!--[if IE 7]>
<link href='/Content/font-awesome-ie7.min.css' rel='stylesheet'/>
<![endif]-->
<script src="/Scripts/modernizr"></script>
<div id="searchBox" role="search">
<form action="/packages" method="get">
<span class="user-actions"><a href="/users/account/LogOff">退出</a></span>
<input name="q" id="searchBoxInput" />
<input id="searchBoxSubmit" type="submit" value="Submit" />
</form>
</div>";
string s = html.HtmlSantinizerStandard();//清理后：<div><span><a href="/users/account/LogOff">退出</a></span></div>
|
3 |
|
Microsoft.Extensions.Caching.SqlServer
Distributed cache implementation of Microsoft.Extensions.Caching.Distributed.IDistributedCache using Microsoft SQL Server.
|
3 |
|
Microsoft.Extensions.Caching.SqlServer
Distributed cache implementation of Microsoft.Extensions.Caching.Distributed.IDistributedCache using Microsoft SQL Server.
|
2 |
|
Microsoft.EntityFrameworkCore.SqlServer
Microsoft SQL Server database provider for Entity Framework Core.
|
2 |
|
Masuit.Tools.Core
包含一些常用的操作类，大都是静态类，加密解密，反射操作，硬件信息，字符串扩展方法，日期时间扩展操作，大文件拷贝，图像裁剪，html处理，验证码、NoSql等常用封装。
示例代码：
1.检验字符串是否是Email
bool isEmail="1170397736@qq.com".MatchEmail();
2.获取CPU核心数
int core = SystemInfo.GetCpuCount();
3.大文件操作
FileStream fs = new FileStream(@"D:\boot.vmdk", FileMode.OpenOrCreate, FileAccess.ReadWrite);
{
//fs.CopyToFile(@"D:\1.bak");//同步复制大文件
fs.CopyToFileAsync(@"D:\1.bak");//异步复制大文件
string md5 = fs.GetFileMD5Async().Result;//异步获取文件的MD5
}
4.html的防XSS处理：
string html = @"<link href="/Content/font-awesome/css" rel="stylesheet" /><!--[if IE 7]>
<link href='/Content/font-awesome-ie7.min.css' rel='stylesheet'/>
<![endif]--><script src="/Scripts/modernizr"></script><div id="searchBox" role="search"><form action="/packages" method="get"><span class="user-actions"><a href="/users/account/LogOff">退出</a></span><input name="q" id="searchBoxInput" /><input id="searchBoxSubmit" type="submit" value="Submit" /></form></div>";
string s = html.HtmlSantinizerStandard();//清理后：<div><span><a href="/users/account/LogOff">退出</a></span></div>
5.整理操作系统的内存：
Windows.ClearMemorySilent();
......
|
2 |
|
Masuit.Tools.Core
包含一些常用的操作类，大都是静态类，加密解密，反射操作，硬件信息，字符串扩展方法，日期时间扩展操作，大文件拷贝，图像裁剪，html处理，验证码、NoSql等常用封装。
示例代码：
1.检验字符串是否是Email
bool isEmail="1170397736@qq.com".MatchEmail();
2.获取线程内唯一对象
CallContext<T>.GetData("db");
3.获取当前请求上下文
var context=HttpContext2.Current;
4.获取IP详细地理信息
var address="114.114.114.114".GetPhysicsAddress();
5.大文件操作
FileStream fs = new FileStream(@"D:\boot.vmdk", FileMode.OpenOrCreate, FileAccess.ReadWrite);
{
//fs.CopyToFile(@"D:\1.bak");//同步复制大文件
fs.CopyToFileAsync(@"D:\1.bak");//异步复制大文件
string md5 = fs.GetFileMD5Async().Result;//异步获取文件的MD5
}
6.html的防XSS处理：
string html = @"<link href="/Content/font-awesome/css" rel="stylesheet" />
<!--[if IE 7]>
<link href='/Content/font-awesome-ie7.min.css' rel='stylesheet'/>
<![endif]-->
<script src="/Scripts/modernizr"></script>
<div id="searchBox" role="search">
<form action="/packages" method="get">
<span class="user-actions"><a href="/users/account/LogOff">退出</a></span>
<input name="q" id="searchBoxInput" />
<input id="searchBoxSubmit" type="submit" value="Submit" />
</form>
</div>";
string s = html.HtmlSantinizerStandard();//清理后：<div><span><a href="/users/account/LogOff">退出</a></span></div>
|
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.
| Version | Downloads | Last updated |
|---|---|---|
| 4.9.0 | 1 | 01/10/2026 |
| 4.8.6 | 1 | 01/10/2026 |
| 4.8.5 | 1 | 01/10/2026 |
| 4.8.4 | 1 | 01/10/2026 |
| 4.8.3 | 1 | 01/10/2026 |
| 4.8.2 | 1 | 01/10/2026 |
| 4.8.1 | 1 | 01/10/2026 |
| 4.8.0 | 1 | 01/10/2026 |
| 4.8.0-preview3.19551.4 | 1 | 01/10/2026 |
| 4.8.0-preview2.19523.17 | 1 | 01/10/2026 |
| 4.8.0-preview1.19504.10 | 1 | 01/10/2026 |
| 4.7.0 | 1 | 01/10/2026 |
| 4.7.0-rc1.19456.4 | 0 | 09/16/2019 |
| 4.7.0-preview9.19421.4 | 1 | 01/10/2026 |
| 4.7.0-preview9.19416.11 | 1 | 01/10/2026 |
| 4.7.0-preview8.19405.3 | 1 | 01/10/2026 |
| 4.7.0-preview7.19362.9 | 1 | 01/10/2026 |
| 4.7.0-preview6.19303.8 | 1 | 01/10/2026 |
| 4.7.0-preview6.19264.9 | 1 | 01/10/2026 |
| 4.7.0-preview5.19224.8 | 1 | 01/10/2026 |
| 4.7.0-preview4.19212.13 | 1 | 01/10/2026 |
| 4.7.0-preview3.19128.7 | 1 | 01/10/2026 |
| 4.7.0-preview.19073.11 | 1 | 01/10/2026 |
| 4.7.0-preview.18571.3 | 0 | 12/03/2018 |
| 4.6.1 | 1 | 01/10/2026 |
| 4.6.0 | 1 | 01/10/2026 |
| 4.6.0-preview3-27014-02 | 1 | 01/10/2026 |
| 4.6.0-preview2-26905-02 | 1 | 01/10/2026 |
| 4.5.3 | 1 | 01/10/2026 |
| 4.5.1 | 1 | 01/10/2026 |
| 4.5.0 | 1 | 01/10/2026 |
| 4.5.0-rc1 | 1 | 01/10/2026 |
| 4.5.0-preview2-26406-04 | 1 | 01/10/2026 |
| 4.5.0-preview1-26216-02 | 1 | 01/10/2026 |
| 4.4.3 | 1 | 01/10/2026 |
| 4.4.2 | 1 | 01/10/2026 |
| 4.4.1 | 1 | 01/10/2026 |
| 4.4.0 | 1 | 01/10/2026 |
| 4.4.0-preview2-25405-01 | 1 | 01/10/2026 |
| 4.4.0-preview1-25305-02 | 1 | 01/10/2026 |
| 4.3.1 | 1 | 01/10/2026 |
| 4.3.0 | 1 | 01/10/2026 |
| 4.3.0-preview1-24530-04 | 1 | 01/10/2026 |
| 4.1.0 | 1 | 01/10/2026 |
| 4.1.0-rc2-24027 | 0 | 05/16/2016 |
| 4.0.0-beta-23516 | 1 | 01/10/2026 |
| 4.0.0-beta-23409 | 1 | 01/10/2026 |
| 4.0.0-beta-23225 | 1 | 01/10/2026 |
| 4.0.0-beta-23123 | 1 | 01/10/2026 |
| 4.0.0-beta-23109 | 1 | 01/10/2026 |
| 4.0.0-beta-23019 | 1 | 01/10/2026 |
| 4.0.0-beta-22816 | 1 | 01/10/2026 |
| 4.0.0-beta-22605 | 1 | 01/10/2026 |
| 1.0.0-beta2 | 1 | 01/10/2026 |
| 1.0.0-beta1 | 1 | 01/10/2026 |