Azure Resource Manager Mysql Dotnet

using Azure.Identity;using Azure.ResourceManager;using Azure.ResourceManager.MySql;using Azure.ResourceManager.MySql.FlexibleServers;
// Local dev: DefaultAzureCredential. Production: set AZURE_TOKEN_CREDENTIALS=prod or AZURE_TOKEN_CREDENTIALS=<specific_credential>var credential = new DefaultAzureCredential(    DefaultAzureCredential.DefaultEnvironmentVariableName);// Or use a specific credential directly in production:// See https://learn.microsoft.com/dotnet/api/overview/azure/identity-readme?view=azure-dotnet#credential-classes// var credential = new ManagedIdentityCredential();ArmClient client = new ArmClient(credential);

using Azure.ResourceManager.MySql.FlexibleServers;using Azure.ResourceManager.MySql.FlexibleServers.Models;
ResourceGroupResource resourceGroup = await client    .GetDefaultSubscriptionAsync()    .Result    .GetResourceGroupAsync("my-resource-group");
MySqlFlexibleServerCollection servers = resourceGroup.GetMySqlFlexibleServers();
MySqlFlexibleServerData data = new MySqlFlexibleServerData(AzureLocation.EastUS){    Sku = new MySqlFlexibleServerSku("Standard_D2ds_v4", MySqlFlexibleServerSkuTier.GeneralPurpose),    AdministratorLogin = "mysqladmin",    AdministratorLoginPassword = "YourSecurePassword123!",    Version = MySqlFlexibleServerVersion.Ver8_0_21,    Storage = new MySqlFlexibleServerStorage    {        StorageSizeInGB = 128,        AutoGrow = MySqlFlexibleServerEnableStatusEnum.Enabled,        Iops = 3000    },    Backup = new MySqlFlexibleServerBackupProperties    {        BackupRetentionDays = 7,        GeoRedundantBackup = MySqlFlexibleServerEnableStatusEnum.Disabled    },    HighAvailability = new MySqlFlexibleServerHighAvailability    {        Mode = MySqlFlexibleServerHighAvailabilityMode.ZoneRedundant,        StandbyAvailabilityZone = "2"    },    AvailabilityZone = "1"};
ArmOperation<MySqlFlexibleServerResource> operation = await servers    .CreateOrUpdateAsync(WaitUntil.Completed, "my-mysql-server", data);
MySqlFlexibleServerResource server = operation.Value;Console.WriteLine($"Server created: {server.Data.FullyQualifiedDomainName}");

MySqlFlexibleServerResource server = await resourceGroup    .GetMySqlFlexibleServerAsync("my-mysql-server");
MySqlFlexibleServerDatabaseCollection databases = server.GetMySqlFlexibleServerDatabases();
MySqlFlexibleServerDatabaseData dbData = new MySqlFlexibleServerDatabaseData{    Charset = "utf8mb4",    Collation = "utf8mb4_unicode_ci"};
ArmOperation<MySqlFlexibleServerDatabaseResource> operation = await databases    .CreateOrUpdateAsync(WaitUntil.Completed, "myappdb", dbData);
MySqlFlexibleServerDatabaseResource database = operation.Value;Console.WriteLine($"Database created: {database.Data.Name}");

MySqlFlexibleServerFirewallRuleCollection firewallRules = server.GetMySqlFlexibleServerFirewallRules();
// Allow specific IP rangeMySqlFlexibleServerFirewallRuleData ruleData = new MySqlFlexibleServerFirewallRuleData{    StartIPAddress = System.Net.IPAddress.Parse("10.0.0.1"),    EndIPAddress = System.Net.IPAddress.Parse("10.0.0.255")};
ArmOperation<MySqlFlexibleServerFirewallRuleResource> operation = await firewallRules    .CreateOrUpdateAsync(WaitUntil.Completed, "allow-internal", ruleData);
// Allow Azure servicesMySqlFlexibleServerFirewallRuleData azureServicesRule = new MySqlFlexibleServerFirewallRuleData{    StartIPAddress = System.Net.IPAddress.Parse("0.0.0.0"),    EndIPAddress = System.Net.IPAddress.Parse("0.0.0.0")};
await firewallRules.CreateOrUpdateAsync(WaitUntil.Completed, "AllowAllAzureServicesAndResourcesWithinAzureIps", azureServicesRule);

MySqlFlexibleServerConfigurationCollection configurations = server.GetMySqlFlexibleServerConfigurations();
// Get current configurationMySqlFlexibleServerConfigurationResource config = await configurations    .GetAsync("max_connections");
// Update configurationMySqlFlexibleServerConfigurationData configData = new MySqlFlexibleServerConfigurationData{    Value = "500",    Source = MySqlFlexibleServerConfigurationSource.UserOverride};
ArmOperation<MySqlFlexibleServerConfigurationResource> operation = await configurations    .CreateOrUpdateAsync(WaitUntil.Completed, "max_connections", configData);
// Common configurations to tunestring[] commonParams = { "max_connections", "innodb_buffer_pool_size", "slow_query_log", "long_query_time" };

MySqlFlexibleServerAadAdministratorCollection admins = server.GetMySqlFlexibleServerAadAdministrators();
MySqlFlexibleServerAadAdministratorData adminData = new MySqlFlexibleServerAadAdministratorData{    AdministratorType = MySqlFlexibleServerAdministratorType.ActiveDirectory,    Login = "[email protected]",    Sid = Guid.Parse("<entra-object-id>"),    TenantId = Guid.Parse("<tenant-id>"),    IdentityResourceId = new ResourceIdentifier("/subscriptions/.../userAssignedIdentities/mysql-identity")};
ArmOperation<MySqlFlexibleServerAadAdministratorResource> operation = await admins    .CreateOrUpdateAsync(WaitUntil.Completed, "ActiveDirectory", adminData);

// List servers in resource groupawait foreach (MySqlFlexibleServerResource server in resourceGroup.GetMySqlFlexibleServers()){    Console.WriteLine($"Server: {server.Data.Name}");    Console.WriteLine($"  FQDN: {server.Data.FullyQualifiedDomainName}");    Console.WriteLine($"  Version: {server.Data.Version}");    Console.WriteLine($"  State: {server.Data.State}");    Console.WriteLine($"  SKU: {server.Data.Sku.Name} ({server.Data.Sku.Tier})");}
// List databases in serverawait foreach (MySqlFlexibleServerDatabaseResource db in server.GetMySqlFlexibleServerDatabases()){    Console.WriteLine($"Database: {db.Data.Name}");}

// List available backupsawait foreach (MySqlFlexibleServerBackupResource backup in server.GetMySqlFlexibleServerBackups()){    Console.WriteLine($"Backup: {backup.Data.Name}");    Console.WriteLine($"  Type: {backup.Data.BackupType}");    Console.WriteLine($"  Completed: {backup.Data.CompletedOn}");}
// Point-in-time restoreMySqlFlexibleServerData restoreData = new MySqlFlexibleServerData(AzureLocation.EastUS){    CreateMode = MySqlFlexibleServerCreateMode.PointInTimeRestore,    SourceServerResourceId = server.Id,    RestorePointInTime = DateTimeOffset.UtcNow.AddHours(-2)};
ArmOperation<MySqlFlexibleServerResource> operation = await servers    .CreateOrUpdateAsync(WaitUntil.Completed, "my-mysql-restored", restoreData);

MySqlFlexibleServerResource server = await resourceGroup    .GetMySqlFlexibleServerAsync("my-mysql-server");
// Stop server (saves costs when not in use)await server.StopAsync(WaitUntil.Completed);
// Start serverawait server.StartAsync(WaitUntil.Completed);
// Restart serverawait server.RestartAsync(WaitUntil.Completed, new MySqlFlexibleServerRestartParameter{    RestartWithFailover = MySqlFlexibleServerEnableStatusEnum.Enabled,    MaxFailoverSeconds = 60});

MySqlFlexibleServerResource server = await resourceGroup    .GetMySqlFlexibleServerAsync("my-mysql-server");
MySqlFlexibleServerPatch patch = new MySqlFlexibleServerPatch{    Sku = new MySqlFlexibleServerSku("Standard_D4ds_v4", MySqlFlexibleServerSkuTier.GeneralPurpose),    Storage = new MySqlFlexibleServerStorage    {        StorageSizeInGB = 256,        Iops = 6000    }};
ArmOperation<MySqlFlexibleServerResource> operation = await server    .UpdateAsync(WaitUntil.Completed, patch);

MySqlFlexibleServerResource server = await resourceGroup    .GetMySqlFlexibleServerAsync("my-mysql-server");
await server.DeleteAsync(WaitUntil.Completed);

using Azure;
try{    ArmOperation<MySqlFlexibleServerResource> operation = await servers        .CreateOrUpdateAsync(WaitUntil.Completed, "my-mysql", data);}catch (RequestFailedException ex) when (ex.Status == 409){    Console.WriteLine("Server already exists");}catch (RequestFailedException ex) when (ex.Status == 400){    Console.WriteLine($"Invalid configuration: {ex.Message}");}catch (RequestFailedException ex){    Console.WriteLine($"Azure error: {ex.Status} - {ex.Message}");}

// ADO.NET connection stringstring connectionString = $"Server={server.Data.FullyQualifiedDomainName};" +    "Database=myappdb;" +    "User Id=mysqladmin;" +    "Password=YourSecurePassword123!;" +    "SslMode=Required;";
// With Entra ID token (recommended)var credential = new DefaultAzureCredential();var token = await credential.GetTokenAsync(    new TokenRequestContext(new[] { "https://ossrdbms-aad.database.windows.net/.default" }));
string connectionString = $"Server={server.Data.FullyQualifiedDomainName};" +    "Database=myappdb;" +    $"User [email protected];" +    $"Password={token.Token};" +    "SslMode=Required;";