示例#1
0
        static void Main(string[] args)
        {
            var config = new ConfigurationBuilder().AddCommandLine(args, new Dictionary <string, string>
            {
                { "--d", "db" },
                { "--r", "re-create" }
            }).AddJsonFile("appsettings.json")
                         .Build();
            var db = config.GetValue <string>("db");
            var r  = config.GetValue <bool>("re-create");

            if (string.IsNullOrWhiteSpace(db))
            {
                Console.WriteLine("Supply target database like: --d sqlserver");
                return;
            }

            var connectionString = config.GetConnectionString("DefaultConnection");

            switch (db.ToLower())
            {
            case "sqlserver":
            {
                var migrator = new SqlServerMigrator(connectionString, r);
                migrator.Migrate();
                break;
            }

            default:
            {
                Console.WriteLine("Supply correct target database like: --d sqlserver");
                break;
            }
            }
        }
示例#2
0
        private void SetupDatabase(string connectionString)
        {
            SqlServerMigrator.DropDatabase(Configuration.DevelopmentConnectionString());

            var migrationResult = SqlServerMigrator.ApplyMigrations(connectionString);

            migrationResult.Error.Should().BeNull();
        }
        static void Main(string[] args)
        {
            // Verify that at least the database can be migrated downwards and upwards.
            using (var migrator = new SqlServerMigrator(ConnectionString
                                                        , typeof(SqlServerMigrator).Assembly
                                                        , typeof(_0_CreateManufacturerTable).Assembly
                                                        , typeof(_0_CreateSecuritySchema).Assembly
                                                        )
                   )
            {
                migrator.Down().Up();
            }

            VerifyMappings();
        }