Released: Multiple Microsoft.Data.SqlClient Updates

This post has been republished via RSS; it originally appeared at: Microsoft Tech Community - Latest Blogs - .

We have released multiple updates to supported versions of Microsoft.Data.SqlClient in the last couple of months. Just because it's been quiet on here doesn't mean we haven't been busy. Quite the opposite, in fact. Here's a summary of the Microsoft.Data.SqlClient updates we've released.

Microsoft.Data.SqlClient 3.1.2

With this update, we also changed the 3.1 line to Long Term Support (LTS), extending the support end date to March 10, 2023.

Added

• Added Windows ARM64 support when targeting .NET Framework. #1908

Fixed

• Fixed thread safety of transient error list in configurable retry logic. #1911
• Fixed deadlock when using SinglePhaseCommit with distributed transactions. #1912
• Fixed Default UTF8 collation conflict. #1910
• Added CommandText length validation when using stored procedure command types. #1909

For the detailed list of changes in Microsoft.Data.SqlClient 3.1.2, you can also see the Release Notes.

Microsoft.Data.SqlClient 3.1.3

Fixed

• Fixed throttling of token requests by calling AcquireTokenSilent in AAD Integrated/Password flows when the account is already cached.#1926
• Fixed TDS RPC error on large queries in SqlCommand.ExecuteReaderAsync.#1939

For the detailed list of changes in Microsoft.Data.SqlClient 3.1.3, you can also see the Release Notes.

Microsoft.Data.SqlClient 5.1.1

Fixed

• Fixed an incorrect exception when a symmetric key fails to decrypt a column using Always Encrypted. #1968
• Fixed TransactionScope connection issue when Enlist is enabled, Pooling is disabled, and Network Connection Type is set to Redirect. #1967
• Fixed throttling of token requests by calling AcquireTokenSilent. #1966
• Fixed TDS RPC error on large queries in SqlCommand.ExecuteReaderAsync. #1965
• Fixed NullReferenceException in GetBytesAsync. #1964

For the detailed list of changes in Microsoft.Data.SqlClient 5.1.1, you can also see the Release Notes.

Microsoft.Data.SqlClient 5.0.2

Fixed

• Fixed memory leak regression from #1785 using a DisposableTemporaryOnStack struct. #1980
• Fixed TransactionScope connection issue when Enlist is enabled, Pooling is disabled, and Network Connection Type is set to Redirect. #1978
• Fixed an incorrect exception when a symmetric key fails to decrypt a column using Always Encrypted. #1977
• Fixed TDS RPC error on large queries in SqlCommand.ExecuteReaderAsync. #1976
• Fixed deadlock when using SinglePhaseCommit with distributed transactions. #1975

For the detailed list of changes in Microsoft.Data.SqlClient 5.0.2, you can also see the Release Notes.

Microsoft.Data.SqlClient 4.0.3

Fixed

• Fixed throttling of token requests by calling AcquireTokenSilent in AAD Integrated/Password flows when the account is already cached.#1995
• Fixed TDS RPC error on large queries in SqlCommand.ExecuteReaderAsync.#1987

For the detailed list of changes in Microsoft.Data.SqlClient 4.0.3, you can also see the Release Notes.

Microsoft.Data.SqlClient 2.1.6

Fixed

• Fixed TDS RPC error on large queries in SqlCommand.ExecuteReaderAsync. #1986
• Fixed Default UTF8 collation conflict. #1989
• Fixed async deadlock issue when sending attention fails due to network failure. #1767

For the detailed list of changes in Microsoft.Data.SqlClient 2.1.6, you can also see the Release Notes.

To get the new packages, 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