Released: General Availability of Microsoft.Data.SqlClient 2.0

We have released for general availability Microsoft.Data.SqlClient 2.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 to and improve the experience when taking a dependency on the Microsoft.Data.SqlClient library.

Some of the highlights of new features over the 1.1 release of Microsoft.Data.SqlClient include:

• Support for Active Directory Integrated and Interactive authentication modes when targeting .NET Core and .NET Standard
• Support for Active Directory Service Principal authentication
• EventSource tracing support
• SNI dependency changes
• SqlBulkCopy RowsCopied property
• Connection Open Overrides
• Order Hints for SqlBulkCopy

For the full list of added features, fixes, and changes in Microsoft.Data.SqlClient 2.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