Released: Microsoft.Data.SqlClient 6.0 Preview 1

Microsoft.Data.SqlClient 6.0 Preview 1 is now available. This release includes 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 cycle provides time for feedback and allows us to provide features and fixes in a timely manner. This 6.0 preview includes fixes and changes from the 5.2 GA release.

Important changes

• Support for .NET Standard has been removed. #2386
• UWP(UAP) references have been removed. #2483

Added

• Added TokenCredential Object for leveraging token caching ActiveDirectoryAuthenticationProvider. #2380
• Added DateOnly and TimeOnly Support DataTable As a structured parameter. #2258
• Added Microsoft.Data.SqlClient.Diagnostics.SqlClientDiagnostic Enter .NET. #2226
• Add range tracking GenerateSspiClientContext. #2497, #2725

determined

• determined Socket.Connect A timeout problem occurred due to thread starvation. #2777
• Fixed pending data. SqlDataReader About encrypted columns. #2618
• Entra authentication is now fixed when using infinite connection timeout. ActiveDirectoryAuthenticationProvider. #2651
• determined GetSchema By excluding unsupported engines due to lack of support. ASSEMBLYPROPERTY function. #2593
• Fixed SSPI retry negotiation using default port in .NET. #2559
• Fixed assembly path in .NET 8.0 .AssemblyAttributes. #2550
• Validate a fixed certificate chain. #2487
• Fixed Clone SqlConnection include AccessTokenCallback. #2525
• The problem has been solved DateTimeOffset Table-valued parameters introduced in 5.2. #2453
• determined ArgumentNullException ~ in SqlDataRecord.GetValue When using user-defined data types in .NET #2448
• determined SqlBuffer and SqlGuild When null. #2310
• determined SqlBulkCopy.WriteToServer Indicates status in consecutive calls. #2375
• Fixed null reference exception SqlConnection.FireInfoMessageEventOnUserErrors After introducing the batch command. #2399

Changed

• Replaced System.Runtime.Caching With ~ Microsoft.Extensions.Caching.Memory. #2493
• Improved memory allocation when the leader is opened. CommandBehavior.SequentialAccess On top of a large string column. #2356

For a complete list of changes in Microsoft.Data.SqlClient 6.0 Preview 1, see: Release Notes.

To try out new packages, add: NuGet Reference for Microsoft.Data.SqlClient Please select version 6.0 Preview 1 in the application form.

Thank you for taking the time and effort to check out the preview. It makes the final product much better. If you encounter any issues or have any feedback, please move on to the next. SqlClient GitHub Repository And submit problem.

David Angel