/// <summary>
/// Creates a throwaway database using the connection string provided. No need to set the Initial Catalog as it will get replaced by the name of the database that will be created.
/// </summary>
public static ThrowawayDatabase Create(string connectionString, ThrowawayDatabaseOptions options)
{
if (!TryPingDatabase(connectionString))
{
throw new Exception("Could not connect to the database");
}
var database = new ThrowawayDatabase(connectionString ?? string.Empty, options);
if (!database.CreateDatabaseIfDoesNotExist(options))
{
throw new Exception("Could not create the throwaway database");
}
return(database);
}
/// <summary>
/// Creates a throwaway database using the connection string provided.
/// No need to set the Initial Catalog as it will get replaced by the name of the database that will be created.
/// </summary>
public static ThrowawayDatabase Create(string connectionString, string databaseNamePrefix = null)
{
if (!TryPingDatabase(connectionString))
{
throw new Exception("Could not connect to the database");
}
var database = new ThrowawayDatabase(connectionString ?? "", databaseNamePrefix);
if (!database.CreateDatabaseIfDoesNotExist())
{
throw new Exception("Could not create the throwaway database");
}
return(database);
}
/// <summary>
/// Creates a database through SQL server authentication using the given username, password and the datasource/instance.
/// </summary>
public static ThrowawayDatabase Create(string username, string password, string datasource, string databaseNamePrefix = null)
{
var connectionString = $"Password={password};Persist Security Info=True;User ID={username};Initial Catalog=master;Data Source={datasource}";
if (!TryPingDatabase(connectionString))
{
throw new Exception("Could not connect to the database");
}
var database = new ThrowawayDatabase(connectionString, databaseNamePrefix);
if (!database.CreateDatabaseIfDoesNotExist())
{
throw new Exception("Could not create the throwaway database");
}
return(database);
}
/// <summary>
/// Uses the given instance as the Data Source of the connection string along with integration security
/// assuming that the current user has direct access to his or her Sql server instance.
/// </summary>
public static ThrowawayDatabase FromLocalInstance(string instance, string databaseNamePrefix = null)
{
var connectionString = $"Data Source={instance};Initial Catalog=master;Integrated Security=True;";
if (!TryPingDatabase(connectionString))
{
throw new Exception("Could not connect to the database");
}
var database = new ThrowawayDatabase(connectionString, databaseNamePrefix);
if (!database.CreateDatabaseIfDoesNotExist())
{
throw new Exception("Could not create the throwaway database");
}
return(database);
}
