Self HostedFunctions

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

Mar 25, 2024, 11:00

View on Discord

Votes

Replies

Participants

Unknown

Messages

KuromoryOriginal post

Rank 2: Process

Mar 25, 2024, 09:55

I use the the SqlClient in my c# function but I get this exception... What do I need to do so it works?

Summary

Developers are encountering a 'System.PlatformNotSupportedException' error when trying to use System.Data.SqlClient on a platform where it's not supported. They've tried switching to Microsoft.Data.SqlClient in their csproj file, but the issue persists. They are trying to sync data between an Appwrite database and an MSSQL database. Solution: Since System.Data.SqlClient is not supported on the current platform, developers should use Microsoft.Data.SqlClient instead for compatibility.

Mar 25, 2024, 10:02

Could you give more context on what you're trying to achieve?

Kuromory

Rank 2: Process

Mar 25, 2024, 10:04

I have a trigger so when create/update/delete is executed on the appwrite database I want to "sync" this to an other MSSQL database

Kuromory

Rank 2: Process

Mar 25, 2024, 10:05

I also used the cli to create the function so the deloyment works just fine 🙂

Kuromory

Rank 2: Process

Mar 25, 2024, 10:28

I also changed to the package Microsoft.Data.SqlClient but it didn't help...
here is the csproj File that I use:

Markup

<Project Sdk="Microsoft.NET.Sdk.Web">
  <PropertyGroup>
    <TargetFramework>net6.0</TargetFramework>
    <OutputType>Exe</OutputType>
    <!-- <RuntimeIdentifier>ubuntu.22.04-x64</RuntimeIdentifier> -->
    <Nullable>enable</Nullable>
    <ImplicitUsings>enable</ImplicitUsings>
  </PropertyGroup>
  <ItemGroup>
    <PackageReference Include="Appwrite" Version="0.8.0" />
    <PackageReference Include="Microsoft.Data.SqlClient" Version="5.2.0" />
  </ItemGroup>
</Project>

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

Need support?_