search

raisedapp / Hangfire.Storage.SQLite

An Alternative SQLite Storage for Hangfire
https://www.nuget.org/packages/Hangfire.Storage.SQLite
MIT License
155 stars 31 forks source link

Incompatible with Microsoft.EntityFrameworkCore.Sqlite nuget #30

Closed Anil86 closed 3 years ago

Anil86 commented 4 years ago

I'm using SQLite as the database for my app. So I installed Microsoft.EntityFrameworkCore.Sqlite version 3.1.7 nuget & ran the project (Blazor Server App) which caused following exception:

System.MissingMethodException: Method not found: 'System.String SQLitePCL.raw.sqlite3_column_name(SQLitePCL.sqlite3_stmt, Int32)'.

Without Microsoft.EntityFrameworkCore.Sqlite, Hangfire works perfectly.

felixclase commented 4 years ago

I'll be checking

AutumnEvans418 commented 4 years ago

I also have this issue with Microsoft.EntityFrameworkcore.sqlite version 3.1.3.

AutumnEvans418 commented 4 years ago

I have discovered the solution. Adding <PackageReference Include="sqlite-net-pcl" Version="1.7.335" /> to my csproj solved the issue. There was just a version mismatch

Yaevh commented 4 years ago

Same problem, same resolution here. The bug would be easily fixed by updating sqlite-net-pcl to 1.7.335 in the library (<PackageReference Include="sqlite-net-pcl" Version="1.7.335" />), but it would require dumping .NET Framework 4.5 version, since 1.7.335 doesn't support 4.5 :/

lulzzz commented 3 years ago

same issue. please update.

felixclase commented 3 years ago

Same problem, same resolution here. The bug would be easily fixed by updating sqlite-net-pcl to 1.7.335 in the library (<PackageReference Include="sqlite-net-pcl" Version="1.7.335" />), but it would require dumping .NET Framework 4.5 version, since 1.7.335 doesn't support 4.5 :/

image

So as not to break compatibility with those who are still using .net 4.5