GeezerVison

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)

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)

• 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

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)