This update brings the below changes over the previous release:
Thanks to the following public contributors. Their efforts toward this project are very much appreciated.
- Added
TokenCredential
object to take advantage of token caching inActiveDirectoryAuthenticationProvider
. #2380 - Added
DateOnly
andTimeOnly
support toDataTable
as a structured parameter. #2258 - Added
Microsoft.Data.SqlClient.Diagnostics.SqlClientDiagnostic
type in .NET. #2226 - Added scope trace for
GenerateSspiClientContext
. #2497, #2725
- 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 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 of
SqlConnection
to includeAccessTokenCallback
. #2525 - Fixed issue with
DateTimeOffset
in table-valued parameters, which was introduced in 5.2. #2453 - Fixed
ArgumentNullException
onSqlDataRecord.GetValue
when using user-defined data type on .NET. #2448 - Fixed
SqlBuffer
andSqlGuild
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
- Updated Microsoft.Data.SqlClient.SNI version to
6.0.0-preview1.24226.4
. #2772 - Improved access to
SqlAuthenticationProviderManager.Instance
and avoid early object initiation. #2636 - Removed undocumented properties of
Azure.Identity
inActiveDirectoryAuthenticationProvider
. #2562 - Replaced
System.Runtime.Caching
withMicrosoft.Extensions.Caching.Memory
. #2493 - Updated
EnableOptimizedParameterBinding
to only accept text mode commands. #2417 - Updated
Azure.Identity
version from1.10.3
to1.11.4
. #2577 - Updated
Azure.Core
version from1.35.0
to1.38.0
. #2462 - Updated
Azure.Security.KeyVault.Keys
version from4.4.0
to4.5.0
. #2462 - Updated
Microsoft.IdentityModel.JsonWebTokens
andMicrosoft.IdentityModel.Protocols.OpenIdConnect
from6.35.0
to7.5.0
. #2429 - Removed direct dependency to
Microsoft.Identity.Client
to take the transient dependecy throughAzure.Identity
. #2577 - Removed unnecessary references
Microsoft.Extensions.Caching.Memory
andSystem.Security.Cryptography.Cng
after removing .NET Standard. #2577 - Improved memory allocation when reader opened by
CommandBehavior.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
- .NET Framework 4.6.2+ (Windows x86, Windows x64)
- .NET 6.0+ (Windows x86, Windows x64, Windows ARM64, Windows ARM, Linux, macOS)
- Microsoft.Data.SqlClient.SNI 6.0.0-preview1.24226.4
- Azure.Identity 1.11.4
- Microsoft.Extensions.Caching.Memory 6.0.1
- Microsoft.IdentityModel.JsonWebTokens 7.5.0
- Microsoft.IdentityModel.Protocols.OpenIdConnect 7.5.0
- System.Buffers 4.5.1
- System.Text.Encodings.Web 6.0.0
- Microsoft.Data.SqlClient.SNI.runtime 6.0.0-preview1.24226.4
- Azure.Identity 1.11.4
- Microsoft.Extensions.Caching.Memory 6.0.1
- Microsoft.IdentityModel.JsonWebTokens 7.5.0
- Microsoft.IdentityModel.Protocols.OpenIdConnect 7.5.0
- Microsoft.SqlServer.Server 1.0.0
- System.Configuration.ConfigurationManager 6.0.1
- Microsoft.Data.SqlClient.SNI.runtime 6.0.0-preview1.24226.4
- Azure.Identity 1.11.4
- Microsoft.Extensions.Caching.Memory 8.0.0
- Microsoft.IdentityModel.JsonWebTokens 7.5.0
- Microsoft.IdentityModel.Protocols.OpenIdConnect 7.5.0
- Microsoft.SqlServer.Server 1.0.0
- System.Configuration.ConfigurationManager 8.0.0