How to enable migration in sqlite using ef

c# ef-code-first entity-framework-core sqlite

Question

I have stuck in problem. I am writing a code for windows desktop application and I have to use sqlite as a database. I have successfully installed system.data.sqlite and entity framework from nuget package. I have also created my DbContext class. Now problem is that as soon as I tried to run my code an exception comes whose inner message is

{"SQLite Error 1: 'no such table: TimeSheet'"}.

This means your table TimeSheet does not exist in database. Plz tell me how to create table in sqlite using entity framework or how to enable migrations.

1
8
3/13/2019 5:54:50 PM

Accepted Answer

There are some implementations of migration for SQLite.

https://github.com/bubibubi/db2ef6migrations is based on the new EF6 migration interface but it has some restrictions. You can download it from Nuget searching for System.Data.SQLite.EF6.Migrations

9
10/10/2017 8:52:02 PM

Popular Answer

Unlike MS SQL Server, as default, the free Sqlite driver from system.data.sqlite doesn’t support Migration.So you can’t create a new database from code.You have to manually create it.

For that you can use SQLite Manager add-on for Firefox.

Here is the link : SQLite Manager

Or you can use SQL Server Compact/SQLite Toolbox where @ErikEJ suggested below.



Related Questions





Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow