Skip to content

Preview Release v5.0.0-preview3

Pre-release
Pre-release
Compare
Choose a tag to compare
@Kaur-Parminder Kaur-Parminder released this 17 Jun 19:45
· 542 commits to main since this release
4fb0bca

[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