Stable Release v5.1.4

[Stable release 5.1.4] - 2024-01-09

Fixed

• Fixed a deadlock problem for distributed transactions when on .NET.

Changed

• Upgraded Azure.Identity dependency version to 1.10.3 to address CVE-2023-36414.

For summary of all changes over v5.1.3, refer to 5.1.4.md

Preview Release v5.2.0-preview4.23342.2

[Preview Release 5.2.0-preview4.23342.2] - 2023-12-08

Added

• Added SqlBatch support on .NET 6+ #1825, #2223
• Added Workload Identity authentication support #2159, #2264
• Added Localization support on .NET #2210
• Added support for Georgian collation #2194
• Added support for Big Endian systems #2170

Changed

• Updated Microsoft.Data.SqlClient.SNI (.NET Framework dependency) and Microsoft.Data.SqlClient.SNI.runtime (.NET/.NET Standard dependency) version to v5.2.0-preview1.23340.1. #2257, which includes removing dead code and addressing TSA warnings
• Improved CPU usage when AppContext switches are in use #2227
• Upgraded Azure.Identity dependency version to 1.10.3 to address CVE-2023-36414, #2188
• Improved error messages when validating server certificates in managed SNI (Linux/macOS) #2060

Fixed

• Fixed an issue when using the Authentication option, but not encrypting on .NET Framework where the server certificate was being incorrectly validated #2224
• Fixed a deadlock problem for distributed transactions when on .NET #2161
• Fixed an issue with connecting to named instances on named pipes in managed SNI (Linux/macOS)#2142
• Fixed an issue when connecting to an invalid LocalDB name using managed SNI #2129
• Fixed an AccessViolationException when using a SQL Express user instance #2101
• Fixed a metadata query issue when connecting to Azure SQL Edge #2099
• Fixed file version information for .NET and .NET Standard binaries#2093
• Fixed the SPN sent for a named instance when using Kerberos authentication on Linux/macOS #2240
• Various code improvements #2091, #2098, #2121, #2122, #2132, #2136, #2144, #2147, #2157, #2164, #2166, #2168, #2186

Stable Release v5.1.3

[Stable release 5.1.3] - 2024-01-09

Fixed

• Fixed encryption downgrade issue. CVE-2024-0056
• Fixed certificate chain validation logic flow.

For summary of all changes over v5.1.2, refer to 5.1.3.md

Stable Release v4.0.5

[Stable release 4.0.5] - 2024-01-09

Fixed

• Fixed encryption downgrade issue. CVE-2024-0056
• Fixed certificate chain validation logic flow.

For summary of all changes over v4.0.4, refer to 4.0.5.md

Stable Release 3.1.5

[Stable release 3.1.5] - 2024-01-09

Fixed

• Fixed encryption downgrade issue. CVE-2024-0056
• Fixed certificate chain validation logic flow.

For summary of all changes over v3.1.4, refer to 3.1.5.md

Stable Release v2.1.7

[Stable release 2.1.7] - 2024-01-09

Fixed

• Fixed encryption downgrade issue. CVE-2024-0056
• Fixed certificate chain validation logic flow.

For summary of all changes over v2.1.6, refer to 2.1.7.md

Stable Release v5.1.2

[Stable release 5.1.2] - 2023-10-26

Fixed

• Fixed access violation when using SQL Express user instance. #2101
• Fixed Always Encrypted secure enclave retry logic for async queries. #1988
• Fixed LocalDb and managed SNI by improving the error messages and avoid falling back to the local service. #2129
• Fixed .NET and .NET Standard file version. 2093
• Fixed non-string values and SqlConnectionStringBuilder property indexer issue. #2018
• Fixed SqlConnectionEncryptOption type conversion by introducing the SqlConnectionEncryptOptionConverter attribute when using appsettings.json files. #2057
• Fixed Transient fault handling issue with OpenAsync. #1983
• Fixed activity correlator to continue use of same GUID for connection activity. #1997

Changed

• Updated Microsoft.Data.SqlClient.SNI (.NET Framework dependency) and Microsoft.Data.SqlClient.SNI.runtime (.NET Core/Standard dependency) version to 5.1.1. #2123

For summary of all changes over v5.1.1, refer to 5.1.2.md

Stable Release v4.0.4

[Stable release 4.0.4] - 2023-10-30

Fixed

• Fixed Always Encrypted secure enclave retry logic for async queries. #1988
• Fixed LocalDb and managed SNI by improving the error messages and avoid falling back to the local service. #2129
• Fixed .NET and .NET Standard file version. 2093
• Fixed activity correlator to continue use of same GUID for connection activity. #1997

For summary of all changes over v4.0.3, refer to 4.0.4.md

Stable Release 3.1.4

[Stable release 3.1.4] - 2023-10-31

Fixed

• Fixed Always Encrypted secure enclave retry logic for async queries. #1988
• Fixed LocalDb and managed SNI by improving the error messages and avoid falling back to the local service. #2129
• Fixed .NET and .NET Standard file version. 2093
• Fixed activity correlator to continue use of same GUID for connection activity. #1997
• Fixed FormatException when event source tracing is enabled. #1291

For summary of all changes over v3.1.3, refer to 3.1.4.md

Preview Release v5.2.0-preview3.23201.1

[Preview Release 5.2.0-preview3.23201.1] - 2023-07-20

This update brings the below changes over the previous release:

Added

• Added a new AccessTokenCallBack API to SqlConnection. #1260
• Added support for the SuperSocketNetLib registry option for Encrypt on .NET on Windows. #2047

Fixed

• Fixed SqlDataAdapter.Fill and configurable retry logic issue on .NET Framework. #2084
• Fixed SqlConnectionEncryptOption type conversion by introducing the SqlConnectionEncryptOptionConverter attribute when using appsettings.json files. #2057
• Fixed th-TH culture info issue on Managed SNI. #2066

Changed

• Switched to the new .NET NegotiateAuthentication API on .NET 7.0 and above for SSPI token negotiation using Managed SNI. #2063
• Removed ignoreSniOpenTimeout in open connection process on Windows. #2067
• Enforce explicit ordinal for internal StringComparison operations. #2068
• Code health improvements: #1959, #2071, #2073, #2088

For detailed release notes, refer to 5.2.0-preview3.md