/// <summary>
/// Creates a new database with the given name.
/// </summary>
/// <param name="dbName"></param>
public static void CreateDataBase(string dbName, bool waitTillCreation = false)
{
MasterDataBaseExecutor.Execute(string.Format("Create DATABASE {0}", dbName));
if (waitTillCreation)
{
VerifyDataBaseCreation(dbName);
}
}
/// <summary>
/// Given the dbName, returns its state.
/// </summary>
/// <param name="dbName"></param>
/// <returns></returns>
public static DataBaseState GetDataBaseState(string dbName)
{
var dbs = MasterDataBaseExecutor.Query <OnlineDatabaseBackup>(
"SELECT name, state FROM sys.databases WHERE name = @dbName",
new { dbName });
return(GetDataBaseStateFromCode(dbs.FirstOrDefault().State));
}
/// <summary>
/// Deletes the given database.
/// </summary>
/// <param name="dbName"></param>
public static void DeleteDataBase(string dbName)
{
MasterDataBaseExecutor.Execute(string.Format("DROP DATABASE {0}", dbName));
}
/// <summary>
/// Returns the list of all database backups present in the server.
/// </summary>
/// <returns></returns>
public static List <OnlineDatabaseBackup> GetAllDatabaseBackups()
{
return(MasterDataBaseExecutor.Query <OnlineDatabaseBackup>(
"SELECT name FROM sys.databases WHERE name LIKE 'Backup_%' AND state = @state",
new { state = Util.OnlineState }).ToList());
}
/// <summary>
/// Returns the count of total backup databases present in the current server.
/// </summary>
/// <returns></returns>
public static int GetTotalBackupDataBaseCount()
{
return(MasterDataBaseExecutor.Query <OnlineDatabaseBackup>(
"SELECT name FROM sys.databases WHERE name LIKE 'Backup_%' AND state = @state",
new { state = Util.OnlineState }).ToArray().Length);
}
