augustoproiete
commented
3 years ago Possibly related from Microsoft's SQL Client FAQ (emphasis mine):
Why do I get a PlatformNotSupported exception when my application hits a SqlClient method? The Microsoft.Data.SqlClient NuGet package includes a number of DLLs supporting different .NET targets and different runtime platforms. If you are getting a PlatformNotSupported Exception when you don't think you should be, it ultimately means your application is not loading the appropriate DLL. There could be a number of reasons for this. The NuGet package structure and infrastructure around referencing and loading referenced NuGet packages includes logic that allows a package to contain multiple DLLs which implement support for different .NET and platform targets. Meaning a different DLL for .NET Framework, .NET Core, .NET Standard, Windows, Linux, etc. The NuGet infrastructure will automatically reference and load the appropriate DLL based on your application's needs.
If your application loads a DLL from a NuGet package directly, it bypasses all this logic and probably loads the incorrect DLL. The DLL in the NuGet package under lib/netstandard2.0/Microsoft.Data.SqlClient.dll is basically the fallback DLL for any unsupported target and simply throws the PlatformNotSupported exception for any call. This is a nicer exception than what you would otherwise get when running on a platform that does not have a DLL built for it. Ultimately, you want to use the NuGet package reference infrastructure or you would have to implement all this target framework and platform support logic yourself when determining which DLL to load.
Additionally, the NuGet package contains all the dependency information for the SqlClient library and facilitates the downloading and referencing of dependencies. If you reference and load an individual DLL manually, it is up to you to ensure all dependencies are also available to the SqlClient library.
Needs further investigation, but the above suggests that Cake might be loading the netstandard2.0 assembly rather than the assembly for the corresponding TFM of the Cake runner e.g. netcoreapp3.1
AdaskoTheBeAsT
rodrigoramos
devlead
Sebazzz
Prerequisites
Cake runner
Cake .NET Tool, Cake runner for .NET Core
Cake version
1.2.0
Operating system
Linux
Operating system architecture
64-Bit
CI Server
No response
What are you seeing?
It's not possible to use Microsoft.Data.SqlClient nuget on cake script. Some addins like Cake.SqlServer and Cake.SqlTools cannot be used.
The following error is showed:
What is expected?
I expect to be able to use this package. Like a I said before, it's referenced by addins which handles databases.
In the same machine/environment, we create a new console application, adding the same package as reference and running this application, it'll work as expected.
Steps to Reproduce
Create a build.cake script with the following contents:
Output log