How to enable migration in SQLite using EF

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.

Solution 1

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

Solution 2

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.

Comments

[ErikEJ]

Or use the free SQLite Toolbox extension directly in Visual Studio

[habib]

But brother I have to create database tables from my models. How can I do this?

[Sampath]

Yes,above free driver doesn't support migration.So you have to create it manually by using one of the above tool.No other option.

[habib]

Its possible by using MicrosoftEntityFramework Core that support sqlite. It works just like entityframework.