|
| 1 | +#Release Notes |
| 2 | + |
| 3 | +##[Preview Release 6.0.0-preview1.24240.8] - 2024-08-27 |
| 4 | + |
| 5 | +This update brings the below changes over the previous release: |
| 6 | + |
| 7 | +###Contributors |
| 8 | +Thanks to the following public contributors. Their efforts toward this project are very much appreciated. |
| 9 | + |
| 10 | +-[ErikEJ](https://github.com/ErikEJ) |
| 11 | +-[edwardneal](https://github.com/edwardneal) |
| 12 | +-[Wraith2](https://github.com/Wraith2) |
| 13 | +-[twsouthwick](https://github.com/twsouthwick) |
| 14 | +-[0xced](https://github.com/0xced) |
| 15 | +-[wilbit](https://github.com/wilbit) |
| 16 | +-[TrayanZapryanov](https://github.com/TrayanZapryanov) |
| 17 | + |
| 18 | +###Breaking Changes |
| 19 | + |
| 20 | +- Removed support for .NET Standard.[#2386](https://github.com/dotnet/SqlClient/pull/2386) |
| 21 | +- Removed UWP (uap) references.[#2483](https://github.com/dotnet/SqlClient/pull/2483) |
| 22 | + |
| 23 | +###Added |
| 24 | + |
| 25 | +- Added`TokenCredential` object to take advantage of token caching in`ActiveDirectoryAuthenticationProvider`.[#2380](https://github.com/dotnet/SqlClient/pull/2380) |
| 26 | +- Added`DateOnly` and`TimeOnly` support to`DataTable` as a structured parameter.[#2258](https://github.com/dotnet/SqlClient/pull/2258) |
| 27 | +- Added`Microsoft.Data.SqlClient.Diagnostics.SqlClientDiagnostic` type in .NET.[#2226](https://github.com/dotnet/SqlClient/pull/2226) |
| 28 | +- Added scope trace for`GenerateSspiClientContext`.[#2497](https://github.com/dotnet/SqlClient/pull/2497),[#2725](https://github.com/dotnet/SqlClient/pull/2725) |
| 29 | + |
| 30 | +###Fixed |
| 31 | + |
| 32 | +- Fixed`Socket.Connect` timeout issue caused by thread starvation.[#2777](https://github.com/dotnet/SqlClient/pull/2777) |
| 33 | +- Fixed pending data with`SqlDataReader` against an encrypted column.[#2618](https://github.com/dotnet/SqlClient/pull/2618) |
| 34 | +- Fixed Entra authentication when using infinite connection timeout in`ActiveDirectoryAuthenticationProvider`.[#2651](https://github.com/dotnet/SqlClient/pull/2651) |
| 35 | +- Fixed`GetSchema` by excluding unsupported engines due to lack of support for`ASSEMBLYPROPERTY` function.[#2593](https://github.com/dotnet/SqlClient/pull/2593) |
| 36 | +- Fixed SSPI retry negotiation with default port in .NET.[#2559](https://github.com/dotnet/SqlClient/pull/2559) |
| 37 | +- Fixed assembly path in .NET 8.0 and`.AssemblyAttributes`.[#2550](https://github.com/dotnet/SqlClient/pull/2550) |
| 38 | +- Fixed certificate chain validation.[#2487](https://github.com/dotnet/SqlClient/pull/2487) |
| 39 | +- Fixed clone of`SqlConnection` to include`AccessTokenCallback`.[#2525](https://github.com/dotnet/SqlClient/pull/2525) |
| 40 | +- Fixed issue with`DateTimeOffset` in table-valued parameters, which was introduced in 5.2.[#2453](https://github.com/dotnet/SqlClient/pull/2453) |
| 41 | +- Fixed`ArgumentNullException` on`SqlDataRecord.GetValue` when using user-defined data type on .NET.[#2448](https://github.com/dotnet/SqlClient/pull/2448) |
| 42 | +- Fixed`SqlBuffer` and`SqlGuild` when it's null.[#2310](https://github.com/dotnet/SqlClient/pull/2310) |
| 43 | +- Fixed`SqlBulkCopy.WriteToServer` state in a consecutive calls.[#2375](https://github.com/dotnet/SqlClient/pull/2375) |
| 44 | +- Fixed null reference exception with`SqlConnection.FireInfoMessageEventOnUserErrors` after introducing the batch command.[#2399](https://github.com/dotnet/SqlClient/pull/2399) |
| 45 | + |
| 46 | +###Changed |
| 47 | + |
| 48 | +- Updated Microsoft.Data.SqlClient.SNI version to`6.0.0-preview1.24226.4`.[#2772](https://github.com/dotnet/SqlClient/pull/2772) |
| 49 | +- Improved access to`SqlAuthenticationProviderManager.Instance` and avoid early object initiation.[#2636](https://github.com/dotnet/SqlClient/pull/2636) |
| 50 | +- Removed undocumented properties of`Azure.Identity` in`ActiveDirectoryAuthenticationProvider`.[#2562](https://github.com/dotnet/SqlClient/pull/2562) |
| 51 | +- Replaced`System.Runtime.Caching` with`Microsoft.Extensions.Caching.Memory`.[#2493](https://github.com/dotnet/SqlClient/pull/2493) |
| 52 | +- Updated`EnableOptimizedParameterBinding` to only accept text mode commands.[#2417](https://github.com/dotnet/SqlClient/pull/2417) |
| 53 | +- Updated`Azure.Identity` version from`1.10.3` to`1.11.4`.[#2577](https://github.com/dotnet/SqlClient/pull/2577) |
| 54 | +- Updated`Azure.Core` version from`1.35.0` to`1.38.0`.[#2462](https://github.com/dotnet/SqlClient/pull/2462) |
| 55 | +- Updated`Azure.Security.KeyVault.Keys` version from`4.4.0` to`4.5.0`.[#2462](https://github.com/dotnet/SqlClient/pull/2462) |
| 56 | +- Updated`Microsoft.IdentityModel.JsonWebTokens` and`Microsoft.IdentityModel.Protocols.OpenIdConnect` from`6.35.0` to`7.5.0`.[#2429](https://github.com/dotnet/SqlClient/pull/2429) |
| 57 | +- Removed direct dependency to`Microsoft.Identity.Client` to take the transient dependecy through`Azure.Identity`.[#2577](https://github.com/dotnet/SqlClient/pull/2577) |
| 58 | +- Removed unnecessary references`Microsoft.Extensions.Caching.Memory` and`System.Security.Cryptography.Cng` after removing .NET Standard.[#2577](https://github.com/dotnet/SqlClient/pull/2577) |
| 59 | +- Improved memory allocation when reader opened by`CommandBehavior.SequentialAccess` over the big string columns.[#2356](https://github.com/dotnet/SqlClient/pull/2356) |
| 60 | +- Improved SSPI by consolidating the context generation to single abstraction and using memory/span for SSPI generation.[#2255](https://github.com/dotnet/SqlClient/pull/2255),[#2447](https://github.com/dotnet/SqlClient/pull/2447) |
| 61 | +- Reverted the[#2281](https://github.com/dotnet/SqlClient/pull/2281) code changes on ManagedSNI.[#2395](https://github.com/dotnet/SqlClient/pull/2395) |
| 62 | +- Updated assembly version to 6.0.0.0.[#2382](https://github.com/dotnet/SqlClient/pull/2382) |
| 63 | +- Code health improvements: [#2366](https://github.com/dotnet/SqlClient/pull/2366), [#2369](https://github.com/dotnet/SqlClient/pull/2369), [#2381](https://github.com/dotnet/SqlClient/pull/2381), [#2390](https://github.com/dotnet/SqlClient/pull/2390), [#2392](https://github.com/dotnet/SqlClient/pull/2392), [#2403](https://github.com/dotnet/SqlClient/pull/2403), [#2410](https://github.com/dotnet/SqlClient/pull/2410), [#2413](https://github.com/dotnet/SqlClient/pull/2413), [#2425](https://github.com/dotnet/SqlClient/pull/2425), [#2428](https://github.com/dotnet/SqlClient/pull/2428), [#2440](https://github.com/dotnet/SqlClient/pull/2440), [#2443](https://github.com/dotnet/SqlClient/pull/2443), [#2450](https://github.com/dotnet/SqlClient/pull/2450), [#2466](https://github.com/dotnet/SqlClient/pull/2466), [#2486](https://github.com/dotnet/SqlClient/pull/2486), [#2521](https://github.com/dotnet/SqlClient/pull/2521), [#2522](https://github.com/dotnet/SqlClient/pull/2522), [#2533](https://github.com/dotnet/SqlClient/pull/2533), [#2552](https://github.com/dotnet/SqlClient/pull/2552), [#2560](https://github.com/dotnet/SqlClient/pull/2560), [#2726](https://github.com/dotnet/SqlClient/pull/2726), [#2751](https://github.com/dotnet/SqlClient/pull/2751), [#2811](https://github.com/dotnet/SqlClient/pull/2811) |
| 64 | + |
| 65 | +##Target Platform Support |
| 66 | + |
| 67 | +- .NET Framework 4.6.2+ (Windows x86, Windows x64) |
| 68 | +- .NET 6.0+ (Windows x86, Windows x64, Windows ARM64, Windows ARM, Linux, macOS) |
| 69 | + |
| 70 | +###Dependencies |
| 71 | + |
| 72 | +####.NET Framework |
| 73 | + |
| 74 | +- Microsoft.Data.SqlClient.SNI 6.0.0-preview1.24226.4 |
| 75 | +- Azure.Identity 1.11.4 |
| 76 | +- Microsoft.Extensions.Caching.Memory 6.0.1 |
| 77 | +- Microsoft.IdentityModel.JsonWebTokens 7.5.0 |
| 78 | +- Microsoft.IdentityModel.Protocols.OpenIdConnect 7.5.0 |
| 79 | +- System.Buffers 4.5.1 |
| 80 | +- System.Text.Encodings.Web 6.0.0 |
| 81 | + |
| 82 | +####.NET 6 |
| 83 | + |
| 84 | +- Microsoft.Data.SqlClient.SNI.runtime 6.0.0-preview1.24226.4 |
| 85 | +- Azure.Identity 1.11.4 |
| 86 | +- Microsoft.Extensions.Caching.Memory 6.0.1 |
| 87 | +- Microsoft.IdentityModel.JsonWebTokens 7.5.0 |
| 88 | +- Microsoft.IdentityModel.Protocols.OpenIdConnect 7.5.0 |
| 89 | +- Microsoft.SqlServer.Server 1.0.0 |
| 90 | +- System.Configuration.ConfigurationManager 6.0.1 |
| 91 | + |
| 92 | +####.NET 8 |
| 93 | + |
| 94 | +- Microsoft.Data.SqlClient.SNI.runtime 6.0.0-preview1.24226.4 |
| 95 | +- Azure.Identity 1.11.4 |
| 96 | +- Microsoft.Extensions.Caching.Memory 8.0.0 |
| 97 | +- Microsoft.IdentityModel.JsonWebTokens 7.5.0 |
| 98 | +- Microsoft.IdentityModel.Protocols.OpenIdConnect 7.5.0 |
| 99 | +- Microsoft.SqlServer.Server 1.0.0 |
| 100 | +- System.Configuration.ConfigurationManager 8.0.0 |