samedi 28 novembre 2015

Is that possible update sqlite database file use entity framework 6 in Database first?

I'm using slite with entity framework 6 Database first mode.

It will be very helpful If there is a way can check the databases file with current edmx file(auto generated proxy model class) 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();
       }
}

Aucun commentaire:

Enregistrer un commentaire