How may I replace LocalDB/SQLServer with SQLite and resolve dependency package version mismatching?

[jasontaylordev]

How may I replace LocalDB/SQLServer with SQLite and resolve dependency package version mismatching?

[tomfroehle]

I forked the project and made a few changes so it works with Sqlite.

You can have a look at this commit:
tomfroehle@6b243ac

One thing to mind: The migrations that are in the project don't work for Sqlite because they are SQL Server specific. You would have to add custom Sqlite Migrations. My quick fix was to remove the Migrate call with a EnsureCreated. This leads to the database being created but it will never be updated.

[jasontaylordev]

Thanks for your sample solution, @tomfroehle.

Perhaps I should use Sqlite or InMemory as the default? - since both are cross-platform.

Thoughts?

[tomfroehle]

Thanks for your sample solution, @tomfroehle.

Perhaps I should use Sqlite or InMemory as the default? - since both are cross-platform.

Thoughts?

Would be nice if it ran out of the box without any infrastructure. The only thing would be, that you need separate migration steps for Sqlite

[jasontaylordev]

Thanks for raising this issue, I migrated to InMemory as the default (in debug mode) and SQL Server for release. Looked at using Sqlite, but preferred InMemory for ease of use.