public void CreateDeleteSqlExpress()
{
var connectionString = new ConnectionStringBuilder().UseLocalSqlExpress().UseRandomDBName("MyDB").ConnectionString;
Console.WriteLine(connectionString);
var db = new SqlTestDatabase(connectionString);
Assert.False(db.Exist());
db.Create();
Assert.True(db.Exist());
db.Delete();
Assert.False(db.Exist());
}
public void Initialize(WebHostContext context)
{
ITestDatabase db;
string connectionString;
string prefix = context.TestType.TestTypeInfo.Type.Name;
if (context.HostOptions is IISExpressHostOptions)
{
connectionString = new ConnectionStringBuilder().UseLocalDB().UseRandomDBName(prefix).ToString();
db = new SqlTestDatabase(connectionString);
}
else if (context.HostOptions is IISHostOptions)
{
connectionString = new ConnectionStringBuilder().UseLocalSqlExpress().UseRandomDBName(prefix).ToString();
db = new SqlTestDatabase(connectionString);
}
else if (context.HostOptions is AzureWebsiteHostOptions)
{
connectionString = NuwaGlobalConfiguration.SqlAzureConnectionString;
db = new SqlTestDatabase(connectionString);
}
else
{
throw new NotSupportedException(context.HostOptions.GetType().Name);
}
if (db.Exist())
{
db.Delete();
}
context.Properties.Add(NuwaDBContextKey, db);
context.DeploymentOptions.WebConfigTransformers.Add(new WebConfigTransformer(
config =>
{
config.ClearConnectionStrings();
config.AddConnectionString(ConnectionStringName, connectionString, "System.Data.SqlClient");
}));
}
