Info
| Version: | 5.2.0 |
| Author(s): | Microsoft |
| Last Update: | Wednesday, February 28, 2024 |
| .NET Fiddle: | Online Example |
| Project Url: | https://aka.ms/sqlclientproject |
| NuGet Url: | https://www.nuget.org/packages/Microsoft.Data.SqlClient |
Install
Install-Package Microsoft.Data.SqlClient
dotnet add package Microsoft.Data.SqlClient
paket add Microsoft.Data.SqlClient
Microsoft.Data.SqlClient Download (Unzip the "nupkg" after downloading)
Dependencies
.NETStandard 2.0
- Microsoft.Data.SqlClient.SNI.runtime(>= 2.1.1)
- Microsoft.Win32.Registry(>= 4.7.0)
- System.Buffers(>= 4.5.1)
- System.Memory(>= 4.5.4)
- System.Security.Principal.Windows(>= 4.7.0)
- System.Text.Encoding.CodePages(>= 4.7.0)
- Microsoft.Identity.Client(>= 4.21.1)
- Microsoft.IdentityModel.Protocols.OpenIdConnect(>= 6.8.0)
- Microsoft.IdentityModel.JsonWebTokens(>= 6.8.0)
- Microsoft.Data.SqlClient.SNI(>= 2.1.1)
- Microsoft.Identity.Client(>= 4.21.1)
- Microsoft.IdentityModel.Protocols.OpenIdConnect(>= 6.8.0)
- Microsoft.IdentityModel.JsonWebTokens(>= 6.8.0)
- Microsoft.Data.SqlClient.SNI.runtime(>= 2.1.1)
- Microsoft.Win32.Registry(>= 4.7.0)
- System.Security.Principal.Windows(>= 4.7.0)
- System.Text.Encoding.CodePages(>= 4.7.0)
- System.Diagnostics.DiagnosticSource(>= 4.7.0)
- System.Configuration.ConfigurationManager(>= 4.7.0)
- System.Runtime.Caching(>= 4.7.0)
- Microsoft.Identity.Client(>= 4.21.1)
- Microsoft.IdentityModel.Protocols.OpenIdConnect(>= 6.8.0)
- Microsoft.IdentityModel.JsonWebTokens(>= 6.8.0)
- Microsoft.Data.SqlClient.SNI.runtime(>= 2.1.1)
- Microsoft.Win32.Registry(>= 4.7.0)
- System.Security.Principal.Windows(>= 4.7.0)
- System.Text.Encoding.CodePages(>= 4.7.0)
- System.Diagnostics.DiagnosticSource(>= 4.7.0)
- System.Configuration.ConfigurationManager(>= 4.7.0)
- System.Runtime.Caching(>= 4.7.0)
- Microsoft.Identity.Client(>= 4.21.1)
- Microsoft.IdentityModel.Protocols.OpenIdConnect(>= 6.8.0)
- Microsoft.IdentityModel.JsonWebTokens(>= 6.8.0)
- Microsoft.Data.SqlClient.SNI.runtime(>= 2.1.1)
- Microsoft.Win32.Registry(>= 4.7.0)
- System.Buffers(>= 4.5.1)
- System.Memory(>= 4.5.4)
- System.Security.Principal.Windows(>= 4.7.0)
- System.Text.Encoding.CodePages(>= 4.7.0)
- Microsoft.Identity.Client(>= 4.21.1)
- Microsoft.IdentityModel.Protocols.OpenIdConnect(>= 6.8.0)
- Microsoft.IdentityModel.JsonWebTokens(>= 6.8.0)
Tags
This has replaced System.Data.SqlClient. These classes provide access to SQL and encapsulate database-specific protocols, including tabular data stream (TDS).
Commonly Used Types:
Microsoft.Data.SqlClient.SqlConnection
Microsoft.Data.SqlClient.SqlException
Microsoft.Data.SqlClient.SqlParameter
Microsoft.Data.SqlClient.SqlDataReader
Microsoft.Data.SqlClient.SqlCommand
Microsoft.Data.SqlClient.SqlTransaction
Microsoft.Data.SqlClient.SqlParameterCollection
Microsoft.Data.SqlClient.SqlClientFactory
When using NuGet 3.x this package requires at least version 3.4.