Skip to content

Latest commit

 

History

History
1363 lines (925 loc) · 110 KB

CHANGELOG.md

File metadata and controls

1363 lines (925 loc) · 110 KB
Raw

Changelog

All notable changes to this project will be documented in this file.

The format is based on Keep a Changelog

[Preview Release 6.0.0-preview2.24304.8] - 2024-10-30

This update brings the below changes over the previous release:

Added

Fixed

  • Fixed scale serialization when explicitly set to 0 #2411
  • Fixed issue blocking GetSchema commands from being enrolled into the current transaction #2876
  • Adjusted retry logic to allow errors with negative numbers to be considered transient #2896
  • Fixed string formatting in OutOfMemory exceptions #2797
  • Increased routing attempts to 10 in netcore for LoginNoFailover and added routing support to LoginWithFailover to standardize routing behavior between netcore and netfx #2873
  • Restructured documentation into XML format so that it displays correctly in visual studio #2836, #2822, #2834, #2851, #2863, #2864, #2865, #2869, #2871, #2837, #2821
  • Fixed cleanup behavior when column decryption fails. Prevents leaving stale data on the wire for pooled connections #2843, #2825

Changed

[Preview Release 6.0.0-preview1.24240.8] - 2024-08-27

This update brings the below changes over the previous release:

Breaking Changes

  • Removed support for .NET Standard. #2386
  • Removed UWP (uap) references. #2483

Added

  • Added TokenCredential object to take advantage of token caching in ActiveDirectoryAuthenticationProvider. #2380
  • Added DateOnly and TimeOnly support to DataTable as a structured parameter. #2258
  • Added Microsoft.Data.SqlClient.Diagnostics.SqlClientDiagnostic type in .NET. #2226
  • Added scope trace for GenerateSspiClientContext. #2497, #2725

Fixed

  • Fixed Socket.Connect timeout issue caused by thread starvation. #2777
  • Fixed pending data with SqlDataReader against an encrypted column. #2618
  • Fixed Entra authentication when using infinite connection timeout in ActiveDirectoryAuthenticationProvider. #2651
  • Fixed GetSchema by excluding unsupported engines due to lack of support for ASSEMBLYPROPERTY function. #2593
  • Fixed SSPI retry negotiation with default port in .NET. #2559
  • Fixed assembly path in .NET 8.0 and .AssemblyAttributes. #2550
  • Fixed certificate chain validation. #2487
  • Fixed clone of SqlConnection to include AccessTokenCallback. #2525
  • Fixed issue with DateTimeOffset in table-valued parameters, which was introduced in 5.2. #2453
  • Fixed ArgumentNullException on SqlDataRecord.GetValue when using user-defined data type on .NET. #2448
  • Fixed SqlBuffer and SqlGuild when it's null. #2310
  • Fixed SqlBulkCopy.WriteToServer state in a consecutive calls. #2375
  • Fixed null reference exception with SqlConnection.FireInfoMessageEventOnUserErrors after introducing the batch command. #2399

Changed

  • Updated Microsoft.Data.SqlClient.SNI version to 6.0.0-preview1.24226.4. #2772
  • Improved access to SqlAuthenticationProviderManager.Instance and avoid early object initiation. #2636
  • Removed undocumented properties of Azure.Identity in ActiveDirectoryAuthenticationProvider. #2562
  • Replaced System.Runtime.Caching with Microsoft.Extensions.Caching.Memory. #2493
  • Updated EnableOptimizedParameterBinding to only accept text mode commands. #2417
  • Updated Azure.Identity version from 1.10.3 to 1.11.4. #2577
  • Updated Azure.Core version from 1.35.0 to 1.38.0. #2462
  • Updated Azure.Security.KeyVault.Keys version from 4.4.0 to 4.5.0. #2462
  • Updated Microsoft.IdentityModel.JsonWebTokens and Microsoft.IdentityModel.Protocols.OpenIdConnect from 6.35.0 to 7.5.0. #2429
  • Removed direct dependency to Microsoft.Identity.Client to take the transient dependecy through Azure.Identity. #2577
  • Removed unnecessary references Microsoft.Extensions.Caching.Memory and System.Security.Cryptography.Cng after removing .NET Standard. #2577
  • Improved memory allocation when reader opened by CommandBehavior.SequentialAccess over the big string columns. #2356
  • Improved SSPI by consolidating the context generation to single abstraction and using memory/span for SSPI generation. #2255, #2447
  • Reverted the #2281 code changes on ManagedSNI. #2395
  • Updated assembly version to 6.0.0.0. #2382
  • Code health improvements: #2366, #2369, #2381, #2390, #2392, #2403, #2410, #2413, #2425, #2428, #2440, #2443, #2450, #2466, #2486, #2521, #2522, #2533, #2552, #2560, #2726, #2751, #2811

[Stable release 5.2.2] - 2024-08-27

Fixed

  • Fixed AcquireTokenAsync timeout handling for edge cases in ActiveDirectoryAuthenticationProvider. #2650
  • Fixed issue with Socket.Connect in managed SNI. #2779
  • Fixed path for AssemblyAttributes in obj folder causing NET 8.0 assembly to appear in NET 6.0 dll. #2789
  • Fixed SSPI retry negotiation with default port in .NET. #2815
  • Fixed ArgumentNullException on SqlDataRecord.GetValue when using user-defined data type on .NET. #2816
  • Fixed pending data with SqlDataReader against an encrypted column. #2817

Changed

  • Upgraded Azure.Identity version from 1.11.3 to 1.11.4 #2648 to address CVE-2024-35255.
  • Upgraded Microsoft.Identity.Client version from 4.60.0 to 4.61.3 #2648 to address CVE-2024-35255.
  • Added caching to TokenCredential objects to take advantage of token caching. #2775

[Stable release 5.2.1] - 2024-05-31

This update brings the below changes over the previous release:

Fixed

  • Fixed connection errors on Linux when Data Source property contains both named instance and port #2436
  • Fixed SqlConnection.FireInfoMessageEventOnUserErrors when set to true throws an exception #2505
  • Fixed exception when using DATETIMEOFFSET(n) in a TVP if n is 1, 2, 3, or 4 #2506
  • Reverted PR #1983 which caused connection failure delays when using OpenAsync #2507
  • Fixed SqlConnection.Clone() to include AccessTokenCallback #2527

Changed

  • Upgraded Azure.Identity version from 1.10.3 to 1.11.3 #2492, #2528
  • Upgraded Microsoft.Identity.Client version from 4.56.0 to 4.60.3 #2492
  • Code Health improvements: #2467

[Stable release 5.2.0] - 2024-02-28

Added

  • Added a new AccessTokenCallBack API to SqlConnection. #1260
  • Added SqlBatch support on .NET 6+ #1825, #2223,#2371, #2373
  • Added support of SqlDiagnosticListener on .NET Standard. #1931
  • Added new property RowsCopied64 to SqlBulkCopy. #2004
  • Added support for the SuperSocketNetLib registry option for Encrypt on .NET on Windows. #2047
  • Added the ability to generate debugging symbols in a separate package file #2137
  • Added Workload Identity authentication support #2159, #2264
  • Added support for Big Endian systems #2170
  • Added support for Georgian collation #2194
  • Added Localization support on .NET #2210
  • Added .NET 8 support #2230
  • Added explicit version for major .NET version dependencies on System.Runtime.Caching 8.0.0, System.Configuration.ConfigurationManager 8.0.0, and System.Diagnostics.
  • DiagnosticSource 8.0.0 #2303

Fixed

  • Fixed Always Encrypted secure enclave retry logic for async queries. #1988
  • Fixed activity correlator to continue use of same GUID for connection activity. #1997
  • Fixed behavior when error class is greater than 20 on connection retry. #1953
  • Fixed error message when symmetric key decryption failed using Always Encrypted. #1948
  • Fixed TransactionScope connection issue when Enlist is enable, Pooling is disabled and network connection type is Redirect. #1960
  • Fixed TDS RPC error on large queries in SqlCommand.ExecuteReaderAsync. #1936
  • Fixed throttling of token requests by calling AcquireTokenSilent. #1925
  • Fixed Linux code coverage result in Build proj. #1950
  • Fixed NullReferenceException in GetBytesAsync. #1906
  • Fixed Transient fault handling issue with OpenAsync. #1983
  • Fixed invariant mode checks. #1917
  • Fixed GC behavior in TdsParser by adding array rental capability in TryReadPlpUnicodeChars. #1866
  • Fixed socket synchronization issue during connect in managed SNI. #1029
  • Fixed issue with SqlConnectionStringBuilder property indexer not supporting non-string values. #2018
  • 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
  • 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 LocalDb connection issue with an invalid source when 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
  • Fixed connection to unsubscribe from transaction completion events before returning it to the connection pool #2301
  • Fixed InvalidCastException when reading an Always Encrypted date or time column #2275
  • Fixed token caching to prevent expired access tokens from being reused in a connection pool #2273

Changed

  • Improved parsing buffered characters in TdsParser. #1544
  • Added Microsoft.SqlServer.Types to verify support for SqlHierarchyId and Spatial for .NET Core. #1848
  • Moved to new System.Data.SqlTypes APIs on .NET 7 and up. #1934 and #1981
  • Removed reference to Microsoft.Win32.Registry since it's shipped starting with .NET 6.0. #1974
  • Changed UseOneSecFloorInTimeoutCalculationDuringLogin App Context switch default to true and extended its effect to .NET and .NET Standard. #2012
  • Updated Microsoft.Identity.Client version from 4.47.2 to 4.53.0. #2031, #2055
  • 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
  • Improved error messages when validating server certificates in managed SNI (Linux/macOS) #2060
  • Improved CPU usage when AppContext switches are in use #2227
  • Upgraded Azure.Identity dependency version to 1.10.3 to address CVE-2023-36414, #2189
  • Changed Microsoft.IdentityModel.JsonWebTokens and Microsoft.IdentityModel.Protocols.OpenIdConnect version 6.24.0 to 6.35.0 #2290 to address CVE-2024-21319
  • Updated Microsoft.Data.SqlClient.SNI (.NET Framework dependency) and Microsoft.Data.SqlClient.SNI.runtime (.NET/.NET Standard dependency) version to v5.2.0. #2363, which includes removing dead code and addressing static analysis warnings
  • Code health improvements: #1198, #1829, #1943, #1949, #1959, #1985, #2071, #2073, #2088, #2091, #2098, #2121, #2122, #2132, #2136, #2144, #2147, #2157, #2164, #2166, #2168, #2186, #2254, #2288, #2305, #2317

[Preview Release 5.2.0-preview5.24024.3] - 2024-01-24

This update brings the below changes over the previous release:

Added

  • Added .NET 8 support #2230
  • Added explicit version for major .NET version dependencies on System.Runtime.Caching 8.0.0, System.Configuration.ConfigurationManager 8.0.0, and System.Diagnostics.DiagnosticSource 8.0.0 #2303
  • Added the ability to generate debugging symbols in a separate package file #2137

Changed

  • Changed Microsoft.IdentityModel.JsonWebTokens and Microsoft.IdentityModel.Protocols.OpenIdConnect version 6.24.0 to 6.35.0 #2290 to address CVE-2024-21319

Fixed

  • Fixed connection to unsubscribe from transaction completion events before returning it to the connection pool #2301
  • Fixed InvalidCastException when reading an Always Encrypted date or time column #2275
  • Fixed token caching to prevent expired access tokens from being reused in a connection pool #2273
  • Code health improvements: #2288, #2305, #2254, #2317

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

This update brings the below changes over the previous release:

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 static analysis 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 LocalDb connection issue with an invalid source when 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

This update brings the below changes over the previous release:

[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

[Preview Release 5.2.0-preview2.23159.1] - 2023-06-08

This update brings the below changes over the previous release:

Added

  • Added new property RowsCopied64 to SqlBulkCopy. #2004

Fixed

  • Fixed socket synchronization issue during connect in managed SNI. #1029
  • Fixed issue with SqlConnectionStringBuilder property indexer not supporting non-string values. #2018

Changed

[Preview Release 5.2.0-preview1.23109.1] - 2023-04-20

This update brings the below changes over the previous release:

Added

  • Added support of SqlDiagnosticListener on .NET Standard. #1931

Fixed

  • Fixed AE enclave retry logic for async queries. #1988
  • Fixed activity correlator to continue use of same GUID for connection activity. #1997
  • Fixed behavior when error class is greater than 20 on connection retry. #1953
  • Fixed error message when symmetric key decryption failed using Always Encrypted. #1948
  • Fixed TransactionScope connection issue when Enlist is enable, Pooling is disabled and network connection type is Redirect. #1960
  • Fixed TDS RPC error on large queries in SqlCommand.ExecuteReaderAsync. #1936
  • Fixed throttling of token requests by calling AcquireTokenSilent. #1925
  • Fixed Linux code coverage result in Build proj. #1950
  • Fixed NullReferenceException in GetBytesAsync. #1906
  • Fixed Transient fault handling issue with OpenAsync. #1983
  • Fixed invariant mode checks. #1917
  • Fixed GC behavior in TdsParser by adding array rental capability in TryReadPlpUnicodeChars. #1866

Changed

  • Updated Azure Identity version from 1.7.0 to 1.8.0. #1921
  • Improved parsing buffered characters in TdsParser. #1544
  • Removed reference to Microsoft.Win32.Registry since it's shipped starting with .NET 6.0. #1974
  • Added Microsoft.SqlServer.Types to verify support for SqlHierarchyId and Spatial for .NET Core. #1848
  • Code health improvements:#1943#1949#1198#1829

[Stable release 5.1.6] - 2024-08-27

Fixed

  • Fixed Transient fault handling issue with OpenAsync. #1983 #2508
  • Fixed AcquireTokenAsync timeout handling for edge cases in ActiveDirectoryAuthenticationProvider. #2706
  • Fixed pending data with SqlDataReader against an encrypted column. #2618 #2818

Changed

  • Upgraded Azure.Identity version from 1.11.3 to 1.11.4 [#2649] (#2649) [#2529] (#2529) to address CVE-2024-35255.
  • Upgraded Microsoft.Identity.Client version from 4.60.0 to 4.61.3 [#2649] (#2649) [#2529] (#2529) to address CVE-2024-35255.
  • Added caching to TokenCredential objects to take advantage of token caching. #2776
  • Code health improvements: [#2490] (#2490)

[Stable release 5.1.5] - 2024-01-29

This update brings the below changes over the previous release:

Fixed

  • Fixed connection to unsubscribe from transaction completion events before returning it to the connection pool #2321
  • Fixed InvalidCastException when reading an Always Encrypted date or time column #2324

Changed

  • Changed Microsoft.IdentityModel.JsonWebTokens and Microsoft.IdentityModel.Protocols.OpenIdConnect version 6.24.0 to 6.35.0 #2320 to address CVE-2024-21319

[Stable release 5.1.4] - 2024-01-09

This update brings the below changes over the previous release:

Fixed

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

Changed

[Stable release 5.1.3] - 2024-01-09

This update brings the below changes over the previous release:

Fixed

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

[Stable release 5.1.2] - 2023-10-26

This update brings the below changes over the previous release:

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

[Stable release 5.1.1] - 2023-03-28

This update brings the below changes over the previous release:

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

[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

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

[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

[Stable release 5.0.1] - 2022-10-07

Fixed

  • Fixed missing HostNameInCertificate connection string property in .NET Framework. #1782
  • Fixed async deadlock issue when sending attention fails due to network failure. #1783
  • Fixed Null Reference Exception on assigning null to SqlConnectionStringBuilder.Encrypt. #1784
  • Fixed ReadAsync() behavior to register Cancellation token action before streaming results. #1785
  • Fixed hang on infinite timeout and managed SNI. #1798
  • Fixed Default UTF8 collation conflict. #1799

Changed

  • Updated Microsoft.Data.SqlClient.SNI (.NET Framework dependency) and Microsoft.Data.SqlClient.SNI.runtime (.NET Core/Standard dependency) version to 5.0.1 #1795, which includes the fix for AppDomain crash introducing in issue #1418.

[Stable release 5.0.0] - 2022-08-05

This update brings the below changes over the previous release:

Added

  • Added support for TDS 8. To use TDS 8, users should specify Encrypt=Strict in the connection string. #1608
  • Added TDS 8 version for TDSLogin. #1657

Fixed

  • Fixed null SqlBinary as rowversion. #1688
  • Fixed KeyNotFoundException for the FailoverPartner key on SQL servers with availability group configured. #1614
  • Fixed small inconsistency between netcore and netfx for EncryptionOptions. #1672
  • Fixed Microsoft.SqlServer.Server netcore project package reference. #1654

Changed

  • Updated AuthProviderInfo struct to be matched the changes in native SNI for TDS 8 server certificate validation. #1680
  • Updated default system protocol for TDS 8 on managed code. #1678
  • Updated Microsoft.Data.SqlClient.SNI (.NET Framework dependency) and Microsoft.Data.SqlClient.SNI.runtime (.NET Core/Standard dependency) version to 5.0.0. #1680
  • Updated IdentityModel dependency from 6.8.0 to 6.21.0 and IdentityClient from 4.32.2 to 4.45.0. #1646
  • Changed from union overlay design to reflected interfaces for SqlTypes. 1647

[Preview Release 5.0.0-preview3.22168.1] - 2022-06-16

This update brings the below changes over the previous release:

Breaking changes over preview release v5.0.0-preview2

  • Dropped classes from the Microsoft.Data.SqlClient.Server namespace and replaced them with supported types from the Microsoft.SqlServer.Server package.#1585 The affected classes and enums are:
    • Microsoft.Data.SqlClient.Server.IBinarySerialize -> Microsoft.SqlServer.Server.IBinarySerialize
    • Microsoft.Data.SqlClient.Server.InvalidUdtException -> Microsoft.SqlServer.Server.InvalidUdtException
    • Microsoft.Data.SqlClient.Server.SqlFacetAttribute -> Microsoft.SqlServer.Server.SqlFacetAttribute
    • Microsoft.Data.SqlClient.Server.SqlFunctionAttribute -> Microsoft.SqlServer.Server.SqlFunctionAttribute
    • Microsoft.Data.SqlClient.Server.SqlMethodAttribute -> Microsoft.SqlServer.Server.SqlMethodAttribute
    • Microsoft.Data.SqlClient.Server.SqlUserDefinedAggregateAttribute -> Microsoft.SqlServer.Server.SqlUserDefinedAggregateAttribute
    • Microsoft.Data.SqlClient.Server.SqlUserDefinedTypeAttribute -> Microsoft.SqlServer.Server.SqlUserDefinedTypeAttribute
    • (enum) Microsoft.Data.SqlClient.Server.DataAccessKind -> Microsoft.SqlServer.Server.DataAccessKind
    • (enum) Microsoft.Data.SqlClient.Server.Format -> Microsoft.SqlServer.Server.Format
    • (enum) Microsoft.Data.SqlClient.Server.SystemDataAccessKind -> Microsoft.SqlServer.Server.SystemDataAccessKind

Added

  • Added support for TDS 8. To use TDS 8, users should specify Encrypt=Strict in the connection string. Strict mode disables TrustServerCertificate (always treated as False in Strict mode). HostNameInCertificate has been added to help some Strict mode scenarios. #1608
  • Added support for specifying Server SPN and Failover Server SPN on the connection. #1607
  • Added support for aliases when targeting .NET Core on Windows. #1588

Fixed

  • Fixed naming, order, and formatting for SqlDiagnosticsListener on .NET Core and .NET. #1637
  • Fixed NullReferenceException during Azure Active Directory authentication. #1625
  • Added CommandText length validation when using stored procedure command types. #1484
  • Fixed GetSchema("StructuredTypeMembers") to return correct schema information. #1500, #1639
  • Fixed NullReferenceException when using SqlDependency.Start against an Azure SQL Database.#1294
  • Send the correct retained transaction descriptor in the MARS TDS Header when there is no current transaction on .NET 5+ and .NET Core. #1624
  • Parallelize SSRP requests (instance name resolution) on Linux and macOS when MultiSubNetFailover is specified. #1578
  • Adjust the default ConnectRetryCount against Azure Synapse OnDemand endpoints #1626

Changed

  • Code health improvements #1353 #1354 #1525 #1186
  • Update Azure Identity dependency from 1.5.0 to 1.6.0.#1611
  • Improved Regex for SqlCommandSet #1548
  • Rework on TdsParserStateObjectManaged with nullable annotations. #1555

[Preview Release 5.0.0-preview2.22096.2] - 2022-04-06

This update brings the below changes over the previous release:

Breaking changes over preview release v5.0.0-preview1

  • Dropped support for .NET Framework 4.6.1 #1574

Fixed

  • Fixed connection failure by skipping Certificate Revocation List (CRL) check during authentication #1559

Changed

  • Updated Microsoft.Data.SqlClient.SNI (.NET Framework dependency) and Microsoft.Data.SqlClient.SNI.runtime (.NET Core/Standard dependency) version to 5.0.0-preview2.22084.1. #1563
  • Updated Azure.Identity version to 1.5.0 and Microsoft.Identity.Client version to 4.30.1 #1462
  • Replaced AlwaysEncryptedAttestationException with SqlException #1515
  • Improved error message when adding wrong type to SqlParameterCollection #1547
  • Code health improvements #1343 #1370 #1371 #1438 #1483

[Preview Release 5.0.0-preview1.22069.1] - 2022-03-09

Added

  • Added SqlDataSourceEnumerator. #1430
  • Added new attestation protocol None option to forgo enclave attestation when using VBS enclaves. #1425 and #1419
  • Added a new AppContext switch to suppress insecure TLS warnings. #1457

Fixed

  • Fixed all documentation paths to Unix format path. #1442
  • Fixed thread safety issue for GetEnclaveProvider by converting dictionary to concurrent dictionary. #1451

Changed

  • Updated Microsoft.Data.SqlClient.SNI (.NET Framework dependency) and Microsoft.Data.SqlClient.SNI.runtime (.NET Core/Standard dependency) version to v5.0.0-preview1.22062.1. #1537
  • Modernized style in ValueUtilSmi. #1351
  • Changed SQL server codenames to version names. #1439
  • Prevented subtype generation in project files. #1452
  • Changed Array.Copy to Buffer.BlockCopy for byte arrays. #1366
  • Changed files in csproj to be alphabetically sorted in netfx and netcore. #1364
  • Sqlstream, SqlInternalTransaction and MetaDataUtilsSmi are moved to shared folder. #1337, #1346 and #1339
  • Various code improvements: #1197, #1313,#1330,#1366, #1435,#1478

[Stable release 4.1.1] - 2022-09-13

Fixed

  • Fixed connection failure by not requiring Certificate Revocation List (CRL) check during authentication. #1706
  • Parallelize SSRP requests on Linux and macOS when MultiSubNetFailover is specified. #1708, #1746
  • Added CommandText length validation when using stored procedure command types. #1709
  • Fixed NullReferenceException during Azure Active Directory authentication. #1710
  • Fixed null SqlBinary as rowversion. #1712
  • Fixed table's collation overriding with default UTF8 collation. #1749

Changed

  • Updated Microsoft.Data.SqlClient.SNI (.NET Framework dependency) and Microsoft.Data.SqlClient.SNI.runtime (.NET Core/Standard dependency) version to v4.0.1 #1755, which includes the fix for AppDomain crash introducing in issue #1418
  • Various code improvements: #1711

[Stable release 4.1.0] - 2022-01-31

Added

  • Added new Attestation Protocol None for VBS enclave types. This protocol will allow users to forgo enclave attestation for VBS enclaves. #1419 #1425

[Stable release 4.0.6] - 2024-08-21

Fixed

  • Fixed connection to unsubscribe from transaction completion events before returning it to the connection pool #2301 #2435
  • Fixed AcquireTokenAsync timeout handling for edge cases in ActiveDirectoryAuthenticationProvider #2707

Changed

[Stable release 4.0.5] - 2024-01-09

Fixed

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

[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

[Stable release 4.0.3] - 2023-04-20

Fixed

  • Fixed throttling of token requests by calling AcquireTokenSilent in AAD Integrated/Password flows when the account is already cached.#1995
  • Fixed TDS RPC error on large queries in SqlCommand.ExecuteReaderAsync.#1987

[Stable release 4.0.2] - 2022-09-13

Fixed

  • Fixed connection failure by not requiring Certificate Revocation List (CRL) check during authentication. #1718
  • Parallelize SSRP requests on Linux and macOS when MultiSubNetFailover is specified. #1720, #1747
  • Added CommandText length validation when using stored procedure command types. #1721
  • Fixed NullReferenceException during Azure Active Directory authentication. #1722
  • Fixed null SqlBinary as rowversion. #1724
  • Fixed table's collation overriding with default UTF8 collation. #1750

Changed

  • Updated Microsoft.Data.SqlClient.SNI (.NET Framework dependency) and Microsoft.Data.SqlClient.SNI.runtime (.NET Core/Standard dependency) version to v4.0.1 #1754, which includes the fix for AppDomain crash introducing in issue #1418
  • Various code improvements: #1723

[Stable release 4.0.1] - 2022-01-17

Added

Added AppContext switch SuppressInsecureTLSWarning to allow suppression of TLS security warning when using Encrypt=false in the connection string. #1457

Fixed

  • Fixed Kerberos authentication failure when using .NET 6. #1411
  • Fixed connection failure when using SqlLocalDB instance pipe name. #1433
  • Fixed a failure when executing concurrent queries requiring enclaves. #1451
  • Updated obsolete API calls targeting .NET 6. #1401

[Stable Release 4.0.0] - 2021-11-18

Added

  • Added missing SqlClientLogger class to .NET Core refs and missing SqlClientLogger.LogWarning method in .NET Framework refs #1392

Changed

  • Avoid throwing unnecessary exception when an invalid SqlNotificationInfo value is received from SQL Server #1378
  • Updated Microsoft.Data.SqlClient.SNI (.NET Framework dependency) and Microsoft.Data.SqlClient.SNI.runtime (.NET Core/Standard dependency) version to v4.0.0 #1391

[Preview Release 4.0.0-preview3.21293.2] - 2021-10-20

This update brings the below changes over the previous release:

Breaking changes over preview release v4.0.0-preview2

  • Dropped support for .NET Core 2.1 #1272
  • [.NET Framework] Exception will not be thrown if a User ID is provided in the connection string when using Active Directory Integrated authentication #1359

Added

  • Add GetFieldValueAsync<T> and GetFieldValue<T> support for XmlReader, TextReader, Stream #1019

Fixed

  • Fixed FormatException when opening a connection with event tracing enabled #1291
  • Fixed improper initialization of ActiveDirectoryAuthenticationProvider #1328
  • Fixed MissingMethodException when accessing SqlAuthenticationParameters.ConnectionTimeout #1336
  • Fixed data corruption issues by reverting changes to async cancellations #1352
  • Fixed performance degradation by reverting changes to MARS state machine #1357
  • Fixed bug where environment variables are ignored when using Active Directory Default authentication #1360

Changed

  • Removed attributes for classes used in Microsoft.VSDesigner due to lack of support for Microsoft.Data.SqlClient #1296
  • Disable encryption when connecting to SQL LocalDB #1312
  • Various code health and performance improvements. See milestone for more info.

[Preview Release 4.0.0-preview2.21264.2] - 2021-09-21

This update brings the below changes over the previous release:

Breaking changes over preview release v4.0.0-preview1

  • Removed Configurable Retry Logic safety switch. #1254

Added

  • Added support for SqlFileStream on Windows using .NET Standard 2.0 and above. #1240
  • Added support for localdb shared instance using managed SNI. #1237

Fixed

  • Fixed .NET decimal conversion from SqlDecimal. #1179
  • Fixed Event Source changes on TryBeginExecuteEvent and WriteEndExecuteEvent to address the failure on other MS products such as OpenTelemetry and Application Insight. #1258
  • Fixed command's async cancellation. #956
  • Fixed deadlock in transaction using .NET Framework. #1242
  • Fixed unknown transaction state issues when prompting delegated transaction. 1216

Changed

[Preview Release 4.0.0-preview1.21237.2] - 2021-08-25

Breaking changes over stable release 3.0.0

  • Changed Encrypt connection string property to be true by default. #1210
  • The driver now throws SqlException replacing AggregateException for active directory authentication modes. #1213
  • Dropped obsolete Asynchronous Processing connection property from .NET Framework. #1148

Added

  • Added SqlCommand.EnableOptimizedParameterBinding property that when enabled increases performance for commands with very large numbers of parameters. #1041
  • Included 42108 and 42109 error codes to retriable transient errors list. #1215
  • Added new App Context switch to use OS enabled client protocols only. #1168
  • Added PoolBlockingPeriod connection property support in .NET Standard. #1181
  • Added support for SqlDataReader.GetColumnSchema() in .NET Standard. #1181
  • Added PropertyGrid support with component model annotations to SqlConnectionStringBuilder properties for .NET Core. #1152

Fixed

  • Fixed issue with connectivity when TLS 1.3 is enabled on client and server. #1168
  • Fixed issue with connection encryption to ensure connections fail when encryption is required. #1210
  • Fixed issue where connection goes to unusable state. #1128
  • Fixed recursive calls to RetryLogicProvider when calling SqlCommand.ExecuteScalarAsync. #1220
  • Fixed async deadlock scenarios in web contexts with configurable retry logic provider. #1220
  • Fixed EntryPointNotFoundException in InOutOfProcHelper constructor. #1120
  • Fixed async thread blocking issues on SqlConnection.Open() for active directory authentication modes. #1213
  • Fixed driver behavior for Always Encrypted with secure enclaves to not fail when no user parameters have been provided. #1115
  • Fixed bug with LegacyRowVersionNullBehavior App Context switch. #1182
  • Fixed issues in Strings.resx file containing error messages. #1136 #1178

Changed

  • Updated error code to match with Windows when certificate validation fails in non-Windows client environments. #1130
  • Removed designer attributes from SqlCommand and SqlDataAdapter. #1132
  • Updated configurable retry logic default retriable error list. #1125
  • Improved performance by changing SqlParameter bool fields to flags. #1064
  • Improved performance by implementing static delegates. #1060
  • Optimized async method allocations in .NET Framework by porting changes from .NET Core. #1084
  • Various code improvements #902 #925 #933 #934 #1024 #1057 #1122 #1133 #1134 #1141 #1187 #1188 #1223 #1225 #1226

[Stable release 3.1.7] - 2024-08-20

Fixed

  • Fixed connection to unsubscribe from transaction completion events before returning it to the connection pool. #2301 #2434
  • Fixed AcquireTokenAsync timeout handling for edge cases in ActiveDirectoryAuthenticationProvider. #2709
  • Fixed the signing issue with Microsoft.Data.SqlClient assembly. #2789

Changed

  • Updated Microsoft.Data.SqlClient.SNI version 3.0.1 to 3.0.2 #2676 which includes the fix for AppDomain crashing in issue #1418 and various code refactors.
  • Code health improvements: #2147, #2515, #2517 addresses CVE-2019-0545, #2539

[Stable release 3.1.5] - 2024-01-09

Fixed

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

[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

[Stable release 3.1.3] - 2023-03-10

Fixed

  • Fixed throttling of token requests by calling AcquireTokenSilent in AAD Integrated/Password flows when the account is already cached.#1926
  • Fixed TDS RPC error on large queries in SqlCommand.ExecuteReaderAsync.#1939

[Stable release 3.1.2] - 2023-02-03

Added

  • Added Windows ARM64 support when targeting .NET Framework. #1908

Fixed

  • Fixed thread safety of transient error list in configurable retry logic. #1911
  • Fixed deadlock when using SinglePhaseCommit with distributed transactions. #1912
  • Fixed Default UTF8 collation conflict. #1910
  • Added CommandText length validation when using stored procedure command types. #1909

[Stable release 3.1.1] - 2022-08-12

Fixed

  • Fixed null SqlBinary as rowversion. #1700
  • Fixed Kerberos authentication failure when using .NET 6. #1696
  • Fixed NullReferenceException during Azure Active Directory authentication. #1695
  • Removed union overlay design and use reflection in SqlTypeWorkarounds. #1699

[Stable release 3.1.0] - 2022-03-30

Added

  • Added new Attestation Protocol None for VBS enclave types. This protocol will allow users to forgo enclave attestation for VBS enclaves. #1539
  • Included 42108 and 42109 error codes to retriable transient errors list. #1560

Fixed

  • Changed EnclaveDelegate.Crypto GetEnclaveProvider to use a thread safe concurrent dictionary. [#1564](#1564

[Stable Release 3.0.1] - 2021-09-24

Fixed

  • Fixed async thread blocking issues on SqlConnection.Open() for active directory authentication modes. #1270
  • Fixed unknown transaction state issues when prompting delegated transaction. 1247
  • Fixed issue with connection encryption to ensure connections fail when encryption is required. #1233
  • Fixed bug with LegacyRowVersionNullBehavior App Context switch. #1246
  • Fixed recursive calls to RetryLogicProvider when calling SqlCommand.ExecuteScalarAsync. #1245
  • Fixed async deadlock scenarios in web contexts with configurable retry logic provider. #1245
  • Fixed deadlock in transaction using .NET Framework. #1243
  • Fixed issue where connection goes to unusable state. #1238

[Stable Release 3.0.0] - 2021-06-09

Added

  • Added support for column encryption key caching when the server supports retrying queries that require enclave computations #1062
  • Added support for configurable retry logic configuration file in .NET Standard #1090

Changed

  • Updated Microsoft.Data.SqlClient.SNI (.NET Framework dependency) and Microsoft.Data.SqlClient.SNI.runtime (.NET Core/Standard dependency) version to v3.0.0 #1102
  • Improved event counter display information #1091

Breaking Changes

  • Modified column encryption key store provider registrations to give built-in system providers precedence over providers registered on connection and command instances. #1101

[Stable Release 2.1.7] - 2024-01-09

Fixed

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

[Stable Release 2.1.6] - 2023-04-27

Fixed

  • Fixed TDS RPC error on large queries in SqlCommand.ExecuteReaderAsync.#1986
  • Fixed Default UTF8 collation conflict. #1989
  • Fixed async deadlock issue when sending attention fails due to network failure. #1767

[Stable Release 2.1.5] - 2022-08-30

Fixed

  • Added CommandText length validation when using stored procedure command types. #1726
  • Fixed Kerberos authentication failure when using .NET 6. #1727
  • Removed union overlay design and use reflection in SqlTypeWorkarounds. #1729

[Stable Release 2.1.4] - 2021-09-20

Fixed

  • Fixed issue with connection encryption to ensure connections fail when encryption is required. #1232
  • Fixed issue where connection goes to unusable state. #1239

[Stable Release 2.1.3] - 2021-05-21

Fixed

  • Fixed wrong data blended with transactions in .NET Core by marking a connection as doomed if the transaction completes or aborts while there is an open result set #1051
  • Fixed race condition issues between SinglePhaseCommit and TransactionEnded events #1049

[Preview Release 3.0.0-preview3.21140.5] - 2021-05-20

Added

  • Added support for "Active Directory Default" authentication mode #1043
  • Added support for connection-level and command-level registration of custom key store providers to enable multi-tenant applications to control key store access #1045 #1056 #1078
  • Added IP address preference support for TCP connections #1015

Fixed

  • Fixed corrupted connection issue when an exception occurs during RPC execution with TVP types #1068
  • Fixed race condition issues between SinglePhaseCommit and TransactionEnded events #1042

Changed

  • Updated error messages for enclave exceptions to include a link to a troubleshooting guide. #994
  • Changes to share common files between projects #1022 #1038 #1040 #1033 #1028 #1039

[Preview Release 3.0.0-preview2.21106.5] - 2021-04-16

Breaking Changes over preview release v3.0.0-preview1

  • User Id connection property now requires Client Id instead of Object Id for User-Assigned Managed Identity #1010
  • SqlDataReader now returns a DBNull value instead of an empty byte[]. Legacy behavior can be enabled by setting AppContext switch Switch.Microsoft.Data.SqlClient.LegacyRowVersionNullBehavior #998

Added

  • Microsoft.Data.SqlClient now depends on Azure.Identity library to acquire a token for "Active Directory Managed Identity/MSI" and "Active Directory Service Principal" authentication modes. #1010
  • Upgraded Native SNI dependency to v3.0.0-preview1 along with enhanced event tracing support #1006

Fixed

  • Fixed wrong data blended with transactions in .NET Core by marking a connection as doomed if the transaction completes or aborts while there is an open result set#1023
  • Fixed derived parameters containing incorrect TypeName #1020
  • Fixed server connection leak possibilities when an exception occurs in pooling layer #890
  • Fixed IP connection resolving logic in .NET Core #1016 #1031

Changed

  • Performance improvements in SqlDateTime to DateTime internal conversion method #912
  • Improved memory allocation by avoiding unnecessary context switching 1008
  • Updated Microsoft.Identity.Client version from 4.21.1 to 4.22.0 #1036
  • Various performance improvements #963 #996 #1004 #1012 #1017
  • Event source tracing improvements #1018
  • Changes to share common files between NetFx and NetCore source code #871 #887

[Preview Release 3.0.0-preview1.21075.2] - 2021-03-15

Breaking Changes over stable release v2.1

  • The minimum supported .NET Framework version has been increased to v4.6.1. .NET Framework v4.6.0 is no longer supported. #899

Added

  • Added support for Configurable Retry Logic #693 #966
  • Added support for Event counters in .NET Core 3.1+ and .NET Standard 2.1+ #719
  • Added support for Assembly Context Unloading in .NET Core #913
  • Added missing System.Runtime.Caching dependency for .NET Standard assemblies #877

Fixed

  • Fixed wrong results issues by changing the timeout timer to ensure a correct execution state #906
  • Fixed Kerberos authentication issues when configured Server Principal Name (SPN) didn't contain default port #930
  • Fixed MARS header errors when MakeReadAsyncBlocking App Context switch is set to false #910 #922
  • Fixed unwanted exceptions being thrown from SqlDataReader.Dispose #920
  • Fixed issues connecting to SQL Server instance with instance name specified from Unix environment #870
  • Fixed TCP Keep Alive issues in .NET Core #854
  • Fixed Kerberos Authentication issues caused due to regression #845
  • Fixed issues with System-Assigned Managed Identity in Azure Functions #829
  • Fixed missing error messages in Managed SNI #882
  • Fixed event source trace string issue #940

Changed

  • Changed App Context switch MakeReadAsyncBlocking default to false #937
  • Replaced usage of BinaryFormatter with DataContractSerializer #869
  • Prohibited DtdProcessing on XmlTextReader instance in .NET Core #884
  • Improved performance by reducing memory allocations in SerializeEncodingChar/WriteEncodingChar and some options boxing #785
  • Improved performance by preventing orphaned active packets being GC'ed without clear #888
  • Various performance improvements #889 #900
  • Partial event source tracing improvements in .NET Core #867 #897
  • Changes to share common files between NetFx and NetCore source code #827 #835 #838 #881

[Stable Release 1.1.4] - 2021-03-10

Fixed

  • Fixed wrong results issues by changing the timeout timer to ensure a correct execution state #950
  • Fixed MARS header contains errors issue against .NET Framework 4.8+ #959

[Stable Release 2.1.2] - 2021-03-03

Fixed

  • Fixed issue connecting with instance name from a Linux/macOS environment #874
  • Fixed wrong results issues by changing the timeout timer to ensure a correct execution state #929
  • Fixed a vulnerability by prohibiting DtdProcessing on XmlTextReader instances in .NET Core #885
  • Fixed Kerberos authentication when an SPN does not contain the port #935
  • Fixed missing error messages in Managed SNI #883
  • Fixed missing System.Runtime.Caching dependency for .NET Standard assemblies #878
  • Fixed event source tracing issues #941
  • Fixed MARS header contains errors issue against .NET Framework 4.8.1 #928

[Stable Release 2.1.1] - 2020-12-18

Fixed

  • Fixed issue with System-Assigned Managed Identity in Azure Functions #841
  • Fixed issue with Kerberos Authentication for .NET Core in Unix environments #848
  • Fixed issue with TCP Keep Alive for .NET Core in Unix environments #855

[Stable Release 2.1.0] - 2020-11-19

Added

  • Microsoft.Data.SqlClient symbols are now source-linked #789
  • Added an API to clear cached access tokens from the token provider #800
  • Added SqlFacetAttribute implementation #757

Fixed

  • Fixed InvalidOperationException and NotSupportedException errors due to WriteAsync collisions #796
  • Fixed incorrect Settings.Async flag in ExecuteXmlReaderAsync #782
  • Fixed a regression in Windows Integrated authentication when using managed networking #777
  • Fixed Bulk Copy Async deadlock issues with custom IDataReader when using SqlDataReader internally #779
  • Fixed a serialization issue with SqlException in .NET Core #780

Changed

  • Updated versions of Microsoft.IdentityModel package dependencies #794

[Preview Release 2.1.0-preview2.20297.7] - 2020-10-23

Added

  • Added support for Azure Active Directory Managed Identity authentication #730
  • Added support to provide a user-defined application client ID when using Active Directory authentication #740
  • Added the "Command Timeout" connection string property to set a default timeout for all commands executed with the connection #722
  • Added support for Always Encrypted on all supported platforms for .NET Standard 2.0 #756

Fixed

  • Fixed unobserved exception issue when a timeout occurs before a faulted task completes with an exception #688 #773
  • Fixed an issue where driver continues to prompt for credentials when using Azure Active Directory authentication #770

Changed

  • Updated Microsoft.Data.SqlClient.SNI (.NET Framework dependency) and Microsoft.Data.SqlClient.SNI.runtime (.NET Core/Standard dependency) version to v2.1.1 and removed symbols from Microsoft.Data.SqlClient.SNI.runtime, which are now published to Microsoft Symbols Server #764
  • Updated Microsoft.Identity.Client dependency version to v4.21.1 #765
  • Performance improvements when establishing an encrypted channel by removing sync over async method calls #541
  • Performance improvements by replacing heap-allocated arrays with Spans #667
  • Moved common files to shared folder between .NET Framework and .NET Core implementation #734 #753

[Stable Release 2.0.1] - 2020-08-25

Added

  • Added support for a new Configuration Section, SqlClientAuthenticationProviders (duplicate of existing SqlAuthenticationProviders), to allow co-existence of configurations for both drivers, "System.Data.SqlClient" and "Microsoft.Data.SqlClient" #701

Fixed

  • Fixed pooled connection re-use on access token expiry issue when using Active Directory authentication modes #639
  • Fixed transient fault handling for Pooled connections #638
  • Fixed Enclave session cache issue with Azure Database #628
  • Reverted changes to return empty DataTable from GetSchemaTable to return null as before. #697
  • Fixed configuration section collision issue with System.Data.SqlClient type #701
  • Fixed blank error message [HTTP Provider] issues due to unexpected pre-login failures when using Native SNI. Fixed with Microsoft.Data.SqlClient.SNI v2.0.1 and Microsoft.Data.SqlClient.SNI.runtime v2.0.1 release versions.

[Preview Release 2.1.0-preview1.20235.1] - 2020-08-21

Added

  • Added support for Always Encrypted with secure enclaves on Unix for .NET Core 2.1+ and on all supported platforms for .NET Standard 2.1+ #676
  • Added support for Azure Active Directory Device Code Flow authentication #597
  • Added Sensitivity Rank support in Sensitivity Classification information #626
  • Added support to obtain ServerProcessId (SPID) information on an active SqlConnection instance #660
  • Added support for a new Configuration Section, SqlClientAuthenticationProviders (duplicate of existing SqlAuthenticationProviders), to allow co-existence of configurations for both drivers, "System.Data.SqlClient" and "Microsoft.Data.SqlClient" #702
  • Added TraceLogging in Native SNI to extend SqlClientEventSource support #650
  • Updated Microsoft.Data.SqlClient.SNI (.NET Framework dependency) and Microsoft.Data.SqlClient.SNI.runtime (.NET Core/Standard dependency) version to v2.1.0 with trace logging implementation #705

Fixed

  • Fixed Enclave session cache issue with Azure Database #686
  • Fixed pooled connection re-use on access token expiry issue when using Active Directory authentication modes #635
  • Fixed transient fault handling for Pooled connections #637
  • Fixed SPN generation issue when no port is provided #629
  • Fixed missing null checks for SqlErrors in SqlException for .NET Framework implementation #698

Changed

  • Performance improvements by fixing unnecessary allocations with EventSource implementation #684
  • Reverted changes to return empty DataTable from GetSchemaTable to return null as before. #696
  • Removed multiple CacheConnectionStringProperties calls when setting ConnectionString properties #683
  • Code Improvements by only checking inexact match when no exact match is found for an embedded resource #668
  • Changed _SqlMetaData to lazy initialize hidden column map #521
  • Renamed internal string resource file and helpers for .NET Core implementation #671
  • Performance improvements by reworking ExecuteReaderAsync to minimize allocations #528
  • Performance improvements by moving DataReader caches to internal connection #499
  • Moved common files to shared folder between .NET Framework and .NET Core implementation #618 #625

[Stable Release 2.0.0] - 2020-06-16

Added

  • Added internal driver support to provide resiliency to DNS failures #594
  • Added support for Active Directory Integrated, Active Directory Interactive and Active Directory Service Principal authentication mode for .NET Core and .NET Standard #560
  • Added support for Active Directory Service Principal authentication mode for .NET Framework #560
  • Added support for optional ORDER hints in SqlBulkCopy for improved performance #540

Fixed

  • Fixed SqlSequentialStream multipacket read stalling issue in .NET Core #603
  • Fixed code page issue for Kazakh collation in SQL Server #584
  • Fixed stalled application issues when end of stream is reached #577
  • Fixed driver behavior to not throw exception for invalid configuration file #573
  • Fixed Object null reference issue when failover partner is set #588
  • Fixed applicationintent connection string property issue #585

Changed

  • Raise warning message when insecure TLS protocols are in use #591

Breaking Changes

  • Modified enclave provider interface SqlColumnEncryptionEnclaveProvider to be internal #602 - This change is not likely to impact customer applications since secure enclaves is a relatively new feature and they would have had to implement their own enclave provider, which is not a trivial task.
  • Updated SqlClientMetaDataCollectionNames exposed constants by removing non-existing constants and adding new to the metadata collection #580

[Preview Release 2.0.0-preview4.20142.4] - 2020-05-21

Added

  • Microsoft.Data.SqlClient (.NET Core and .NET Standard) on Windows is now dependent on Microsoft.Data.SqlClient.SNI.runtime, replacing the previous dependency on runtime.native.System.Data.SqlClient.SNI #570
  • The new Microsoft.Data.SqlClient.SNI.runtime dependency adds support for the ARM platform along with the already supported platforms ARM64, x64 and x86 on Windows #570
  • Improved driver performance by introducing managed packet recycling #389

Fixed

  • Fixed SqlBulkCopy to work with database columns containing metadata about data classification #568
  • Fixed unsafe cast in SqlException for SerializationEntry.Value
  • Fixed null reference exceptions in SqlDelegatedTransaction methods #563

Changed

  • Standardized connection string properties for enhanced user experience #534
  • Improved performance by reducing eventsource tracing related to allocations from TVP write methods #557 #564

Breaking Changes

  • For .NET Framework applications consuming Microsoft.Data.SqlClient, the SNI.dll files previously downloaded to the bin\x64 and bin\x86 folders are now named Microsoft.Data.SqlClient.SNI.x64.dll and Microsoft.Data.SqlClient.SNI.x86.dll and will be downloaded to the bin directory, to support auto-loading in the application process #570. This change is not going to impact client applications unless a direct reference has been made to SNI.dll or the x86 and x64 folders.

[Stable Release 1.1.3] - 2020-05-15

Fixed

  • Fixed driver behavior to not perform enlistment of pooled connection on aborted transaction #551
  • Fixed issues introduced with MARS TDS Header fix in last release by reverting original change that caused issues. #550

[Preview Release 2.0.0-preview3.20122.2] - 2020-05-01

Added

  • Allow passing username with Active Directory Interactive Authentication in .NET Framework #492
  • Allow large UDT buffers for .NET Framework #456
  • Added "Transaction Id" and "Client Version" in Diagnostic Source traces #515
  • Added new SqlConnectionOverrides APIs to perform SqlConnection.Open() with fail fast option #463

Fixed

  • Addressed MARS TDS Header errors by reverting changes to make SqlDataReader.ReadAsync() non-blocking #547
  • Fixed driver behavior to not perform enlistment of pooled connection in aborted transaction #543
  • Fixed wrong application domain selected when starting SqlDependencyListener #410
  • Added missing refs for RowCopied property in SqlBulkCopy #508

Changed

  • Improved performance by removing unwanted method calls in Event Source tracing #506
  • Removed Diagnostic Source and Configuration Manager dependencies from .NET Standard implementation #535
  • Removed redundant calls to DbConnectionPoolKey.GetType() #512

Breaking Changes

  • Updated driver to perform decimal scale rounding to match SQL Server behavior #470
  • Standardized App Context switch name that enables Managed SNI on Windows for .NET Core and .NET Standard (break only applies to 2.0 preview releases that introduced the switch) #548

[Stable Release 1.1.2] - 2020-04-15

Added

  • Allowed passing username with Active Directory Interactive Authentication #493 #516

Fixed

  • Fixed the ConnectionString's password persistence in .NET Core. #489
  • Addressed MARS TDS header containing errors #510

Changed

  • Updated driver libraries to be CLS Compliant #522

[Preview Release 2.0.0-preview2.20084.1] - 2020-03-24

Added

  • Added support for capturing EventSource traces in .NET Framework, .NET Core, and .NET Standard applications #399 #461 #479 #483 #484
  • Added support for Cross-platform TCP Keep Alive applicable to .NET Core 3.1+ applications #395
  • Added support for enabling Managed networking implementation on Windows applicable to .NET Core and .NET Standard applications #477
  • Added RowsCopied property in SqlBulkCopy to expose count of copied rows #409
  • Added "NeutralResourcesLanguage" attribute for .NET Framework assembly #433
  • Added caching for invariant culture check result #376
  • Added cached SqlReferenceCollection.FindLiveReaderContext objects #380

Fixed

  • Fixed Access Token behavior in connection pool to perform string comparison #443
  • Fixed concurrent connection speed issues when connecting with Azure Active Directory Authentication modes in .NET Core #466
  • Fixed issues with Password persistence in Connection String #453

Changed

  • Updated all driver assemblies to be CLS Compliant #396
  • Updated Bulk Copy error messages to also include Column, Row and non-encrypted Data information #437
  • Updated error messages for "Always Encrypted - Secure Enclaves" to handle 'Attestation Protocol' and fixed typos #421 #397
  • Removed sync over async in SNINpHandle.EnableSsl #474
  • Changed non-generic ArrayList to List<T> in SqlBulkCopy #457
  • Multiple performance improvements #377 #378 #379

Breaking Changes

  • The driver will now perform Server Certificate validation when TLS encryption is enforced by the target Server, which is the default for Azure connections #391
  • SqlDataReader.GetSchemaTable() now returns an empty DataTable instead of returning null #419

[Stable Release 1.1.1] - 2020-02-14

Fixed

  • Fixed deadlock issues by reverting async changes to SNIPacket #425

Changed

  • Updated SNI package reference to include version range #425

[Preview Release 2.0.0-preview1.20021.1] - 2020-01-21

Added

  • Added support to allow large UDT buffer size (upto Int.MaxValue) as supported by SQL Server starting TDS 7.3 #340

Fixed

  • Fixed issues with SqlCommandSet not working with Byte Array parameters #360
  • Fixed Statement command cancellation in Managed SNI #248 - Ported dotnet/corefx#38271
  • Fixed zero connection timeout issue in Managed SNI #332
  • Fixed "DataType" metadata information for TinyInt datatype to be System.Byte #338
  • Fixed driver behavior to use CancellationTokenResource only for non-infinite timeout and cleanup after usage #339
  • Fixed ConnectionTime and ClientConnectionId reported by SqlStatistics when connection is closed #341
  • Fixed deadlock issues by reverting async changes to SNIPacket #349

Changed

  • Improved performance of Managed SNI by removing double fetch of domain name #366
  • Improved performance of Async Method Allocations in Managed SNI #328
  • Improved performance of Managed SNI by enhancing utilization of resources #173 - Ported dotnet/corefx#35363 and dotnet/corefx#40732
  • Improved performance of Managed SNI RPC Parameter Usage #209 - Ported dotnet/corefx#34049
  • Changed enclave key map to be lazy initialized #372
  • Changed Receive() and ReceiveAsync() implementation to receive null packets on failure #350
  • Changed EnclaveProviderBase caching implementation to support Async Scenarios (Introduces breaking changes) #346

[Stable Release 1.1.0] - 2019-11-20

Added

  • Added support for |DataDirectory| macro in AttachDBFilename for .NET Core client #284

Fixed

  • Fixed connection resiliency check #310
  • Fixed SNIPacket.ReadFromStreamAsync to not consume same ValueTask twice #295
  • Fixed driver behavior to not send Attention signal for successful Bulk Copy operation #308
  • Fixed driver behavior to abort connection when encountering SqlException on SqlTransaction.Commit #299
  • Fixed driver behavior to not throw exception on invalid app.config files #319

Changed

  • Improved async read performance by adding multi-packet target buffer caching #285
  • Improved performance of TdsParserStateObject and SqlDataReader snapshot mechanisms #198
  • Updated SqlDataReader.Close documentation #314

[Preview Release 1.1.0-preview2.19309.1] - 2019-11-04

Added

  • Add support for secure enclaves with Always Encrypted #293

Fixed

  • Setting the value DbParameter.DbType to DbType.Time property fails after setting the Value property #5
  • SQLDataAdapter.FillSchema doesn't mark computed columns as readonly #275
  • SqlDependency.Start throws FileNotFoundException #260
  • Misleading ADP_OpenReaderExists exception message on MARS-disabled Sql Connection when incorrectly doing parallel requests #82
  • SqlClient ManualTest MARSSyncTimeoutTest fails in managed mode #108
  • System.Data.SqlClient.SqlInternalConnectionTds constructor purges original call stack when re-throwing an exception #100
  • InvalidOperationException(SqlException) on SqlBulkCopy #221
  • Exception message grammar: "An SqlParameter [...] is not contained by this SqlParameterCollection" #159
  • Fixing incorrect event id and opcode for the SqlEventSource #241

Changed

  • Update dependency to Microsoft.Data.SqlClient.SNI v1.1.0 #276
  • Correct timeout remarks for async command methods #264
  • Improve SqlBulkCopy truncation error message #256
  • Intellisense tooltip for SqlCommand's CommandTimeout doesn't describe units #33
  • Enable SQL Command text for non-stored procs in EventSource events for .NET Framework 242
  • Many test changes to support a public CI

[Preview Release 1.1.0-preview1.19275.1] - 2019-10-02

Added

  • Added SqlFileStream support for .NET Framework with Microsoft.Data.SqlTypes.SqlFileStream class introduced. #210
  • Added support for Visual Studio Intellisense with XML Documentation. #210

Changed

  • Synchronized ref definitions with driver classes. #180
  • Updated SNINativeMethodWrapper to provide the underlying error in the inner exception when we fail to load SNI.dll. #225
  • Added .editorconfig file and set formatting rules. #193
  • Changes done to handle statistics well and to cleanup AutoResetEvent on disconnect. #232

[Hotfix & Stable Release 1.0.19269.1] - 2019-09-26

Fixed Issues

  • SqlCommand.StatementCompleted event never being fired #212
  • Added missing Authentication property to SqlConnectionStringBuilder reference assembly
  • Reverted API changes in SqlAuthenticationParameters which had changed the public string Resource property to public string[] Scopes

[Hotfix & Stable Release 1.0.19249.1] - 2019-09-06

Fixed Issues

  • Fixed issues with large data reading in Unix applications when data is spanned over multiple packets. #171

[Stable Release 1.0.19239.1] - 2019-08-27

Initial release. Release Notes uploaded in 1.0.md