} // end Mirgate()
private static void PrintMigrationStatus(DA.WWWingsContext ctx)
{
CUI.H2("Migration Status");
try
{
Dictionary <string, string> migrationsStatus = new Dictionary <string, string>();
var migrations = ctx.Database.GetMigrationStatus();
foreach (var item in migrations)
{
if (item.Value)
{
CUI.PrintGreen(item.Key + ":" + " Applied");
}
else
{
CUI.PrintRed(item.Key + ":" + " TODO");
}
}
}
catch (Exception)
{
CUI.PrintError("Database not available!");
}
}
private void C_Orte_TextUpdate(object sender, EventArgs e)
{
// Das ist NICHT richtig: ctx.FlightSet.Local.Clear();
ctx = new DA.WWWingsContext();
string ort = this.C_Orte.Text;
var set = ctx.FlightSet.Where(f => f.Departure.ToLower().Contains(ort.ToLower())).ToList();
this.Text = set.Count + " Flüge from " + ort;
this.flugBindingSource.DataSource = ctx.FlightSet.Local.ToBindingList();
}
public int Migrate()
{
CUI.H1("Migrate Database...");
try
{
if (!(String.IsNullOrEmpty(this.ConnectionString)))
{
DA.WWWingsContext.ConnectionString = this.ConnectionString;
}
CUI.Print("Connection String=" + DA.WWWingsContext.ConnectionString);
using (var ctx = new DA.WWWingsContext())
{
IEnumerable <string> mset = ctx.Database.GetMigrations();
CUI.H2("Available Migrations: " + mset.Count());
foreach (var m in mset)
{
Console.WriteLine(m);
}
IEnumerable <string> appliedMigrations = ctx.Database.GetAppliedMigrations();
CUI.H2("Existing Migrations in this database: " + appliedMigrations.Count());
foreach (var m in appliedMigrations)
{
Console.WriteLine(m);
}
//var migrator = ctx.GetService<IMigrator>();
//var script = migrator.GenerateScript("v5", "v8", true);
var migrator = ctx.GetService <IMigrator>();
migrator.Migrate("v8");
migrator.MigrateAsync("v8");
PrintMigrationStatus(ctx);
CUI.H2("Starting Migration...");
//ctx.Database.EnsureCreated(); // DO NOT USE THIS METHOD BEFORE!
ctx.Database.Migrate();
CUI.PrintGreen("Migrations done!");
PrintMigrationStatus(ctx);
return(0);
} // end using
}
catch (Exception ex)
{
CUI.PrintError("Migration Error: " + ex.ToString());
System.Environment.Exit(2);
return(2);
}
} // end Mirgate()
