Released: Microsoft.Data.SqlClient 6.0 Preview 1

Microsoft.Data.SqlClient 6.0 Preview 1 has been released. This release contains improvements and updates to the Microsoft.Data.SqlClient data provider for SQL Server.

Our plan is to provide regular GA releases with several preview releases in between. This cadence should provide time for feedback and allow us to deliver features and fixes in a timely manner. This 6.0 preview includes fixes and changes over the 5.2 GA 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

• Replaced System.Runtime.Caching with Microsoft.Extensions.Caching.Memory. #2493
• Improved memory allocation when reader opened by CommandBehavior.SequentialAccess over big string columns. #2356

For the full list of changes in Microsoft.Data.SqlClient 6.0 Preview 1, 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 6.0 preview 1 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