/// <summary>
/// Create a database on sql server
/// </summary>
/// <param name="databaseName"></param>
/// <param name="serverName"></param>
/// <param name="user"></param>
/// <param name="password"></param>
/// <param name="maxSize"></param>
/// <returns></returns>
public SqlAzureDatabase CreateSqlDatabase(
string databaseName,
string serverName = "",
string user = AzureServiceConstants.SqlServerAdminLogin,
string password = AzureServiceConstants.SqlServerAdminPassword,
SqlAzureDatabaseMaxSize maxSize = SqlAzureDatabaseMaxSize.Gb1)
{
var server = string.IsNullOrEmpty(serverName) ? CreateSqlServer(user, password) : GetSqlServer(serverName, user, password);
return(CreateSqlDatabase(databaseName, server, maxSize));
}
/// <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));
}
public void AlterDatabase(SqlAzureDatabase database, SqlAzureDatabaseMaxSize newSize)
{
if (database == null)
{
throw new ArgumentNullException("database");
}
if (!DatabaseExists(database.Name))
{
throw new Exception(string.Format("Database '{0}' does not exist on Sql Azure Server '{1}'.", database.Name, Name));
}
SqlHelper.ExecuteQuery(MasterDatabase.ConnectionString, database.GetAlterSqlStatement());
}
public SqlAzureDatabase CreateDatabase(string databaseName, SqlAzureDatabaseMaxSize size = SqlAzureDatabaseMaxSize.Gb1)
{
if (DatabaseExists(databaseName))
{
throw new Exception(string.Format("Database '{0}' already exists on Sql Azure Server '{1}'.", databaseName, Name));
}
var database = new SqlAzureDatabase(this, databaseName, size);
SqlHelper.ExecuteQuery(MasterDatabase.ConnectionString, database.GetCreateSqlStatement());
Dependencies.TestResourcesCollector.Remember(AzureResourceType.SqlDatabase, database.Name, database);
return(database);
}
internal SqlAzureDatabase(
SqlAzureServer server,
string databaseName,
SqlAzureDatabaseMaxSize maxSize)
{
if (server == null)
{
throw new ArgumentNullException("server");
}
if (string.IsNullOrEmpty(databaseName))
{
throw new ArgumentNullException("databaseName");
}
Name = databaseName;
Server = server;
MaxSize = maxSize;
}
internal SqlAzureDatabase(
SqlAzureServer server,
string databaseName,
SqlAzureDatabaseMaxSize maxSize)
{
if (server == null)
{
throw new ArgumentNullException("server");
}
if (string.IsNullOrEmpty(databaseName))
{
throw new ArgumentNullException("databaseName");
}
Name = databaseName;
Server = server;
MaxSize = maxSize;
}
public void AlterDatabase(string databaseName, SqlAzureDatabaseMaxSize newSize)
{
AlterDatabase(new SqlAzureDatabase(this, databaseName), newSize);
}
public SqlAzureDatabase CreateDatabase(string databaseName, SqlAzureDatabaseMaxSize size = SqlAzureDatabaseMaxSize.Gb1)
{
if (DatabaseExists(databaseName))
{
throw new Exception(string.Format("Database '{0}' already exists on Sql Azure Server '{1}'.", databaseName, Name));
}
var database = new SqlAzureDatabase(this, databaseName, size);
SqlHelper.ExecuteQuery(MasterDatabase.ConnectionString, database.GetCreateSqlStatement());
Dependencies.TestResourcesCollector.Remember(AzureResourceType.SqlDatabase, database.Name, database);
return database;
}
public void AlterDatabase(SqlAzureDatabase database, SqlAzureDatabaseMaxSize newSize)
{
if (database == null)
{
throw new ArgumentNullException("database");
}
if (!DatabaseExists(database.Name))
{
throw new Exception(string.Format("Database '{0}' does not exist on Sql Azure Server '{1}'.", database.Name, Name));
}
SqlHelper.ExecuteQuery(MasterDatabase.ConnectionString, database.GetAlterSqlStatement());
}
public void AlterDatabase(string databaseName, SqlAzureDatabaseMaxSize newSize)
{
AlterDatabase(new SqlAzureDatabase(this, databaseName), newSize);
}
/// <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);
}
/// <summary>
/// Create a database on sql server
/// </summary>
/// <param name="databaseName"></param>
/// <param name="serverName"></param>
/// <param name="user"></param>
/// <param name="password"></param>
/// <param name="maxSize"></param>
/// <returns></returns>
public SqlAzureDatabase CreateSqlDatabase(
string databaseName,
string serverName = "",
string user = AzureServiceConstants.SqlServerAdminLogin,
string password = AzureServiceConstants.SqlServerAdminPassword,
SqlAzureDatabaseMaxSize maxSize = SqlAzureDatabaseMaxSize.Gb1)
{
var server = string.IsNullOrEmpty(serverName) ? CreateSqlServer(user, password) : GetSqlServer(serverName, user, password);
return CreateSqlDatabase(databaseName, server, maxSize);
}
