internal async Task <DatabaseUpdateResponse> UpdateDatabaseAsync(string serverName, string databaseName, string newName, string edition, int?maxSizeInGB) { var p = new DatabaseUpdateParameters(); if (!string.IsNullOrEmpty(newName)) { p.Name = newName; } if (!string.IsNullOrEmpty(edition)) { p.Edition = newName; } if (maxSizeInGB != null) { p.MaximumDatabaseSizeInGB = maxSizeInGB; } return(await _sqlManagementClient.Databases.UpdateAsync(serverName, databaseName, p)); }
/// <summary> /// Updates the properties of an Azure SQL Database. /// </summary> /// <param name='operations'> /// Reference to the /// Microsoft.WindowsAzure.Management.Sql.IDatabaseOperations. /// </param> /// <param name='serverName'> /// Required. The name of the Azure SQL Database Server where the /// database is hosted. /// </param> /// <param name='databaseName'> /// Required. The name of the Azure SQL Database to be updated. /// </param> /// <param name='parameters'> /// Required. The parameters for the Update Database operation. /// </param> /// <returns> /// Contains the response from a request to Update Database. /// </returns> public static Task <DatabaseUpdateResponse> UpdateAsync(this IDatabaseOperations operations, string serverName, string databaseName, DatabaseUpdateParameters parameters) { return(operations.UpdateAsync(serverName, databaseName, parameters, CancellationToken.None)); }
/// <summary> /// Updates the properties of an Azure SQL Database. /// </summary> /// <param name='operations'> /// Reference to the /// Microsoft.WindowsAzure.Management.Sql.IDatabaseOperations. /// </param> /// <param name='serverName'> /// Required. The name of the Azure SQL Database Server where the /// database is hosted. /// </param> /// <param name='databaseName'> /// Required. The name of the Azure SQL Database to be updated. /// </param> /// <param name='parameters'> /// Required. The parameters for the Update Database operation. /// </param> /// <returns> /// Contains the response from a request to Update Database. /// </returns> public static DatabaseUpdateResponse Update(this IDatabaseOperations operations, string serverName, string databaseName, DatabaseUpdateParameters parameters) { return(Task.Factory.StartNew((object s) => { return ((IDatabaseOperations)s).UpdateAsync(serverName, databaseName, parameters); } , operations, CancellationToken.None, TaskCreationOptions.None, TaskScheduler.Default).Unwrap().GetAwaiter().GetResult()); }
/// <summary> /// Updates SQL Server database information. /// </summary> /// <param name='operations'> /// Reference to the /// Microsoft.WindowsAzure.Management.Sql.IDatabaseOperations. /// </param> /// <param name='serverName'> /// The name of the SQL Server where the database is housed. /// </param> /// <param name='databaseName'> /// The name of the SQL Server database to be obtained. /// </param> /// <param name='parameters'> /// The parameters for the update database operation. /// </param> /// <returns> /// A standard service response including an HTTP status code and /// request ID. /// </returns> public static DatabaseUpdateResponse Update(this IDatabaseOperations operations, string serverName, string databaseName, DatabaseUpdateParameters parameters) { try { return(operations.UpdateAsync(serverName, databaseName, parameters).Result); } catch (AggregateException ex) { if (ex.InnerExceptions.Count > 1) { throw; } else { throw ex.InnerException; } } }