System.Data.SqlClient Not Supported

[wcunnien]

Using the latest SEQ install version, 2022.1, I have written a very simple Seq App that writes to a SQL Server database. I have tried several different .NET versions (4.x Framework, Standard 2.1, and .NET 6.0). No matter what I do, after installing the Seq App in to Seq, the app errors with:

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

I used https://github.com/johnmiller86/seq-apps-sqlserverexporter/tree/master/Seq.Apps.SQLServerExporter as an example.

Should I downgrade to 2021.4?

Thanks.

[nblumhardt]

Hi Bill, thanks for your message.

The problem is due to System.Data.SqlClient requiring platform-specific native libraries; i.e. it needs different binaries deployed for Windows, Linux, and so-on. Seq's app system assumes for the most part that everything is portable, though you can target net5.0-windows if you're targeting Windows hosts only.

If net5.0-windows isn't an option, I'd first consider porting to Microsoft.Data.SqlClient, instead of System.Data.SqlClient. Their APIs are very similar so the code should be reasonably straightforward to port from one to the other, but Microsoft.Data.SqlClient is later and has better .NET Core support. net6.0 will be the best framework to target in that case.

The Microsoft.Data.SqlClient NUPKG (just a zip file) has runtimes/unix/ and runtimes/win/ folders, with (I think) netcoreapp3.1 folders under each of them supplying native libraries for each platform. If Microsoft.Data.SqlClient doesn't work as-is, adding <Include .. tags to your CSPROJ pulling in the correct native libraries should sort it out.

I didn't spot a build script in the repo you linked; there's a Build.ps1 and appveyor.yaml in https://github.com/datalust/seq-app-htmlemail which you might be able to adapt, if you need an example of how the build/pack process should work.

Let me know if this helps!

Nick

[nblumhardt]

Received, thank you 👍

[billcunnien]

Hey Nick, were you able to find out what I did wrong? Thanks!

[nblumhardt]

Hi Bill, sorry about the slow turnaround; I'm still working through it, I'll send an update shortly.

[nblumhardt]

Success! I needed to copy both the correct Microsoft.Data.SqlClient, and Microsoft.Data.SqlClient.SNI DLLs into the package (before doing that, I hit the same Access Violation exception you reported).

I'm now trying to get the CSPROJ to package this stuff up properly at build time, I'll send my results back to you by email.

[billcunnien]

Thanks for your help, Nick! That inclusion of the SNI assembly was key.

[billcunnien]

Include the SNI assembly in the package file

[nblumhardt]

Also relevant: datalust/seqcli#252