System.Data.SQLite

Add support for Entity Framework 6 Code First Migrations

Is there some interface that needs to be implemented to make this work (i.e.
what is currently lacking)?

Here is link explaining details of missing features in System.Data.Sqlite in terms of Code First.

http://hintdesk.com/sqlite-with-entity-framework-code-first-and-migration/

Also please look at issues posted by other people trying same thing with failures...
http://stackoverflow.com/questions/22174212/entity-framework-6-with-sqlite-3-code-first-wont-create-tables

I am facing same issue. Please add support of auto generating tables and migrations in versions of db.

This is blocking many users from using code first method. This method saves from keeping two sources, one for creating DB tables and one for DBContext classes.

The links you posted do not mention specifically what is lacking in the
System.Data.SQLite project in order to support 'code first migrations'.

I'm going to try and research this; however, it is unlikely to occur in
the timeframe for 1.0.95.0 (the next release).

Since I need this functionality for a project I am currently working on, I would like to help on this task. Has work already started?

Best regards,
Alin GHERMAN

It seems someone has already went ahead and implemented a rudimentary generator for SQLite to be used in EF7.

The class
 Microsoft.Data.Entity.SQLite.SQLiteMigrationOperationSqlGenerator
can be found here
 https://github.com/aspnet/EntityFramework/blob/dev/src/EntityFramework.SQLite/SQLiteMigrationOperationSqlGenerator.cs

but it does not provide a lot of functionality.
I will test the code and try to add some functionality, but it seems that in order to create a migrator in EF7, it is enough to extend MigrationOperationSqlGenerator. I will check what is needed for EF6 later.

Regards
Alin GHERMAN