[net 6.0] [linux] Microsoft.Data.SqlClient is not supported on this platform

[azuriteemporium]

Describe the bug

Deploying a net 6.0 application on Linux trying to connect to a MS SQL server fails with the following exceptions when the 'Portable' runtime is selected during the build/publish step:

rkCore.SqlServer:6.0.0' with options: None
Unhandled exception. System.PlatformNotSupportedException: Microsoft.Data.SqlClient is not supported on this platfo
rm.
   at Microsoft.Data.SqlClient.SqlConnectionStringBuilder..ctor(String connectionString)
   at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerConnection.<>c.<get_IsMultipleActiveResultS
etsEnabled>b__7_0(String cs)
   at System.Collections.Concurrent.ConcurrentDictionary`2.GetOrAdd(TKey key, Func`2 valueFactory) in /builddir/bui
ld/BUILD/dotnet-9e8b04bbff820c93c142f99a507a46b976f5c14c/src/runtime.4822e3c3aa77eb82b2fb33c9321f923cf11ddde6/artif
acts/source-build/self/src/src/libraries/System.Collections.Concurrent/src/System/Collections/Concurrent/Concurrent
Dictionary.cs:line 1161
   at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerConnection.get_IsMultipleActiveResultSetsEn
abled()
   at Microsoft.EntityFrameworkCore.SqlServer.Query.Internal.SqlServerCompiledQueryCacheKeyGenerator.GenerateCacheK
ey(Expression query, Boolean async)
   at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.Execute[TResult](Expression query)
   at Microsoft.EntityFrameworkCore.Query.Internal.EntityQueryProvider.Execute[TResult](Expression expression)
   at Microsoft.EntityFrameworkCore.Query.Internal.EntityQueryable`1.GetEnumerator()
   at Microsoft.EntityFrameworkCore.Internal.InternalDbSet`1.System.Collections.Generic.IEnumerable<TEntity>.GetEnu
merator()
   at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection) in /builddir/build/BUILD/dotnet-9e8b04bbff8
20c93c142f99a507a46b976f5c14c/src/runtime.4822e3c3aa77eb82b2fb33c9321f923cf11ddde6/artifacts/source-build/self/src/
src/libraries/System.Private.CoreLib/src/System/Collections/Generic/List.cs:line 83
   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source) in /builddir/build/BUILD/dotnet-9e8b04bbff820c93
c142f99a507a46b976f5c14c/src/runtime.4822e3c3aa77eb82b2fb33c9321f923cf11ddde6/artifacts/source-build/self/src/src/l
ibraries/System.Linq/src/System/Linq/ToCollection.cs:line 29

Further technical details

Microsoft.Data.SqlClient version: 4.0 and 2.0

Linux x64 OS details:

NAME="AlmaLinux"
VERSION="8.5 (Arctic Sphynx)"
ID="almalinux"
ID_LIKE="rhel centos fedora"
VERSION_ID="8.5"
PLATFORM_ID="platform:el8"
PRETTY_NAME="AlmaLinux 8.5 (Arctic Sphynx)"
ANSI_COLOR="0;34"
CPE_NAME="cpe:/o:almalinux:almalinux:8::baseos"
HOME_URL="https://almalinux.org/"
DOCUMENTATION_URL="https://wiki.almalinux.org/"
BUG_REPORT_URL="https://bugs.almalinux.org/"

ALMALINUX_MANTISBT_PROJECT="AlmaLinux-8"
ALMALINUX_MANTISBT_PROJECT_VERSION="8.5"

[azuriteemporium]

A workaround seems to target the host platform directly, Linux x64 in this case

[JRahnama]

@azuriteemporium thanks for bringing this up. Two questions:

1. have you tested with net5?
2. have you tried to address/change runtimes from Unix folder of the nuget

[Wraith2]

The nuget contains implementations in the /runtimes folder for win and unix, if you restore using portable there is no way to pick up a real runtime specific implementation so you'll get the smaller assembly stub which just throws pnse exceptions for everything.

In theory the unix (fully managed) implementation could be made the default so it would always work but there are perf and behaviour differences that people would then complain about.

[J05HM0N5TER]

I had/have this problem as well (with me, it was with local development on Linux). I managed to work around it by copying everything in ~/.nuget/packages/system.data.sqlclient/4.8.3/runtimes/unix/lib/netcoreapp2.1/ into [Project path]/bin/Debug/net6.0/bin/. My system is running Manjaro x64.

EDIT: This only helped get a bit further in the process (a couple of lines of code, it let me sign in with managed identities), but then I encountered the same error. This is now completely stopping me developing, trying other versions of the package didn't do anything (I couldn't go back far because I had a dependency on something fairly new).

[J05HM0N5TER]

I just tried running in an Ubuntu docker container, and it worked. I don't know if this is to do with Ubuntu or a fresh OS (docker container) but some part of that fixed it.

[MolallaComm]

I ran into this on alma also - adding the -r linux-x64 flag to my dotnet run or dotnet build fixed it as @azuriteemporium pointed out. The funny thing is that on ubuntu 20.04 - dotnet run without the -r flag works fine.

[Cantaria]

I've 2 computers which i use to develop.

Computer A is a freshly installed Linux Mint Vanessa and installed .Net 6.0.8 (runtime + SDK) with installed Entity-Framework Tools 6.0.8:
If i run dotnet ef database update i'm getting the System.PlatformNotSupportedException.
Adding Migration worked fine.

Computer B is an updated system from Ubuntu 20.04 to Ubuntu 22.04. It also has updated Net 5.0.11 to Net 6.0.8 (runtime+sdk) with installed Entity-Framework Tools 5.0.11
If i run dotnet ef database update, everything works.
Adding Migration worked fine.

If i downgrade the EF-Tool an computer A to the same version as Computer B: still does not work

Do i need an additional NuGet package for the "dotnet ef"-commands?

[ErikEJ]

@Cantaria what SDK versions on computer A?

[Cantaria]

Hi @ErikEJ

That are the ouputs from bash:

clemens@MasterPC:~$ dotnet --list-sdks
6.0.108 [/usr/lib/dotnet/dotnet6-6.0.108/sdk]
clemens@MasterPC:~$ dotnet --list-runtimes
Microsoft.AspNetCore.App 6.0.8 [/usr/lib/dotnet/dotnet6-6.0.108/shared/Microsoft.AspNetCore.App]
Microsoft.NETCore.App 6.0.8 [/usr/lib/dotnet/dotnet6-6.0.108/shared/Microsoft.NETCore.App]

[JRahnama]

@Cantaria I think Microsoft.EntityFrameworkCore.Design is needed as well.

[ErikEJ]

@Cantaria I think you need a newer SDK

[Cantaria]

@ErikEJ this is the newest version i'm getting from the ubuntu repositories. :(
After the Update to 22.04 i've had to disable to Microsoft-repositories due conflicts.

[ErikEJ]

@Cantaria is this related? dotnet/core#7699

[Cantaria]

Hi @ErikEJ ,

i have now installed the dotnet from the PMC like in the link. It seems that everything has worked (now i have version 6.0.400)

I can build and run my App, but i can't run dotnet ef database update

I've installed dotnet ef with
dotnet tool install --global dotnet-ef

If i run it, i get the following output:

clemens@MasterPC:~/Dev/Projects/Riddle/X3Code.Riddle./X3Code.Riddle.Database$ dotnet ef database update --startup-project ../X3Code.Riddle.WebService 
You must install .NET to run this application.

App: /home/clemens/.dotnet/tools/dotnet-ef
Architecture: x64
App host version: 6.0.8
.NET location: Not found

Learn about runtime installation:
https://aka.ms/dotnet/app-launch-failed

Download the .NET runtime:
https://aka.ms/dotnet-core-applaunch?missing_runtime=true&arch=x64&rid=linuxmint.21-x64&apphost_version=6.0.8

Maybe if it's help, the output from dotnet --info:

clemens@MasterPC:~$ dotnet --info
.NET SDK (reflecting any global.json):
 Version:   6.0.400
 Commit:    7771abd614

Laufzeitumgebung:
 OS Name:     linuxmint
 OS Version:  21
 OS Platform: Linux
 RID:         linux-x64
 Base Path:   /usr/share/dotnet/sdk/6.0.400/

global.json file:
  Not found

Host:
  Version:      6.0.8
  Architecture: x64
  Commit:       55fb7ef977

.NET SDKs installed:
  6.0.400 [/usr/share/dotnet/sdk]

.NET runtimes installed:
  Microsoft.AspNetCore.App 6.0.8 [/usr/share/dotnet/shared/Microsoft.AspNetCore.App]
  Microsoft.NETCore.App 6.0.8 [/usr/share/dotnet/shared/Microsoft.NETCore.App]

Download .NET:
  https://aka.ms/dotnet-download

Learn about .NET Runtimes and SDKs:
  https://aka.ms/dotnet/runtimes-sdk-info

[ErikEJ]

@Cantaria Please open a new issue in the EF Core repo, this seems very off topic here.