internal SqlAzureServer(
string serverName,
string user,
string password)
{
if (string.IsNullOrEmpty(serverName))
{
throw new ArgumentNullException("serverName");
}
if (string.IsNullOrEmpty(user))
{
throw new ArgumentNullException("user");
}
if (string.IsNullOrEmpty(password))
{
throw new ArgumentNullException("password");
}
Name = serverName;
User = user;
Password = password;
MasterDatabase = new SqlAzureDatabase(this, "master");
wamlClient = new WAML.Sql.SqlManagementClient(Dependencies.Subscription.Credentials,
new Uri(Dependencies.Subscription.CoreEndpointUrl));
}
internal SqlAzureServer(
string serverName,
string user,
string password)
{
if (string.IsNullOrEmpty(serverName))
{
throw new ArgumentNullException("serverName");
}
if (string.IsNullOrEmpty(user))
{
throw new ArgumentNullException("user");
}
if (string.IsNullOrEmpty(password))
{
throw new ArgumentNullException("password");
}
Name = serverName;
User = user;
Password = password;
MasterDatabase = new SqlAzureDatabase(this, "master");
wamlClient = new WAML.Sql.SqlManagementClient(Dependencies.Subscription.Credentials,
new Uri(Dependencies.Subscription.CoreEndpointUrl));
}
public void DropDatabase(SqlAzureDatabase database)
{
if (!DatabaseExists(database.Name))
{
return;
}
SqlHelper.ExecuteQuery(MasterDatabase.ConnectionString, database.GetDropSqlStatement());
Dependencies.TestResourcesCollector.Forget(AzureResourceType.SqlDatabase, database.Name);
}
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);
}
public IEnumerable <SqlAzureDatabase> GetDatabases()
{
var table = SqlHelper.ExecuteSelectQuery(MasterDatabase.ConnectionString, "SELECT * FROM sys.databases");
foreach (DataRow row in table.Rows)
{
var databaseName = row["name"].ToString();
if (databaseName.Equals("master", StringComparison.InvariantCultureIgnoreCase))
{
continue;
}
var database = new SqlAzureDatabase(this, databaseName);
var obj = SqlHelper.ExecuteFunction(database.ConnectionString,
string.Format("SELECT DATABASEPROPERTYEX('{0}', 'MaxSizeInBytes')", databaseName));
database.MaxSize = (SqlAzureDatabaseMaxSize)(((Int64)obj) / 1024 / 1024 / 1024);
yield return(database);
}
}
public bool DatabaseExists(SqlAzureDatabase database)
{
return(DatabaseExists(database.Name));
}
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 bool DatabaseExists(SqlAzureDatabase database)
{
return DatabaseExists(database.Name);
}
public IEnumerable<SqlAzureDatabase> GetDatabases()
{
var table = SqlHelper.ExecuteSelectQuery(MasterDatabase.ConnectionString, "SELECT * FROM sys.databases");
foreach (DataRow row in table.Rows)
{
var databaseName = row["name"].ToString();
if (databaseName.Equals("master", StringComparison.InvariantCultureIgnoreCase)) continue;
var database = new SqlAzureDatabase(this, databaseName);
var obj = SqlHelper.ExecuteFunction(database.ConnectionString,
string.Format("SELECT DATABASEPROPERTYEX('{0}', 'MaxSizeInBytes')", databaseName));
database.MaxSize = (SqlAzureDatabaseMaxSize)(((Int64)obj)/1024/1024/1024);
yield 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 DropDatabase(SqlAzureDatabase database)
{
if (!DatabaseExists(database.Name)) return;
SqlHelper.ExecuteQuery(MasterDatabase.ConnectionString, database.GetDropSqlStatement());
Dependencies.TestResourcesCollector.Forget(AzureResourceType.SqlDatabase, database.Name);
}
