Bump Microsoft.Data.SqlClient from 5.0.1 to 5.1.3

[dependabot[bot]]

Updated Microsoft.Data.SqlClient from 5.0.1 to 5.1.3.

Release notes

Sourced from Microsoft.Data.SqlClient's releases.

5.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

5.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

5.1.1

[Stable release 5.1.1] - 2023-03-28

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 summary of all changes over v5.1.0, refer to 5.1.1.md

5.1.0

Breaking changes

• Dropped support for .NET Core 3.1. #​1704 #​1823

Added

• Added support for .NET 6.0. #​1704
• Added support for DateOnly and TimeOnly for SqlParameter value and GetFieldValue. #​1813
• Added support for TLS 1.3 on .NET Core and native SNI. #​1821
• Added ServerCertificate setting for Encrypt=Mandatory or Encrypt=Strict. #​1822
• Added Windows ARM64 support when targeting .NET Framework. #​1828

Fixed

• Fixed thread safety of transient error list in configurable retry logic. #​1882
• Fixed deadlock when using SinglePhaseCommit with distributed transactions. #​1801
• Fixed Dedicated Admin Connections (DAC) to localhost in managed SNI #​1865
• Fixed memory leak regression from #​1781 using a DisposableTemporaryOnStack struct. #​1818
• Fixed ReadAsync() behavior to register Cancellation token action before streaming results. #​1781
• Fixed NullReferenceException when assigning null to SqlConnectionStringBuilder.Encrypt. #​1778
• Fixed missing HostNameInCertificate property in .NET Framework Reference Project. #​1776
• Fixed async deadlock issue when sending attention fails due to network failure. #​1766
• Fixed failed connection requests in ConnectionPool in case of PoolBlock. #​1768
• Fixed hang on infinite timeout and managed SNI. #​1742
• Fixed Default UTF8 collation conflict. #​1739

Changed

• Updated Microsoft.Data.SqlClient.SNI (.NET Framework dependency) and Microsoft.Data.SqlClient.SNI.runtime (.NET Core/Standard dependency) version to 5.1.0. #​1889 which includes fix for AppDomain crash in issue #​1418, TLS 1.3 Support, removal of ARM32 binaries, and support for the ServerCertificate option. #​1822 Read more
• Reverted "Excluding unsupported TLS protocols" for issue #​1151 (i.e. removed Switch.Microsoft.Data.SqlClient.EnableSecureProtocolsByOS) by adding support for TLS 1.3. #​1824
• Changed the SqlConnectionEncryptOption string parser to public. #​1771
• Converted ExecuteNonQueryAsync to use async context object. #​1692
• Code health improvements #​1867 #​1849 #​1812 #​1520 #​1604 #​1598 #​1595 #​1443

For summary of all changes over v5.0, refer to 5.1.0.md

5.1.0-preview2.22314.2

[Preview Release 5.1.0-preview2.22314.2] - 2022-11-10

This update brings the below changes over the previous release:

Breaking changes over preview release v5.1.0-preview1

• Add support for .NET 6.0 and Dropped support for .NET Core 3.1. #​1704 #​1823

Added

• Added support for DateOnly and TimeOnly for SqlParameter value and GetFieldValue. #​1813
• Added support for TLS 1.3 for .NET Core and SNI Native. #​1821
• Added ServerCertificate support for Encrypt=Mandatory or Encrypt=Strict. #​1822
• Added Windows ARM64 support when targeting .NET Framework. #​1828

Fixed

• Fixed memory leak regression from #​1781 using a DisposableTemporaryOnStack struct. #​1818

Changed

• Updated Microsoft.Data.SqlClient.SNI (.NET Framework dependency) and Microsoft.Data.SqlClient.SNI.runtime (.NET Core/Standard dependency) version to 5.1.0-preview2.22311.2. #​1831 which includes the fix for the TLS 1.3 timeout and double handshake issue, removal of ARM32 binaries, and support for the ServerCertificate option. #​1822
• Reverted "Excluding unsupported TLS protocols" for issue #​1151 (i.e. removed Switch.Microsoft.Data.SqlClient.EnableSecureProtocolsByOS) by adding support for TLS 1.3. #​1824
• Code health improvements #​1812 #​1520

For detailed release notes, refer to 5.1.0-preview2.md

5.1.0-preview1.22279.3

[Preview Release 5.1.0-preview1.22279.3] - 2022-10-19

This update brings the below changes over the stable release v5.0.0:

Fixed

• Fixed ReadAsync() behavior to register Cancellation token action before streaming results. #​1781
• Fixed NullReferenceException when assigning null to SqlConnectionStringBuilder.Encrypt. #​1778
• Fixed missing HostNameInCertificate property in .NET Framework Reference Project. #​1776
• Fixed async deadlock issue when sending attention fails due to network failure. #​1766
• Fixed failed connection requests in ConnectionPool in case of PoolBlock. #​1768
• Fixed hang on infinite timeout and managed SNI. #​1742
• Fixed Default UTF8 collation conflict. #​1739

Changed

• Updated Microsoft.Data.SqlClient.SNI (.NET Framework dependency) and Microsoft.Data.SqlClient.SNI.runtime (.NET Core/Standard dependency) version to 5.1.0-preview1.22278.1. #​1787 which includes TLS 1.3 Support and fix for AppDomain crash in issue #​1418
• Changed the SqlConnectionEncryptOption string parser to public. #​1771
• Converted ExecuteNonQueryAsync to use async context object. #​1692
• Code health improvements #​1604 #​1598 #​1595 #​1443

Known issues

• When using Encrypt=Strict with TLS v1.3, the TLS handshake occurs twice on initial connection on .NET Framework due to a timeout during the TLS handshake and a retry helper re-establishes the connection; however, on .NET Core, it will throw a System.ComponentModel.Win32Exception (258): The wait operation timed out. and is being investigated. If you're using Microsoft.Data.SqlClient with .NET Core on Windows 11, you will need to enable the managed SNI on Windows context switch using following statement AppContext.SetSwitch("Switch.Microsoft.Data.SqlClient.UseManagedNetworkingOnWindows", true); to use TLS v1.3 or disabling TLS 1.3 from the registry by assigning 0 to the following HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.3\Client\Enabled registry key and it'll use TLS v1.2 for the connection. This will be fixed in a future release.

For detailed release notes, refer to 5.1.0-preview1.md

5.0.2

[Stable release 5.0.2] - 2023-03-31

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 summary of all changes over v5.0.1, refer to 5.0.2.md

Commits viewable in compare view.

You can trigger a rebase of this PR by commenting @dependabot rebase.

---

Dependabot commands and options

You can trigger Dependabot actions by commenting on this PR:

• @dependabot rebase will rebase this PR
• @dependabot recreate will recreate this PR, overwriting any edits that have been made to it
• @dependabot merge will merge this PR after your CI passes on it
• @dependabot squash and merge will squash and merge this PR after your CI passes on it
• @dependabot cancel merge will cancel a previously requested merge and block automerging
• @dependabot reopen will reopen this PR if it is closed
• @dependabot close will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually
• @dependabot show <dependency name> ignore conditions will show all of the ignore conditions of the specified dependency
• @dependabot ignore this major version will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself)
• @dependabot ignore this minor version will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself)
• @dependabot ignore this dependency will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself) You can disable automated security fix PRs for this repo from the Security Alerts page.

Note Automatic rebases have been disabled on this pull request as it has been open for over 30 days.

[netlify[bot]]

✅ Deploy Preview for arcus-webapi canceled.

Name	Link
🔨 Latest commit	05bcde906bb08aa2a9923921a0579f04c69eeddd
🔍 Latest deploy log	https://app.netlify.com/projects/arcus-webapi/deploys/68dc258cb76d2b00089476e0