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