Hello everyone, today you can download Microsoft.Data.SqlClient 2.0.0 to better manage your databases on your .NET apps. With the way things are heading over at Microsoft, I highly recommend those of you who haven’t upgraded to the latest version of this SqlClient, to do so asap, the new version is so smooth and it addresses a lot of bugs and adds a bunch of new features that I will list for you right below.
Table of Contents
What Is Microsoft.Data.SqlClient?
Microsoft.Data.SqlClient is a data provider for Microsoft SQL Server and Azure SQL Database. Now in General Availability, it is a union of the two System.Data.SqlClient components which live independently in .NET Framework and .NET Core. Going forward, support for new SQL Server features will be implemented in Microsoft.Data.SqlClient.
Microsoft.Data.SqlClient 2.0.0 Features
- Added internal driver support to provide resiliency to DNS failures
- Added support forActive Directory Integrated, Active Directory Interactive and Active Directory Service Principal authentication mode for .NET Core and .NET Standard
- Added support for Active Directory Service Principal authentication mode for .NET Framework
- Added support for optional ORDER hints in SqlBulkCopy for improved performance
The ORDER hint it allow to you to greatly improve performances if the data you want to import is already ordered by the target’s table clustered index. By informing the database engine that data is coming in already ordered, data can be loaded as is, without an additional sorting step, that usually is the most expensive on the whole operation.
Install Microsoft.Data.SqlClient 2.0.0
Manual Install Microsoft.Data.SqlClient 2.0.0 using NuGET
dotnet add package Microsoft.Data.SqlClient