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. |