public async Task Get()
{
#region Snippet:Managing_Sql_GetAManagedDatabases
ManagedDatabaseCollection managedDatabaseCollection = managedInstance.GetManagedDatabases();
ManagedDatabase managedDatabase = await managedDatabaseCollection.GetAsync("myManagedDatabase");
Console.WriteLine(managedDatabase.Data.Name);
#endregion
}
public async Task DeleteManagedDatabases()
{
#region Snippet:Managing_Sql_DeleteAManagedDatabases
ManagedDatabaseCollection managedDatabaseCollection = managedInstance.GetManagedDatabases();
ManagedDatabase managedDatabase = await managedDatabaseCollection.GetAsync("myManagedInstance");
await managedDatabase.DeleteAsync(true);
#endregion
}
public async Task List()
{
#region Snippet:Managing_Sql_ListAllManagedDatabases
ManagedDatabaseCollection managedDatabaseCollection = managedInstance.GetManagedDatabases();
AsyncPageable <ManagedDatabase> response = managedDatabaseCollection.GetAllAsync();
await foreach (ManagedDatabase managedDatabase in response)
{
Console.WriteLine(managedDatabase.Data.Name);
}
#endregion
}
public async Task CreateOrUpdate()
{
#region Snippet:Managing_Sql_CreateAManagedDatabases
ManagedDatabaseCollection managedDatabaseCollection = managedInstance.GetManagedDatabases();
ManagedDatabaseData data = new ManagedDatabaseData(AzureLocation.WestUS2)
{
};
string databaseName = "myDatabase";
var managedDatabaseLro = await managedDatabaseCollection.CreateOrUpdateAsync(true, databaseName, data);
ManagedDatabase managedDatabase = managedDatabaseLro.Value;
#endregion
}
public async Task GetIfExists()
{
#region Snippet:Managing_Sql_GetAManagedDatabasesIfExists
ManagedDatabaseCollection managedDatabaseCollection = managedInstance.GetManagedDatabases();
ManagedDatabase managedDatabase = await managedDatabaseCollection.GetIfExistsAsync("foo");
if (managedInstance != null)
{
Console.WriteLine(managedDatabase.Data.Name);
}
if (await managedDatabaseCollection.ExistsAsync("bar"))
{
Console.WriteLine("Virtual network 'bar' exists.");
}
#endregion
}