コード例 #1
0
        public SqlServerFixture() : base(new SqlConnection(CreateConnectionString()), new SqlServerDialect())
        {
            var runner = new SqlServerMigrationRunner(Connection.ConnectionString);

            runner.CreateDatabaseIfNotExists();
            runner.MigrateUp(typeof(TMigrationInfo).Assembly, typeof(TMigrationInfo).Namespace);
        }
コード例 #2
0
        private static void MigrateToLatest(string connectionString, RuntimeOptions options)
        {
            var runner = new SqlServerMigrationRunner(connectionString);

            if (options.CreateIfNotExists)
            {
                runner.CreateDatabaseIfNotExists();
            }

            if (options.MigrateOnStartup)
            {
                runner.MigrateUp(typeof(CreateIdentitySchema).Assembly, typeof(CreateIdentitySchema).Namespace);
            }
        }
コード例 #3
0
        protected override void Dispose(bool disposing)
        {
            var connectionString = ConnectionString;
            var database         = Database;

            base.Dispose(disposing);

            var builder = new SqlConnectionStringBuilder(connectionString)
            {
                InitialCatalog = "master"
            };

            using (var db = new SqlConnection(builder.ConnectionString))
            {
                db.Open();
                try
                {
                    db.Execute($"ALTER DATABASE [{database}] SET SINGLE_USER WITH ROLLBACK IMMEDIATE");
                    db.Execute($"DROP DATABASE [{database}]");
                }
                catch (SqlException e)
                {
                    Trace.TraceError(e.ToString());
                }
            }

            switch (Connection)
            {
            case SqlConnection connection when connection.DataSource != null:
                try
                {
                    File.Delete(SqlServerMigrationRunner.DatabaseFileName(database));
                }
                catch (Exception e)
                {
                    Trace.TraceError(e.ToString());
                }

                break;
            }
        }
コード例 #4
0
        private static string CreateConnectionString()
        {
            var database = $"{Guid.NewGuid().ToString("N").ToUpperInvariant()}";
            var builder  =
                new SqlConnectionStringBuilder(
                    "Data Source=(localdb)\\MSSQLLocalDB;Integrated Security=true;MultipleActiveResultSets=true")
            {
                InitialCatalog = "master"
            };

            using (var connection = new SqlConnection(builder.ConnectionString))
            {
                connection.Open();

                var fileName = SqlServerMigrationRunner.DatabaseFileName(database);

                connection.Execute($"CREATE DATABASE [{database}] ON (NAME = N'{database}', FILENAME = '{fileName}')");
                connection.Execute($"ALTER DATABASE [{database}] SET READ_COMMITTED_SNAPSHOT ON;");
                connection.Execute($"ALTER DATABASE [{database}] SET ALLOW_SNAPSHOT_ISOLATION ON;");
            }

            builder.InitialCatalog = database;
            return(builder.ConnectionString);
        }