System.Data.SqlClient throwing System.PlatformNotSupportedException when used in Azure Functions (v2)

[TonyHenrique]

I have a code running on Azure Functions (v2) and System.Data.SqlClient version 4.5.1
When I upgrade System.Data.SqlClient to 4.6.0, I get this error:

System.Data.SqlClient is not supported on this platform.

2018-12-18T19:00:02.737 [Information] Executing 'LiquidaTitulo' (Reason='This function was programmatically called via the host APIs.', Id=241ebfdf-39d7-4299-8fe7-2bd9a6e08244)
2018-12-18T19:00:10.228 [Error] Executed 'LiquidaTitulo' (Failed, Id=241ebfdf-39d7-4299-8fe7-2bd9a6e08244)
System.Data.SqlClient is not supported on this platform.

Then I downgraded System.Data.SqlClient to version 4.5.1 and it is working now.

[karelz]

@TonyHenrique are you running on .NET Framework or .NET Core?
cc @David-Engel @afsanehr @keeratsingh

[TonyHenrique]

.Net Standard 2.0

[karelz]

That is not what you run on, that is what you target. Standard is a spec, not implementation.

[TonyHenrique]

Azure Functions (v2) runtime is based on .Net Core and .Net Standard 2.0

[AfsanehR-zz]

@TonyHenrique Could you please provide the output of dotnet --info and possibly a simple repro code?

[TonyHenrique]

SDK do .NET Core (refletindo qualquer global.json):
 Version:   2.1.600-preview-009426
 Commit:    48b4f2105d

Ambiente de tempo de execução:
 OS Name:     Windows
 OS Version:  10.0.17763
 OS Platform: Windows
 RID:         win10-x64
 Base Path:   C:\Program Files\dotnet\sdk\2.1.600-preview-009426\

Host (useful for support):
  Version: 2.1.6
  Commit:  3f4f8eebd8

.NET Core SDKs installed:
  2.1.200-preview-007517 [C:\Program Files\dotnet\sdk]
  2.1.200-preview-007576 [C:\Program Files\dotnet\sdk]
  2.1.202 [C:\Program Files\dotnet\sdk]
  2.1.500 [C:\Program Files\dotnet\sdk]
  2.1.502 [C:\Program Files\dotnet\sdk]
  2.1.600-preview-009426 [C:\Program Files\dotnet\sdk]

.NET Core runtimes installed:
  Microsoft.AspNetCore.All 2.1.1 [C:\Program Files\dotnet\shared\Microsoft.AspNetCore.All]
  Microsoft.AspNetCore.All 2.1.6 [C:\Program Files\dotnet\shared\Microsoft.AspNetCore.All]
  Microsoft.AspNetCore.App 2.1.1 [C:\Program Files\dotnet\shared\Microsoft.AspNetCore.App]
  Microsoft.AspNetCore.App 2.1.6 [C:\Program Files\dotnet\shared\Microsoft.AspNetCore.App]
  Microsoft.NETCore.App 2.0.9 [C:\Program Files\dotnet\shared\Microsoft.NETCore.App]
  Microsoft.NETCore.App 2.1.6 [C:\Program Files\dotnet\shared\Microsoft.NETCore.App]

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

[TonyHenrique]

The code is about this:

    var config = new ConfigurationBuilder()
                .SetBasePath(context.FunctionAppDirectory)
                .AddJsonFile("local.settings.json", optional: true, reloadOnChange: true)
                .AddEnvironmentVariables()
                .Build();

    var cnnString = config.GetConnectionString("MyConn");

    using (var connection = new SqlConnection(cnnString))
    {
        //log.Info("UPDATE dbo.Titulo SET DataDaBaixa=@DataDaBaixa WHERE Boleto_Code=@Boleto_Code;");

        connection.Open();
        connection.Execute("UPDATE dbo.Titulo SET DataDaBaixa=@DataDaBaixa WHERE Boleto_Code=@Boleto_Code;",
            new
            {
                Boleto_Code = Boleto_Code,
                DataDaBaixa = DataLiquidacao
            });

        return new OkObjectResult("OK");
    }

[rmbrunet]

Hello all,

exactly the same issue here running in NetCore 2.2. Version 4.6.0 throws not supported... exception. Going back to 4.5.1 works fine.

[AfsanehR-zz]

@rmbrunet @TonyHenrique I was able to reproduce the issue. But this does not seem to be related to SqlClient as I was able to run a sample application using v4.6.0 by directly adding the System.Data.SqlClient.dll in the csproj from my local machine.
Related issue here.

[AfsanehR-zz]

Duplicate of Azure/azure-functions-host#3903