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.

[HEADING=2]Breaking Changes[/HEADING]

• Removed support for .NET Standard. #2386
  
• Removed UWP (UAP) references. #2483
  

[HEADING=2]Added[/HEADING]

• Added [iCODE]TokenCredential[/iCODE] object to take advantage of token caching in [iCODE]ActiveDirectoryAuthenticationProvider[/iCODE]. #2380
  
• Added [iCODE]DateOnly[/iCODE] and [iCODE]TimeOnly[/iCODE] support to [iCODE]DataTable[/iCODE] as a structured parameter. #2258
  
• Added [iCODE]Microsoft.Data.SqlClient.Diagnostics.SqlClientDiagnostic[/iCODE] type in .NET. #2226
  
• Added scope trace for [iCODE]GenerateSspiClientContext[/iCODE]. #2497, #2725
  

[HEADING=2]Fixed[/HEADING]

• Fixed [iCODE]Socket.Connect[/iCODE] timeout issue caused by thread starvation. #2777
  
• Fixed pending data with [iCODE]SqlDataReader[/iCODE] against an encrypted column. #2618
  
• Fixed Entra authentication when using infinite connection timeout in [iCODE]ActiveDirectoryAuthenticationProvider[/iCODE]. #2651
  
• Fixed [iCODE]GetSchema[/iCODE] by excluding unsupported engines due to lack of support for [iCODE]ASSEMBLYPROPERTY[/iCODE] function. #2593
  
• Fixed SSPI retry negotiation with default port in .NET. #2559
  
• Fixed assembly path in .NET 8.0 and [iCODE].AssemblyAttributes[/iCODE]. #2550
  
• Fixed certificate chain validation. #2487
  
• Fixed clone of [iCODE]SqlConnection[/iCODE] to include [iCODE]AccessTokenCallback[/iCODE]. #2525
  
• Fixed issue with [iCODE]DateTimeOffset[/iCODE] in table-valued parameters, which was introduced in 5.2. #2453
  
• Fixed [iCODE]ArgumentNullException[/iCODE] on [iCODE]SqlDataRecord.GetValue[/iCODE] when using user-defined data type on .NET. #2448
  
• Fixed [iCODE]SqlBuffer[/iCODE] and [iCODE]SqlGuild[/iCODE] when it's null. #2310
  
• Fixed [iCODE]SqlBulkCopy.WriteToServer[/iCODE] state in a consecutive calls. #2375
  
• Fixed null reference exception with [iCODE]SqlConnection.FireInfoMessageEventOnUserErrors[/iCODE] after introducing the batch command. #2399
  

[HEADING=2]Changed[/HEADING]

• Replaced [iCODE]System.Runtime.Caching[/iCODE] with [iCODE]Microsoft.Extensions.Caching.Memory[/iCODE]. #2493
  
• Improved memory allocation when reader opened by [iCODE]CommandBehavior.SequentialAccess[/iCODE] 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

Continue reading...