search

fsprojects / SQLProvider

A general F# SQL database erasing type provider, supporting LINQ queries, schema exploration, individuals, CRUD operations and much more besides.
https://fsprojects.github.io/SQLProvider
Other
579 stars 146 forks source link

dotnet 8.0.100-preview.6.23330.14 error. #800

Open WillEhrendreich opened 1 year ago

WillEhrendreich commented 1 year ago

Describe the bug when I try to build with dotnet 8.0.100-preview.6.23330.14 sdk i get this error:

The type provider 'FSharp.Data.Sql.SqlTypeProvider' reported an error: Un able to load one or more of the requested types.Could not load type 'SqlGuidCaster' from assembly 'Microsoft.Data.SqlClient, Version=5.0.0.0, Culture=neutral, PublicKeyTo ken=23ec7fc2d6eaa4a5' because it contains an object field at offset 0 that is incorrectly aligned or overlapped by a non-object field.Details: Could not load type 'SqlGu idCaster' from assembly 'Microsoft.Data.SqlClient, Version=5.0.0.0, Culture=neutral, PublicKeyToken=23ec7fc2d6eaa4a5' because it contains an object field at offset 0 that is incorrectly aligned or overlapped by a non-object field.Current execution platform: .NETCoreApp,Version=v6.0

To Reproduce Steps to reproduce the behavior: have a dotnet 8 sdk project. use mssql try to build

Expected behavior i expect it to build

Screenshots If applicable, add screenshots to help explain your problem.

Desktop (please complete the following information):

Additional context None

Thorium commented 1 year ago

Sounds pretty much underlying driver problem.

Could be related: https://github.com/dotnet/SqlClient/issues/1930

Thorium commented 1 year ago

Do you still have the issue?

I'm running on 8.0.100-rc.1.23463.5 and Microsoft.Data.SqlClient 5.1.1 and all works well.

WillEhrendreich commented 1 year ago

I'll check. :)

WillEhrendreich commented 1 year ago

Still have problems.. [] let ResolutionPath = __SOURCE_DIRECTORY__ + """\SqlProvider"""

type sql = SqlDataProvider

when i try to run dotnet build, i get this:

FS3033: The type provider 'FSharp.Data.Sql.SqlTypeProvider' reported an error: Unable to load one or more of the requested types.Could not load type 'SqlGuidCaster' from assembly 'Microsoft.Data.SqlClient, Version=5.0.0.0, Culture=neutral, PublicKeyToken=23ec7fc2d6eaa4a5' because it contains an object field at offset 0 that is incorrectly aligned or overlapped by a non-object field.Details: Could not load type 'SqlGuidCaster' from assembly 'Microsoft.Data.SqlClient, Version=5.0.0.0, Culture=neutral, PublicKeyToken=23ec7fc2d6eaa4a5' because it contains an object field at offset 0 that is incorrectly aligned or overlapped by a non-object field.Current execution platform: .NETCoreApp,Version=v6.0

FS3033: The type provider 'FSharp.Data.Sql.SqlTypeProvider' reported an error: Unable to load one or more of the requested types.Could not load type 'SqlGuidCaster' from assembly 'Microsoft.Data.SqlClient, Version=5.0.0.0, Culture=neutral, PublicKeyToken=23ec7fc2d6eaa4a5' because it contains an object field at offset 0 that is incorrectly aligned or overlapped by a non-object field.Details: Could not load type 'SqlGuidCaster' from assembly 'Microsoft.Data.SqlClient, Version=5.0.0.0, Culture=neutral, PublicKeyToken=23ec7fc2d6eaa4a5' because it contains an object field at offset 0 that is incorrectly aligned or overlapped by a non-object field.Current execution platform: .NETCoreApp,Version=v6.0

interestingly, no problems are showing in Neovim. no diagnostics. It's apparently fine there..

In summary... (╯°□°）╯︵ ┻━┻

WillEhrendreich commented 1 year ago

and switching back to dotnet 7.0.401 has no problems with dotnet build.

famda commented 1 year ago

I'm also having this issue. How can I bypass this issue?

Thorium commented 1 year ago

Oh, I was using the MSSQLSERVER_SSDT

Thorium commented 1 year ago

hi, can you try with 1.3.19 please, there should be a fix now.

WillEhrendreich commented 1 year ago

I'll have to try that, next week. thanks for working on it!

ronwarner commented 1 year ago

hi, can you try with 1.3.16 please, there should be a fix now.

What does this version apply to... a package, an SDK? I'm using the following and still have this issue:

SDK 8.0.100-rc.2.23502.2 Microsoft.Data.SqlClient 5.1.2 CoreCLR Version: 8.0.23.47906 (on Azure App Service) .NET Version: 8.0.0-rc.2.23479.6 (on Azure App Service)

knocte commented 1 year ago

What does this version apply to... a package, an SDK?

I assume he meant the SqlProvider version of the nuget package: https://www.nuget.org/packages/SQLProvider/#versions-body-tab

I'm using the following and still have this issue

You missed specifying SqlProvider version.

Thorium commented 1 year ago

Just use the .Net 8 and the latest version. But more the question is are you using the MSSQL or MSSQL_DYNAMIC or MSSQL_SSDT