public static async Task <DatabaseFixture> CreateAsync()
{
var deployer = new SqlProjectDeployer("Database/WebApiBoilerplate.Database.sqlproj");
var database = await deployer.RecreateToAsync(
new SqlConnection(TestDatabaseConnectionString.ServerConnectionString),
TestDatabaseConnectionString.DatabaseName);
//setup our DI
var services = new ServiceCollection();
services.AddNHibernateDbContext <WebApiBorilerplateDbContext>(config =>
{
config.Connection(db =>
{
db.ConnectionString = TestDatabaseConnectionString.DatabaseConnectionString;
db.Dialect <MsSql2012Dialect>();
db.Driver <Sql2008ClientDriver>();
db.ConnectionProvider <DriverConnectionProvider>();
db.LogSqlInConsole = false;
});
});
services.AddCoreServices();
return(new DatabaseFixture(database, services.BuildServiceProvider()));;
}
public async static Task <int> Main(string[] args)
{
if (args.Length != 3)
{
Console.WriteLine("Usage: sqldeploy <projectFile> <connectionString> <dbName>");
return(5);
}
var deployer = new SqlProjectDeployer(args[0]);
await deployer.RecreateToAsync(new SqlConnection(args[1]), databaseName : args[2]);
return(0);
}
public Task <ISqlDatabase> CreateDeployDb1()
{
var deployer = new SqlProjectDeployer("db-1/DB1.sqlproj");
return(deployer.RecreateToAsync(new SqlConnection(SqlServerConnectionString.Current), databaseName: "DB1"));
}