Microsoft.Data.SqlClient 5.0 Preview 3 has been released. This release contains improvements and updates to the Microsoft.Data.SqlClient data provider for SQL Server.
Our plan is to provide GA releases twice a year with two or three preview releases in between. This cadence should provide time for feedback and allow us to deliver features and fixes in a timely manner. This third 5.0 preview includes fixes and changes over the previous preview release.
Breaking changes over v5.0.0-preview2
- Several classes were removed from the Microsoft.Data.SqlClient.Server namespace. They should now be referenced in the Microsoft.SqlServer.Server namespace and package that is now a dependency of Microsoft.Data.SqlClient when targeting .NET/.NET Core.
- The new dependency on the standalone Microsoft.SqlServer.Server package may cause a duplicate namespace issue if your application is referencing Microsoft.SqlServer.Server and has a dependency (direct or indirect) on System.Data.SqlClient from .NET Core. (Read more)
Added
- Added support for
TDS 8. To use TDS 8, users should specify Encrypt=Strict in the connection string. #1608 Read more
- Added support for specifying Server SPN and Failover Server SPN on the connection. #1607 Read more
- Added support for aliases when targeting .NET Core on Windows. #1588 Read more
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 on Linux and macOS when MultiSubNetFailover is specified. [#1578] (#1578)
- Adjust the default ConnectRetryCount against Azure Synapse OnDemand endpoints [#1626] (#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] (#1548)
- Rework on
TdsParserStateObjectManaged with nullable annotations. [#1555] (#1555)
For the full list of changes in Microsoft.Data.SqlClient 5.0 Preview 3, please see the Release Notes.
To try out the new package, add a NuGet reference to Microsoft.Data.SqlClient in your application and pick the 5.0 preview 3 version.
We appreciate the time and effort you spend checking out our previews. It makes the final product that much better. If you encounter any issues or have any feedback, head over to the SqlClient GitHub repository and submit an issue.
David Engel
