System.Data.SQLite

Login
This project makes use of Eagle, provided by Mistachkin Systems.
Eagle: Secure Software Automation
Ticket Hash: 488d0aca46b99ca70ee8bf5657839c29a2d66e19
Title: Is it possible auto update the sqlite schema and update/add the tables and FX and Index?
Status: Deferred Type: Feature_Request
Severity: Important Priority: Medium
Subsystem: LINQ Resolution: Mailing_List
Last Modified: 2015-11-28 15:48:26
Version Found In: 1.0.98.0
User Comments:
anonymous added on 2015-11-14 17:35:38: (text/x-fossil-plain)
It will be very helpful If there is a property can check the databases with current edmx file and compare it, If the database is old or there is some table or FX or Index missing, then Update current sqlite file or add missing table/FX/Index.

Like:

 using (var ctx = new testDBEntities())
{
       if (ctx.Database.CheckIfDatabaseIsOld)
       {
          ctx.Database.UpdateCurrentSqliteFileToNew();
       }
}

mistachkin added on 2015-11-16 05:41:20: (text/x-fossil-plain)
I'm not sure what is being asked here.  Perhaps this question would be a good
candidate for the mailing list?

[http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users]

anonymous added on 2015-11-18 06:48:15: (text/x-fossil-plain)
Sorry, I can't understand what you mean.
I'm asking a feature that can auto update the sqlite file schema by EF proxy class.(or model)

That would be very helpful for update

mistachkin added on 2015-11-19 04:23:37: (text/x-fossil-plain)
I'm not sure what is required to make this work.  Perhaps other people on the mailing list may know and could help enlighten me?

anonymous added on 2015-11-28 02:33:58: (text/x-fossil-plain)
I mean put into this kind of feature to there : https://code.google.com/p/sqlite-net/wiki/AutomaticMigrations

Because after we create model by sqlite db file, there is auto generate proxy class that has model info, Maybe we can update our old database by compare these model class.

anonymous added on 2015-11-28 15:48:26: (text/x-fossil-plain)
I also found code first mode can do it:https://galleryserverpro.com/using-entity-framework-code-first-migrations-to-auto-create-and-auto-update-an-application/


Then how let database first mode also support it? you can control the class which auto generate by EF. then I think you must have some way to do it.