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
