System.Data.SQLite

View Ticket
Login
2014-11-04
07:20 Ticket [6b5ef4ff7a] Add support for Entity Framework 6 Code First Migrations status still Deferred with 3 other changes artifact: 080a420fb0 user: anonymous
2014-10-31
09:41 Ticket [6b5ef4ff7a]: 3 changes artifact: 5c2bb05a9b user: anonymous
2014-10-21
01:31 Ticket [6b5ef4ff7a]: 3 changes artifact: bb33c7a3c9 user: mistachkin
2014-10-20
19:31 Deferred ticket [6b5ef4ff7a]. artifact: 485f1a4e3e user: mistachkin
2014-10-18
13:09 Ticket [6b5ef4ff7a]: 6 changes artifact: ddc74dc915 user: anonymous
2014-09-05
16:03 Ticket [6b5ef4ff7a]: 4 changes artifact: 3d06cf8801 user: mistachkin
16:02 Ticket [6b5ef4ff7a]: 6 changes artifact: 2a1b3538fe user: mistachkin
05:43 New ticket [6b5ef4ff7a]. artifact: 46060a0e69 user: anonymous

Ticket Hash: 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
10.48 years ago
Created: 2014-09-05 05:43:44
10.65 years ago
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