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); }