System.Data.SQLite
View Ticket
Not logged in
Ticket UUID: 6b5ef4ff7a461c379f6bef7462153e8eb06a6a0f
Title: Add support for Entity Framework 6 Code First Migrations
Status: Deferred Type: Feature_Request
Severity: Important Priority: Medium
Subsystem: LINQ Resolution: Open
Last Modified: 2014-11-04 07:20:40
Version Found In: 1.0.93.0
User Comments:
anonymous added on 2014-09-05 05:43:44:
Add support for Entity Framework 6 Code First Migrations

mistachkin added on 2014-09-05 16:03:31:
Is there some interface that needs to be implemented to make this work (i.e.
what is currently lacking)?

anonymous added on 2014-10-18 13:09:37:
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.

mistachkin added on 2014-10-21 01:31:53:
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).

anonymous added on 2014-10-31 09:41:12:
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

anonymous added on 2014-11-04 07:20:40:
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