Any 2023 tricks for running on Windows? about fsharp.data.sqlclient HOT 3 OPEN

@cr3wdayt5p thanks for the extensive and detailed bug report. I'll try to investigate it, you can also check if the issue is the same with the dotnet framework, if you have ability to target it.

In the meantime, since you mention it works fine on Linux and macOs and fails on Windows, I'd suggest the issue be reported to the dotnet sdk itself, either it is an issue in the dotnet sdk, or in the System.Data.SqlClient package, which I think is also part of the SDK.

I don't think there is anything platform specific in this repository that would cause the issue specifically.

It could also be that the F# compiler on windows is doing something different in context of compile time loading of dependencies that the type provider brings in the compilation.

from fsharp.data.sqlclient.

I don't have the ability to target dotnet framework. But I did try both net6.0 and net7.0 – but the result was the same.

My guess is that System.Data.SqlClient somehow runs in a different context when used by the type provider vs. when used directly. So I am hoping that somebody has experienced the same issue and found a solution, e.g. including some missing SNI dll or something.

But the first step to really investigate this issue would be to make the type provider output the full content of the exception thrown by System.Data.SqlClient.TdsParser.

from fsharp.data.sqlclient.

@cr3wdayt5p thanks for additional details.

You may bring your own feedback on those issues, or try to open specific one, asking about native dependency loading in context of type providers on dotnet/fsharp.

Also, please consider if dotnet/fsharp#4956 and dotnet/fsharp#10323 have some relevancy, you could expand your perspective on the discussions there.

I'm also facing issues related to this and other type providers in Rider since recent dotnet sdk (such as loading of System.Runtime.Caching, etc.), I think they all pertains to breaking changes in dotnet SDK.

If there is a known way of fixing it in this particular type provider disregarding of the SDK, I'd be glad to make a new release with such fix.

from fsharp.data.sqlclient.