private static MigrationRunner GetMigrationRunner(StringWriter sw, MigrateDatabaseContext dbItem, Assembly migrationAssembly) { Announcer announcer = new TextWriterWithGoAnnouncer(sw) { ShowSql = true }; var runnerCtx = new RunnerContext(announcer) { ApplicationContext = dbItem }; if (string.IsNullOrWhiteSpace(dbItem.CurrentDatabaseNamespace)) { throw new ArgumentNullException(nameof(dbItem.CurrentDatabaseNamespace), "<DatabaseNamespace> should not null or empty"); } runnerCtx.Namespace = dbItem.CurrentDatabaseNamespace; var options = new ProcessorOptions { PreviewOnly = false, Timeout = dbItem.ConnectionTimeout }; var factory = new FluentMigrator.Runner.Processors.SqlServer.SqlServer2014ProcessorFactory(); using (var processor = factory.Create(dbItem.ConnectionString, announcer, options)) { return(new MigrationRunner(migrationAssembly, runnerCtx, processor)); } }
public void MigrateToLatest() { try { var connectionString = _settingsService.ConnectionString(DatabaseContext.DefaultConnectionString); var announcer = new NullAnnouncer(); var assembly = Assembly.GetExecutingAssembly(); var migrationContext = new RunnerContext(announcer) { NestedNamespaces = true, Namespace = "Database.Migrations", Connection = connectionString }; var options = new MigrationOptions { PreviewOnly = false, Timeout = 60 }; var factory = new FluentMigrator.Runner.Processors.SqlServer.SqlServer2014ProcessorFactory(); using (var processor = factory.Create(connectionString, announcer, options)) { var runner = new MigrationRunner(assembly, migrationContext, processor); runner.MigrateUp(true); } } catch (Exception e) { } }
/// <summary> /// Migrate the database to the latest version. /// </summary> /// <param name="connectionStringName">The name of the connection string.</param> public static void MigrateToLatest(string connectionStringName) { var announcer = new NullAnnouncer(); var assembly = Assembly.GetAssembly(typeof(CreateCountriesTable)); var migrationContext = new RunnerContext(announcer) { Namespace = "ExampleApplication.Database.Migrations" }; var options = new MigrationOptions { PreviewOnly = false, Timeout = 60 }; var factory = new FluentMigrator.Runner.Processors.SqlServer.SqlServer2014ProcessorFactory(); using (var processor = factory.Create(connectionStringName, announcer, options)) { var runner = new MigrationRunner(assembly, migrationContext, processor); runner.MigrateUp(true); } }
public static void MigrateToLatest(string connectionString) { // var announcer = new NullAnnouncer(); var announcer = new TextWriterAnnouncer(s => System.Diagnostics.Debug.WriteLine(s)); var assembly = Assembly.GetExecutingAssembly(); var migrationContext = new RunnerContext(announcer) { Namespace = "LendingLibrary.Db.Migrations.Migrations" }; var options = new MigrationOptions { PreviewOnly = false, Timeout = 60 }; var factory = new FluentMigrator.Runner.Processors.SqlServer.SqlServer2014ProcessorFactory(); using (var processor = factory.Create(connectionString, announcer, options)) { var runner = new MigrationRunner(assembly, migrationContext, processor); runner.MigrateUp(true); } }
/// <summary> /// Migrate the database to the latest version. /// </summary> /// <param name="connectionStringName">The name of the connection string.</param> public static void MigrateToLatest(string connectionStringName) { var announcer = new NullAnnouncer(); var assembly = Assembly.GetAssembly(typeof(CreateCountriesTable)); var migrationContext = new RunnerContext(announcer) { Namespace = "ExampleApplication.Database.Migrations" }; var options = new MigrationOptions { PreviewOnly = false, Timeout = 60 }; var factory = new FluentMigrator.Runner.Processors.SqlServer.SqlServer2014ProcessorFactory(); using (var processor = factory.Create(connectionStringName, announcer, options)) { var runner = new MigrationRunner(assembly, migrationContext, processor); runner.MigrateUp(true); } }
public static void MigrateToLatest(string connectionString, Type sourceNamespace) { var announcer = new TextWriterAnnouncer(s => System.Diagnostics.Debug.WriteLine(s)); var assembly = Assembly.GetAssembly(sourceNamespace); var migrationContext = new RunnerContext(announcer) { Namespace = sourceNamespace.Namespace }; var options = new MigrationOptions { PreviewOnly = false, Timeout = 60 }; var factory = new FluentMigrator.Runner.Processors.SqlServer.SqlServer2014ProcessorFactory(); using (var processor = factory.Create(connectionString, announcer, options)) { var runner = new MigrationRunner(assembly, migrationContext, processor); runner.MigrateUp(true); } }