private static Guid CreateDatabase() { var database = Guid.NewGuid(); var connectionString = string.Format("Data Source=localhost;Integrated Security=true;"); var factory = new SqlServerConnectionFactory { ConnectionString = connectionString }; using (var connection = factory.CreateConnection()) { connection.Open(); var sql = string.Format("CREATE DATABASE [{0}]", database); connection.Execute(sql); } return database; }
private string ConfigureTestDatabase() { var database = CreateDatabase(); var connectionString = string.Format("Data Source=localhost;Initial Catalog={0};Integrated Security=true", database); tophat.Database.Install<SqlServerConnectionFactory>(connectionString, ConnectionScope.ByThread); Database = database.ToString(); var factory = new SqlServerConnectionFactory { ConnectionString = connectionString }; using (var connection = factory.CreateConnection()) { connection.Open(); Schema.Install(DatabaseDialect.SqlServer, connection); } return connectionString; }