Released: General Availability of Microsoft.Data.SqlClient 3.0

Published Jun 09 2021 12:35 PM 5,940 Views
Senior Member

We have released for general availability Microsoft.Data.SqlClient 3.0. This .NET Data Provider for SQL Server provides general connectivity to the database and supports all the latest SQL Server features for applications targeting .NET Framework, .NET Core, and .NET Standard.

 

To try out the new package, add a NuGet reference to Microsoft.Data.SqlClient in your application.

 

If you've been following our preview releases, you know we've been busy working to add features and improve stability and performance of the Microsoft.Data.SqlClient library.

 

Some of the highlights of new features in 3.0 over the 2.1 release of Microsoft.Data.SqlClient include:

 

There are a few minor breaking changes in 3.0 over previous releases.

  • .NET Framework 4.6.1 is the new minimum .NET Framework version supported
  • The User Id connection property now requires Client Id instead of Object Id for User-Assigned Managed Identity when using the Active Directory Managed Identity authentication option
  • SqlDataReader now returns a DBNull value instead of an empty byte[] for RowVersion/Timestamp values. Legacy behavior can be enabled by setting an AppContext switch.

 

For the full list of added features, fixes, and changes in Microsoft.Data.SqlClient 3.0, please see the Release Notes.

 

Again, to try out the new package, add a NuGet reference to Microsoft.Data.SqlClient in your application. If you encounter any issues or have any feedback, head over to the SqlClient GitHub repository and submit an issue.

 

David Engel

 

 

%3CLINGO-SUB%20id%3D%22lingo-sub-2432251%22%20slang%3D%22en-US%22%3EReleased%3A%20General%20Availability%20of%20Microsoft.Data.SqlClient%203.0%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2432251%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20have%20released%20for%20general%20availability%20Microsoft.Data.SqlClient%203.0.%20This%20.NET%20Data%20Provider%20for%20SQL%20Server%20provides%20general%20connectivity%20to%20the%20database%20and%20supports%20all%20the%20latest%20SQL%20Server%20features%20for%20applications%20targeting%20.NET%20Framework%2C%20.NET%20Core%2C%20and%20.NET%20Standard.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETo%20try%20out%20the%20new%20package%2C%20add%20a%20%3CA%20href%3D%22https%3A%2F%2Fwww.nuget.org%2Fpackages%2FMicrosoft.Data.SqlClient%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3ENuGet%20reference%20to%20Microsoft.Data.SqlClient%3C%2FA%3E%26nbsp%3Bin%20your%20application.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you've%20been%20following%20our%20preview%20releases%2C%20you%20know%20we've%20been%20busy%20working%20to%20add%20features%20and%20improve%20stability%20and%20performance%20of%20the%20Microsoft.Data.SqlClient%20library.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESome%20of%20the%20highlights%20of%20new%20features%20in%203.0%20over%20the%202.1%20release%20of%20Microsoft.Data.SqlClient%20include%3A%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fdotnet%2FSqlClient%2Fblob%2Fmain%2Frelease-notes%2F3.0%2F3.0.0.md%23configurable-retry-logic%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EConfigurable%20Retry%20Logic%3C%2FA%3E%26nbsp%3B%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fdotnet%2FSqlClient%2Fblob%2Fmain%2Frelease-notes%2F3.0%2F3.0.0.md%23event-counters%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EEvent%20Counters%20on%20.NET%20Core%20and%20.NET%20Standard%3C%2FA%3E%26nbsp%3B%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fdotnet%2FSqlClient%2Fblob%2Fmain%2Frelease-notes%2F3.0%2F3.0.0.md%23azure-identity-dependency-introduction%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EAzure%20Identity%20dependency%20introduction%3C%2FA%3E%26nbsp%3B%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fdotnet%2FSqlClient%2Fblob%2Fmain%2Frelease-notes%2F3.0%2F3.0.0.md%23event-tracing-improvements-in-snidll%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EEvent%20tracing%20improvements%20in%20SNI.dll%3C%2FA%3E%26nbsp%3B%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fdotnet%2FSqlClient%2Fblob%2Fmain%2Frelease-notes%2F3.0%2F3.0.0.md%23enabling-row-version-null-behavior%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3ERow%20version%20null%20behavior%3C%2FA%3E%26nbsp%3B(breaking%20change)%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fdotnet%2FSqlClient%2Fblob%2Fmain%2Frelease-notes%2F3.0%2F3.0.0.md%23active-directory-default-authentication-support%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EActive%20Directory%20Default%20authentication%20support%3C%2FA%3E%26nbsp%3B%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fdotnet%2FSqlClient%2Fblob%2Fmain%2Frelease-notes%2F3.0%2F3.0.0.md%23custom-master-key-store-provider-registration-enhancements%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3ECustom%20key%20store%20provider%20registration%20enhancements%3C%2FA%3E%26nbsp%3B%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fdotnet%2FSqlClient%2Fblob%2Fmain%2Frelease-notes%2F3.0%2F3.0.0.md%23ip-address-preference%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EIP%20Address%20preference%3C%2FA%3E%26nbsp%3B(IPv4%20vs%20IPv6)%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThere%20are%20a%20few%20minor%20breaking%20changes%20in%203.0%20over%20previous%20releases.%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3E.NET%20Framework%204.6.1%20is%20the%20new%20minimum%20.NET%20Framework%20version%20supported%3C%2FLI%3E%0A%3CLI%3EThe%20User%20Id%20connection%20property%20now%20requires%20Client%20Id%20instead%20of%20Object%20Id%20for%20User-Assigned%20Managed%20Identity%20when%20using%20the%20Active%20Directory%20Managed%20Identity%20authentication%20option%3C%2FLI%3E%0A%3CLI%3ESqlDataReader%20now%20returns%20a%20DBNull%20value%20instead%20of%20an%20empty%20byte%5B%5D%20for%20RowVersion%2FTimestamp%20values.%20Legacy%20behavior%20can%20be%20enabled%20by%20setting%20an%20AppContext%20switch.%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFor%20the%20full%20list%20of%20added%20features%2C%20fixes%2C%20and%20changes%20in%20Microsoft.Data.SqlClient%203.0%2C%20please%20see%20the%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fdotnet%2FSqlClient%2Fblob%2Fmaster%2Frelease-notes%2F3.0%2F3.0.0.md%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3ERelease%20Notes%3C%2FA%3E.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAgain%2C%20to%20try%20out%20the%20new%20package%2C%20add%20a%20%3CA%20href%3D%22https%3A%2F%2Fwww.nuget.org%2Fpackages%2FMicrosoft.Data.SqlClient%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3ENuGet%20reference%20to%20Microsoft.Data.SqlClient%3C%2FA%3E%26nbsp%3Bin%20your%20application.%20If%20you%20encounter%20any%20issues%20or%20have%20any%20feedback%2C%20head%20over%20to%20the%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fdotnet%2FSqlClient%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3ESqlClient%20GitHub%20repository%3C%2FA%3E%20and%20submit%20an%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2Fdotnet%2FSqlClient%2Fissues%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3Eissue%3C%2FA%3E.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDavid%20Engel%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-2432251%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20have%20released%20for%20general%20availability%20Microsoft.Data.SqlClient%203.0.%20This%20.NET%20Data%20Provider%20for%20SQL%20Server%20provides%20connectivity%20to%20the%20database%20and%20supports%20all%20the%20latest%20features%20for%20applications%20targeting%20.NET%20Framework%2C%20.NET%20Core%2C%20and%20.NET%20Standard.%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2432251%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESQLServerDrivers%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Co-Authors
Version history
Last update:
‎Jun 09 2021 12:35 PM
Updated by: