Microsoft.Data.SqlClient updated to 4.0.1

[wtgodbe]

Description

We have updated the Microsoft.Data.SqlClient package to 4.0.1.

Version

7.0-preview2

Previous behavior

The old version was 1.0.19249.1

New behavior

We now use 4.0.1. You can see breaking changes in the 4.0 band here: https://github.com/dotnet/SqlClient/blob/main/release-notes/4.0/4.0.0.md#breaking-changes. Note that Encrypt now equals true by default: https://github.com/dotnet/SqlClient/blob/main/release-notes/4.0/4.0.0.md#encrypt-default-value-set-to-true

Type of breaking change

• Binary incompatible: Existing binaries may encounter a breaking change in behavior, such as failure to load/execute or different run-time behavior.
• Source incompatible: Source code may encounter a breaking change in behavior when targeting the new runtime/component/SDK, such as compile errors or different run-time behavior.

Reason for change

Updating to most recent versions for improvements in the underlying libraries.

Recommended action

We didn't have to react to any no public API changes from this change, but its possible there are breaking changes in the packages themselves.

Affected APIs

Microsoft.Extensions.Caching.SqlServer

[wtgodbe]

Discussion issue here: dotnet/aspnetcore#40273