Runtime: Windows Compat Pack - unable to find a stable System.Data.SqlClient >= 4.6.1

[joshfree]

Creating issue for multiple customer reported issues:

_User grant [e-mail] sends the following message to the owners of Package 'Microsoft.Windows.Compatibility 2.1.0'._

Every time I try to upgrade my .NET Standard library from v2.0.1 to v.2.1.0 I get the following error and it rolls back to 2.0.1:
NU1103: Unable to find a stable package System.Data.SqlClient with version (>= 4.6.1)
• Found 32 version(s) in nuget.org [ Nearest version: 4.7.0-preview.18571.3 ]
• Found 2 version(s) in Microsoft Visual Studio Offline Packages [ Nearest version: 4.1.0 ] Package restore failed. Rolling back package changes for 'Logger'.
Is this new version dependent on System.Data.SqlClient for some reason? I don't use it in my application, and don't have a dependency on it.

_User arbor [e-mail] sends the following message to the owners of Package 'Microsoft.Windows.Compatibility 2.1.0'._

NuGet package Microsoft.Windows.Compatibility version 2.1.0 released to NuGet has a dependency to System.Data.SqlClient >= 4.6.1 that is not on NuGet.

_User dwn [e-mail] sends the following message to the owners of Package 'Microsoft.Windows.Compatibility 2.1.0'._

2.1.0 breaks installation of this package:
Severity Code Description Project File Line Suppression State Error NU1103 Unable to find a stable package System.Data.SqlClient with version (>= 4.6.1)
• Found 1272 version(s) in https://dotnetfeed.blob.core.windows.net/dotnet-core/index.json [ Nearest version: 4.7.0-alphautf8string.18530.6 ]
• Found 32 version(s) in nuget.org [ Nearest version: 4.7.0-preview.18571.3 ]
• Found 0 version(s) in Microsoft Visual Studio Offline Packages
• Found 0 version(s) in https://dotnetfeed.blob.core.windows.net/aspnet-aspnetcore-tooling/index.json
• Found 0 version(s) in https://dotnetfeed.blob.core.windows.net/aspnet-aspnetcore/index.json
• Found 0 version(s) in https://dotnetfeed.blob.core.windows.net/aspnet-entityframeworkcore/index.json
• Found 0 version(s) in https://dotnetfeed.blob.core.windows.net/aspnet-extensions/index.json
• Found 0 version(s) in https://dotnetfeed.blob.core.windows.net/dotnet-windowsdesktop/index.json
• Found 0 version(s) in secassure dotnetcoretest E:codedotnetcoretestdotnetcoretest.csproj 1

[danmosemsft]

@ericstj

[ericstj]

https://github.com/dotnet/corefx/commit/8681eefb557edbb50bd9e96c785388d836d44331
https://github.com/dotnet/corefx/commit/c82b438c8ed6eaba3dbed009cd484d5bb392237e

@wtgodbe it looks like servicing missed publishing 4.6.1 of SqlClient.

[wtgodbe]

Yes, unfortunately we did :( We discovered this in https://github.com/dotnet/corefx/pull/36060, and will ship that package with 2.2.5. That was the motivation for https://github.com/dotnet/arcade/issues/2419. I mis-timed when the appropriate change was merged into packages.builds, in relation to when the builds were ran.

CC @mmitche

[TravisEz13]

Will Microsoft.Windows.Compatibility be updated to fix this or just publish SqlClient? If it is the second, what is the ETA? I want to make sure we don't miss this change.

[wtgodbe]

We'll be shipping an updated Microsoft.Windows.Compatibility concurrently to the new System.Data.SqlClient with our May servicing release, which should go public early in May.

[ericstj]

In the meantime you should unlist the one with the dangling dependency.

[wtgodbe]

Sounds good, I'll follow up offline with the nuget folks.

[wtgodbe]

I just unlisted the 2.1.0 version of the package from nuget.org.

[divega]

As recently announced in the .NET Blog, focus on new SqlClient features an improvements is moving to the new Microsoft.Data.SqlClient package.

I assume however that this specific issue is really about what is included in Windows Compatibility Pack and not really about System.Data.SqlClient, so I am not going to move it to the new repo.

@danmosemsft any thoughts?

[danmosemsft]

@wtgodbe is this now resolved (since May release)?

[wtgodbe]

Yes, this should be resolved now. Here's the 4.6.1 version of SqlClient, and the 2.1.1 version of the Compatibility package.

[danmosemsft]

thanks @wtgodbe