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); }