public static SQLServerTestDatabase SQLServer2012TestDatabase(string serverName, string databaseName, ConfigurationStoreOptions configurationStoreOptions, OperationalStoreOptions operationalStoreOptions)
{
var connString = $"Data Source={serverName}; Initial Catalog={databaseName}; Integrated Security=SSPI; Application Name=IdentityServer4.NHibernate.IntegrationTests";
SQLServerTestDatabase testDb = null;
try
{
var dbConfig = Databases.SqlServer2012()
.UsingConnectionString(connString)
.EnableSqlStatementsLogging()
.AddConfigurationStoreMappings(configurationStoreOptions)
.AddOperationalStoreMappings(operationalStoreOptions)
.SetProperty(Environment.Hbm2ddlAuto, "create-drop");
testDb = new SQLServerTestDatabase(serverName, databaseName, dbConfig);
testDb.Create();
new SchemaExport(dbConfig).Execute(false, true, false);
}
catch (System.Exception ex)
{
Debug.WriteLine(ex.Message);
testDb?.Drop();
}
return(testDb);
}
internal static SQLServerTestDatabase SQLServer2012TestDatabase(string connectionString, string databaseName, ConfigurationStoreOptions configurationStoreOptions, OperationalStoreOptions operationalStoreOptions)
{
var dbConfig = Databases.SqlServer2012()
.UsingConnectionString($"{connectionString};Initial Catalog={databaseName}")
.EnableSqlStatementsLogging()
.AddConfigurationStoreMappings(configurationStoreOptions)
.AddOperationalStoreMappings(operationalStoreOptions)
.SetProperty(Environment.Hbm2ddlAuto, "create-drop");
var testDb = new SQLServerTestDatabase(connectionString, databaseName, dbConfig);
try
{
testDb.DropIfExists();
testDb.Create();
new SchemaExport(dbConfig).Execute(false, true, false);
}
catch (Exception ex)
{
Debug.WriteLine(ex.Message);
testDb.DropIfExists();
throw;
}
return(testDb);
}
