Bump Microsoft.Data.SqlClient from 4.1.1 to 5.1.0 in /src/PsSqlClient

[dependabot[bot]]

Bumps Microsoft.Data.SqlClient from 4.1.1 to 5.1.0.

Release notes

Sourced from Microsoft.Data.SqlClient's releases.

Stable Release v5.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

Preview Release 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

... (truncated)

Changelog

Sourced from Microsoft.Data.SqlClient's changelog.

[Stable release 5.1.0] - 2023-01-19

This update brings the below changes over the previous release:

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

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.
• Code health improvements #1867 #1849

[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

• 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 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

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

This update brings the below changes over the previous release:

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

... (truncated)

Commits

• 0156df2 Release notes v5.1.0 (#1893)
• 8156ff9 Update docs for RowsCopied property (#1872)
• 8cb5913 Tests | Skip unsupported platform x86 test and bump up Microsoft.NET.Test.Sdk...
• 080e9e6 docs | Update description for SqlBulkCopy.EnableStreaming (#1886)
• 8e9f3c0 Test | Fix managed instance TVP test source file (#1878)
• 35a029f Update SNI Version to 5.1.0 (#1889)
• 070ec72 Remove redundant NuGet package references. (#1849)
• af0a376 Test | Skip unsupported tests on Synapse (#1884)
• c585669 Fix | Add thread safety with transient error list on configurable retry logic...
• f046489 adding Azure pipeline status badge.
• Additional commits viewable in compare view

Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually 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 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)

[abbgrade]

@dependabot rebase

[dependabot[bot]]

Looks like this PR has been edited by someone other than Dependabot. That means Dependabot can't rebase it - sorry!

If you're happy for Dependabot to recreate it from scratch, overwriting any edits, you can request @dependabot recreate.