[Preview Release 6.0.0-preview1.24240.8] - 2024-08-27

This update brings the below changes over the 5.2 release:

Breaking Changes

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

Added

• AddedTokenCredential object to take advantage of token caching inActiveDirectoryAuthenticationProvider.#2380
• AddedDateOnly andTimeOnly support toDataTable as a structured parameter.#2258
• AddedMicrosoft.Data.SqlClient.Diagnostics.SqlClientDiagnostic type in .NET.#2226
• Added scope trace forGenerateSspiClientContext.#2497,#2725

Fixed

• FixedSocket.Connect timeout issue caused by thread starvation.#2777
• Fixed pending data withSqlDataReader against an encrypted column.#2618
• Fixed Entra authentication when using infinite connection timeout inActiveDirectoryAuthenticationProvider.#2651
• FixedGetSchema by excluding unsupported engines due to lack of support forASSEMBLYPROPERTY 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 ofSqlConnection to includeAccessTokenCallback.#2525
• Fixed issue withDateTimeOffset in table-valued parameters, which was introduced in 5.2.#2453
• FixedArgumentNullException onSqlDataRecord.GetValue when using user-defined data type on .NET.#2448
• FixedSqlBuffer andSqlGuild when it's null.#2310
• FixedSqlBulkCopy.WriteToServer state in a consecutive calls.#2375
• Fixed null reference exception withSqlConnection.FireInfoMessageEventOnUserErrors after introducing the batch command.#2399

Changed

• Updated Microsoft.Data.SqlClient.SNI version to6.0.0-preview1.24226.4.#2772
• Improved access toSqlAuthenticationProviderManager.Instance and avoid early object initiation.#2636
• Removed undocumented properties ofAzure.Identity inActiveDirectoryAuthenticationProvider.#2562
• ReplacedSystem.Runtime.Caching withMicrosoft.Extensions.Caching.Memory.#2493
• UpdatedEnableOptimizedParameterBinding to only accept text mode commands.#2417
• UpdatedAzure.Identity version from1.10.3 to1.11.4.#2577
• UpdatedAzure.Core version from1.35.0 to1.38.0.#2462
• UpdatedAzure.Security.KeyVault.Keys version from4.4.0 to4.5.0.#2462
• UpdatedMicrosoft.IdentityModel.JsonWebTokens andMicrosoft.IdentityModel.Protocols.OpenIdConnect from6.35.0 to7.5.0.#2429
• Removed direct dependency toMicrosoft.Identity.Client to take the transient dependecy throughAzure.Identity.#2577
• Removed unnecessary referencesMicrosoft.Extensions.Caching.Memory andSystem.Security.Cryptography.Cng after removing .NET Standard.#2577
• Improved memory allocation when reader opened byCommandBehavior.SequentialAccess over the big string columns.#2356
• Improved SSPI by consolidating the context generation to single abstraction and using memory/span for SSPI generation.#2255,#2447
• Reverted the#2281 code changes on ManagedSNI.#2395
• Updated assembly version to 6.0.0.0.#2382
• Code health improvements:#2366,#2369,#2381,#2390,#2392,#2403,#2410,#2413,#2425,#2428,#2440,#2443,#2450,#2466,#2486,#2521,#2522,#2533,#2552,#2560,#2726,#2751,#2811

For detailed release notes, refer to6.0.0-preview1.md