/// <summary>
/// Create a database on sql server
/// </summary>
/// <param name="databaseName"></param>
/// <param name="server"></param>
/// <param name="maxSize"></param>
/// <returns></returns>
public SqlAzureDatabase CreateSqlDatabase(
string databaseName,
SqlAzureServer server,
SqlAzureDatabaseMaxSize maxSize = SqlAzureDatabaseMaxSize.Gb1)
{
var existingDatabasesOnServer = SqlManagementClient.Databases.ListAsync(server.Name, new CancellationToken()).Result.Databases;
if(existingDatabasesOnServer.Any(d => d.Name == databaseName))
{
SqlManagementClient.Databases.DeleteAsync(server.Name, databaseName, new CancellationToken()).Wait();
}
return server.CreateDatabase(databaseName, maxSize);
}
