Preview Release v5.0.0-preview3

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

Breaking changes over preview release v5.0.0-preview2

• Added a dependency on the Microsoft.SqlServer.Server package. This new dependency may cause namespace conflicts if your application references that namespace and still has package references (direct or indirect) to System.Data.SqlClient from .NET Core.
• 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] (#1637)
• Fixed NullReferenceException during Azure Active Directory authentication. [#1625] (#1625)
• Added CommandText length validation when using stored procedure command types. #1484
• Fixed GetSchema("StructuredTypeMembers") to return correct schema information. [#1500] (#1500), #1639
• Fixed NullReferenceException when using SqlDependency.Start against an Azure SQL Database.[#1294] (#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] (#1624)
• Parallelize SSRP requests (instance name resolution) on Linux and macOS when MultiSubNetFailover is specified. [#1578] (#1578)
• Adjust the default ConnectRetryCount against Azure Synapse OnDemand endpoints [#1626] (#1626)

Changed

• Dropped the Microsoft.Data.SqlClient.Server namespace and replaced it with supported types from the Microsoft.SqlServer.Server package.#1585
• 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] (#1548)
• Rework on TdsParserStateObjectManaged with nullable annotations. [#1555] (#1555)

For detailed release notes, refer 5.0.0-preview3.md

Preview Release v5.0.0-preview2

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

For detailed release notes, refer 5.0.0-preview2.md

Stable Release v3.1.0

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

For detailed release notes, refer to 3.1.0.md

Preview Release v5.0.0-preview1.22069.1

[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 v4.1.0

Added

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

For detailed release notes, refer to 4.1.0.md

[MSqlServerServer] Stable Release v1.0.0

This is the initial public stable release of the Microsoft.SqlServer.Server namespace in a separate assembly. This library is a dependency for Microsoft.Data.SqlClient enabling cross framework support of UDT types.

Detailed release notes are available here.

Hotfix & Stable Release v4.0.1

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 v4.0.0

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

For summary of all changes over v3.0, refer to 4.0.0.md

Preview Release v4.0.0-preview3.21293.2

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.

For detailed release notes, refer 4.0.0-preview3.md

Hotfix & Stable Release v3.0.1

Fixed

• Fixed async thread blocking issues on SqlConnection.Open() for active directory authentication modes. #1270
• Fixed unknown transaction state issues when promoting delegated transaction. 1247
• Fixed issue with connection encryption to ensure connections fail when encryption is required. #1233 Read more
• 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