Entity Framework - Check for pending migrations

Question

In our production environment, we have an automated deploy script that takes down our site, runs migrations, and then brings it back online. We'd like to avoid taking the site down by just switching to the new code when there aren't any migrations that need to be run.

Does entity framework have a command like "Update-Database" that would allow us to check if there are migrations to run?

Wiktor Zychla Wiktor Zychla · Accepted Answer · 2013-07-30T07:07:51

The DbMigrator class has the GetPendingMigrations method which sounds like the exact one you look for. It should be something like

YourMigrationsConfiguration cfg = new YourMigrationsConfiguration(); 
cfg.TargetDatabase = 
   new DbConnectionInfo( 
      theConnectionString, 
      "provider" );

DbMigrator dbMigrator = new DbMigrator( cfg );
if ( dbMigrator.GetPendingMigrations().Any() )
{
   // there are pending migrations
   // do whatever you want, for example
   dbMigrator.Update(); 
}

Entity Framework - Check for pending migrations

2 Answers