Who Benefits:

• Developers requiring diagnostic information on .NET Framework.

Impact:

• Improved observability and diagnostics for SqlCommand on .NET Framework.

Enable User Agent Extension

What Changed:

• Enabled User Agent Feature Extension. (#3606)

Who Benefits:

• Telemetry and diagnostics consumers.

Impact:

• When the Switch.Microsoft.Data.SqlClient.EnableUserAgent app context switch is enabled, the driver sends more detailed user agent strings. This switch is disabled by default. This change will assist with troubleshooting and quantifying driver usage by version and operating system.

Fixed

• Fixed an issue where extra connection deactivation was occurring. (#3758)

Changed

Other changes

• Performance improvements: (#3732, #3660)

• Codebase merge and cleanup: (#3803, #3781, #3760, #3746, #3743, #3738, #3683, #3676, #3768)

Contributors

We thank the following public contributors. Their efforts toward this project are very much appreciated.

• edwardneal

Target Platform Support

• .NET Framework 4.6.2+ (Windows x86, Windows x64, Windows ARM64)
• .NET 8.0+ (Windows x86, Windows x64, Windows ARM, Windows ARM64, Linux, macOS)

Dependencies

.NET 9.0

• Azure.Core 1.49.0
• Azure.Identity 1.16.0
• Microsoft.Bcl.Cryptography 9.0.9
• Microsoft.Data.SqlClient.SNI.runtime 6.0.2
• Microsoft.Extensions.Caching.Memory 9.0.9
• Microsoft.IdentityModel.JsonWebTokens 8.14.0
• Microsoft.IdentityModel.Protocols.OpenIdConnect 8.14.0
• Microsoft.SqlServer.Server 1.0.0
• System.Configuration.ConfigurationManager 9.0.9
• System.Security.Cryptography.Pkcs 9.0.9

.NET 8.0

• Azure.Core 1.49.0
• Azure.Identity 1.16.0
• Microsoft.Bcl.Cryptography 8.0.0
• Microsoft.Data.SqlClient.SNI.runtime 6.0.2
• Microsoft.Extensions.Caching.Memory 8.0.1
• Microsoft.IdentityModel.JsonWebTokens 8.14.0
• Microsoft.IdentityModel.Protocols.OpenIdConnect 8.14.0
• Microsoft.SqlServer.Server 1.0.0
• System.Configuration.ConfigurationManager 8.0.1
• System.Security.Cryptography.Pkcs 8.0.1

.NET Standard 2.0

• Azure.Core 1.49.0
• Azure.Identity 1.16.0
• Microsoft.Bcl.Cryptography 8.0.0
• Microsoft.Data.SqlClient.SNI.runtime 6.0.2
• Microsoft.Extensions.Caching.Memory 8.0.1
• Microsoft.IdentityModel.JsonWebTokens 8.14.0
• Microsoft.IdentityModel.Protocols.OpenIdConnect 8.14.0
• Microsoft.SqlServer.Server 1.0.0
• System.Configuration.ConfigurationManager 8.0.1
• System.Security.Cryptography.Pkcs 8.0.1
• System.Text.Json 8.0.6
• System.Threading.Channels 8.0.0

.NET Framework 4.6.2

• Azure.Core 1.49.0
• Azure.Identity 1.16.0
• Microsoft.Bcl.Cryptography 8.0.0
• Microsoft.Data.SqlClient.SNI 6.0.2
• Microsoft.Extensions.Caching.Memory 8.0.1
• Microsoft.IdentityModel.JsonWebTokens 8.14.0
• Microsoft.IdentityModel.Protocols.OpenIdConnect 8.14.0
• System.Buffers 4.6.1
• System.Diagnostics.DiagnosticSource 8.0.1
• System.Memory 4.6.3
• System.Runtime.InteropServices.RuntimeInformation 4.3.0
• System.Security.Cryptography.Pkcs 8.0.1
• System.Text.Json 8.0.6
• System.Threading.Channels 8.0.0
• System.ValueTuple 4.6.1