"System.Data.SqlClient is not supported on this platform" on .NET 6 on RHEL and AlmaLinux, works fine on .NET 5 and under Ubuntu

[alex-jitbit]

Describe the bug

We have a cross platform ASP.NET 6.0 app (published as "portable") that runs fine on Windows, Ubuntu etc, but throws the above error on RHEL and AlmaLinux. Reverting to the older version of the app that targets .NET 5 works fine.

Both versions System.Data.SqlClient 4.8.3 and Microsoft.Data.SqlClient throw this error. My connection-string uses an SQL user with a password, not using Kerberos or windows-integrated authentication.

System.PlatformNotSupportedException: Microsoft.Data.SqlClient is not supported on this platform.
at Microsoft.Data.SqlClient.SqlConnection..ctor(String connectionString)

To reproduce

Create a .NET Core 6.0 app that references SqlClient, publish, deploy to RHEL, run with dotnet MyProject.dll

THIS IS TRIVIALLY REPRODUCABLE on AlmaLinux 8 under WSL2 (available in MS Store). But it works fine under Ubuntu under WSL2.

Install WSL2, install Almalinux 8 from MS Store, run sudo yum install dotnet-sdk-6.0 -y to install dotnet, then run the app using dotnet MyProject.dll

Almalinux dotnet--info output:

.NET SDK (reflecting any global.json):
 Version:   6.0.105
 Commit:    679e7e16e1

Runtime Environment:
 OS Name:     almalinux
 OS Version:  8.5
 OS Platform: Linux
 RID:         rhel.8-x64
 Base Path:   /usr/lib64/dotnet/sdk/6.0.105/

Host (useful for support):
  Version: 6.0.5
  Commit:  70ae3df4a6

.NET SDKs installed:
  6.0.105 [/usr/lib64/dotnet/sdk]

.NET runtimes installed:
  Microsoft.AspNetCore.App 6.0.5 [/usr/lib64/dotnet/shared/Microsoft.AspNetCore.App]
  Microsoft.NETCore.App 6.0.5 [/usr/lib64/dotnet/shared/Microsoft.NETCore.App]

To install additional .NET runtimes or SDKs:
  https://aka.ms/dotnet-download```

[JRahnama]

@alex-jitbit this seems like duplication of #1390 and some other similar issues when using Kerberos authentication on Unix. Please check that issue thread.

[alex-jitbit]

@JRahnama nope, not using Kerberos auth, simply MS SQL user with password. This is a library/targeting/dependency issue, strictly

[ErikEJ]

What is your Publish command?

[alex-jitbit]

@ErikEJ it's dotnet publish ..\path\to\MyProject.csproj --configuration Release -o path\to\OutputFolder

Once again, the same build works fine on Ubuntu, Windows Server etc. But some linux distros throw this error.

[Wraith2]

The System version of the library can only be updated as part of the runtime. The last runtime it shipped with was netcore 3.1. So regardless of the bug status I don't think it's going to get fixed in the System version.

Can you try with the Microsoft version of the library from this repo and see if it reproduces?

[JRahnama]

@alex-jitbit I will look into this, but as a wild guess could this be related/similar to #1249 and #81?

[alex-jitbit]

@JRahnama nope, I'm not using docker, it's a standalone SQL Server installation, accessed over network. And a standalone aspnetcore app (also - not in docker)

[alex-jitbit]

@Wraith2 just tried with Microsoft.Data.SqlClient

! SAME ERROR !

System.PlatformNotSupportedException: Microsoft.Data.SqlClient is not supported on this platform.
: at Microsoft.Data.SqlClient.SqlConnection..ctor(String connectionString)

[alex-jitbit]

The exception is trivially reproducible on WSL2: just install AlmaLinux 8 from MS Store and run any NET6 app. SqlConnection constructor throws this error.

NET5 works fine. NET6 also works fine, but only on Ubuntu, not RHEL or its forks

[ErikEJ]

Have you tried using the latest SDK?

[alex-jitbit]

@ErikEJ no, but I have tried installing dotnet as described in MS docs

Have you tried the steps to repro I provided?

[AraHaan]

I would try it with the latest .NET 6 servicing release first.