Skip to content

5.1.0-preview2.md

Latest commit

 

History

History
104 lines (81 loc) · 4.9 KB

5.1.0-preview2.md

File metadata and controls

104 lines (81 loc) · 4.9 KB

Release Notes

Microsoft.Data.SqlClient 5.1.0-preview2.22314.2 released 10 November 2022

This update brings the below changes over the previous release:

Contributors

Thanks to the following public contributors. Their efforts toward this project are very much appreciated.

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 Read more
  • 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 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
  • Code health improvements #1812 #1520

New features

Server Certificate Support

The default value of the ServerCertificate connection setting is an empty string. When Encrypt is set to Mandatory or Strict, ServerCertificate can be used to specify a path on the file system to a certificate file to match against the SQL Server's TLS/SSL certificate. For this to be valid, the certificate specified must be an exact match. The accepted certificate formats are PEM, DER, and CER. Here is an usage example:

"Data Source=...;Encrypt=Strict;ServerCertificate=C:\\certificates\\server.cer"

Target Platform Support

  • .NET Framework 4.6.2+ (Windows ARM64, Windows x86, Windows x64)
  • .NET 6.0+ (Windows x86, Windows x64, Windows ARM64, Windows ARM, Linux, macOS)
  • .NET Standard 2.0+ (Windows x86, Windows x64, Windows ARM64, Windows ARM, Linux, macOS)

Dependencies

.NET Framework

  • Microsoft.Data.SqlClient.SNI 5.1.0.preview2.22311.2
  • Azure.Identity 1.7.0
  • Microsoft.Identity.Client 4.47.2
  • Microsoft.IdentityModel.JsonWebTokens 6.24.0
  • Microsoft.IdentityModel.Protocols.OpenIdConnect 6.24.0
  • System.Buffers 4.5.1
  • System.Configuration.ConfigurationManager 6.0.1
  • System.IO 4.3.0
  • System.Runtime.InteropServices.RuntimeInformation 4.3.0
  • System.Security.Cryptography.Algorithms 4.3.1
  • System.Security.Cryptography.Primitives 4.3.0
  • System.Text.Encoding.Web 6.0.0

.NET

  • Microsoft.Data.SqlClient.SNI 5.1.0.preview2.22311.2
  • Azure.Identity 1.7.0
  • Microsoft.Identity.Client 4.47.2
  • Microsoft.IdentityModel.JsonWebTokens 6.24.0
  • Microsoft.IdentityModel.Protocols.OpenIdConnect 6.24.0
  • Microsoft.SqlServer.Server 1.0.0
  • Microsoft.Win32.Registry 5.0.0
  • System.Buffers 4.5.1
  • System.Configuration.ConfigurationManager 6.0.1
  • System.Diagnostics.DiagnosticSource 6.0.0
  • System.IO 4.3.0
  • System.Runtime.Caching 6.0.0
  • System.Text.Encoding.CodePages 6.0.0
  • System.Text.Encodings.Web 6.0.0
  • System.Resources.ResourceManager 4.3.0
  • System.Security.Cryptography.Cng 5.0.0
  • System.Security.Principal.Windows 5.0.0

.NET Standard

  • Microsoft.Data.SqlClient.SNI 5.1.0.preview2.22311.2
  • Azure.Identity 1.7.0
  • Microsoft.Identity.Client 4.47.2
  • Microsoft.IdentityModel.Protocols.OpenIdConnect 6.24.0
  • Microsoft.IdentityModel.JsonWebTokens 6.24.0
  • Microsoft.SqlServer.Server 1.0.0
  • Microsoft.Win32.Registry 5.0.0
  • System.Buffers 4.5.1
  • System.Configuration.ConfigurationManager 6.0.1
  • System.IO 4.3.0
  • System.Runtime.Caching 6.0.0
  • System.Text.Encoding.CodePages 6.0.0
  • System.Text.Encodings.Web 6.0.0
  • System.Runtime.Loader 4.3.0
  • System.Resources.ResourceManager 4.3.0
  • System.Security.Cryptography.Cng 5.0.0
  • System.Security.Principal.Windows 5.0.0