public async Task <bool> DoesDatabaseExist()
{
var databaseName = _databaseName.Replace("[", "");
databaseName = databaseName.Replace("]", "");
var query = new SqlQuery("SELECT database_id FROM sys.databases WHERE Name = @databaseName",
new Dictionary <string, object> {
{ "@databaseName", databaseName }
});
var obj = await _databaseConnection.ExecuteScalarOnDiffrentDatabaseAsync(query);
int databaseId = 0;
if (obj != null)
{
int.TryParse(obj.ToString(), out databaseId);
}
return(databaseId > 0);
}
