private void UpdateSqlDatabase(SqlDatabase existingSqlDatabase)
{
SqlDatabaseUpdate SqlDatabaseUpdate = new SqlDatabaseUpdate
{
Tags = this.IsParameterBound(c => c.Tag) ? TagsConversionHelper.CreateTagDictionary(this.Tag, validate: true) : existingSqlDatabase.Tags,
};
if (this.ShouldProcess(this.Name, string.Format(Resources.UpdatingSynapseSqlDatabase, this.Name, this.ResourceGroupName, this.WorkspaceName)))
{
this.SynapseAnalyticsClient.UpdateSqlDatabase(this.ResourceGroupName, this.WorkspaceName, this.Name, SqlDatabaseUpdate);
if (this.PassThru.IsPresent)
{
var result = this.SynapseAnalyticsClient.GetSqlDatabase(this.ResourceGroupName, this.WorkspaceName, this.Name);
WriteObject(result);
}
}
}
/// <summary>
/// Updates an existing database.
/// </summary>
/// <param name='operations'>
/// The operations group for this extension method.
/// </param>
/// <param name='resourceGroupName'>
/// The name of the resource group. The name is case insensitive.
/// </param>
/// <param name='workspaceName'>
/// The name of the workspace.
/// </param>
/// <param name='sqlDatabaseName'>
/// The name of the sql database.
/// </param>
/// <param name='parameters'>
/// The requested SqlDatabase resource state.
/// </param>
public static SqlDatabase BeginUpdate(this ISqlDatabasesOperations operations, string resourceGroupName, string workspaceName, string sqlDatabaseName, SqlDatabaseUpdate parameters)
{
return(operations.BeginUpdateAsync(resourceGroupName, workspaceName, sqlDatabaseName, parameters).GetAwaiter().GetResult());
}
/// <summary>
/// Updates an existing database.
/// </summary>
/// <param name='operations'>
/// The operations group for this extension method.
/// </param>
/// <param name='resourceGroupName'>
/// The name of the resource group. The name is case insensitive.
/// </param>
/// <param name='workspaceName'>
/// The name of the workspace.
/// </param>
/// <param name='sqlDatabaseName'>
/// The name of the sql database.
/// </param>
/// <param name='parameters'>
/// The requested SqlDatabase resource state.
/// </param>
/// <param name='cancellationToken'>
/// The cancellation token.
/// </param>
public static async Task <SqlDatabase> BeginUpdateAsync(this ISqlDatabasesOperations operations, string resourceGroupName, string workspaceName, string sqlDatabaseName, SqlDatabaseUpdate parameters, CancellationToken cancellationToken = default(CancellationToken))
{
using (var _result = await operations.BeginUpdateWithHttpMessagesAsync(resourceGroupName, workspaceName, sqlDatabaseName, parameters, null, cancellationToken).ConfigureAwait(false))
{
return(_result.Body);
}
}
public void UpdateSqlDatabase(string resourceGroupName, string workspaceName, string sqlDatabaseName, SqlDatabaseUpdate updateParams)
{
try
{
if (string.IsNullOrEmpty(resourceGroupName))
{
resourceGroupName = GetResourceGroupByWorkspaceName(workspaceName);
}
_synapseSqlV3ManagementClient.SqlDatabases.Update(resourceGroupName, workspaceName, sqlDatabaseName, updateParams);
}
catch (ErrorContractException ex)
{
throw GetSynapseException(ex);
}
}
