public static void DropDatabase(this TestDatabase testDatabase)
        {
            var connectionString = new ConnectionStringBuilder()
                                   .WithServer(DatabaseExtensions.GetInstalledServerInstanceName())
                                   .WithIntegratedSecurity()
                                   .Build();

            var script = string.Format($@"USE master;
ALTER DATABASE [{testDatabase.DatabaseName}] SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
DROP DATABASE [{testDatabase.DatabaseName}] ;");

            using (var connection = new SqlConnection(connectionString))
            {
                connection.ExecuteSql(script);
            }
        }
示例#2
0
        public static TestDatabase Create()
        {
            var connectionStringBuilder = new ConnectionStringBuilder()
                                          .WithServer(DatabaseExtensions.GetInstalledServerInstanceName())
                                          .WithIntegratedSecurity();

            var databaseName = string.Format($"SSISTesting-{Guid.NewGuid()}");

            using (var connection = new SqlConnection(connectionStringBuilder.Build()))
            {
                connection.ExecuteSql(string.Format($"CREATE DATABASE [{databaseName}]"));
            }

            var testDatabaseConnectionString = connectionStringBuilder
                                               .WithDatabaseName(databaseName)
                                               .Build();


            return(new TestDatabase(databaseName, testDatabaseConnectionString));
        }