Azure.ResourceManager.Sql (.NET) Acceptance Criteria

SDK: Azure.ResourceManager.SqlRepository: https://github.com/Azure/azure-sdk-for-net/tree/main/sdk/sqlmanagement/Azure.ResourceManager.SqlPurpose: Skill testing acceptance criteria for validating generated code correctness

---

1. ArmClient Creation with DefaultAzureCredential

✅ CORRECT: DefaultAzureCredential with ArmClient

using Azure.Identity;
using Azure.ResourceManager;
using Azure.ResourceManager.Sql;

var credential = new DefaultAzureCredential();
var armClient = new ArmClient(credential);

var subscriptionId = Environment.GetEnvironmentVariable("AZURE_SUBSCRIPTION_ID");
var subscription = armClient.GetSubscriptionResource(
    new ResourceIdentifier($"/subscriptions/{subscriptionId}"));

❌ INCORRECT: Hardcoded Credentials

// WRONG - never hardcode credentials
var credential = new ClientSecretCredential(
    "tenant-id",
    "client-id",
    "hardcoded-secret");
var armClient = new ArmClient(credential);

---

2. Resource Group Operations

✅ CORRECT: Navigate Resource Hierarchy

// Get subscription first
var subscription = armClient.GetSubscriptionResource(
    new ResourceIdentifier($"/subscriptions/{subscriptionId}"));

// Then get resource group
var resourceGroup = await subscription.GetResourceGroupAsync("my-resource-group");

// Access SQL servers via collection
var serverCollection = resourceGroup.Value.GetSqlServers();

❌ INCORRECT: Skipping Hierarchy

// WRONG - cannot directly get servers without resource group
var servers = armClient.GetSqlServers("my-resource-group");

---

3. SQL Server CRUD Operations

✅ CORRECT: Create Server with Azure AD Authentication

using Azure.ResourceManager.Sql;
using Azure.ResourceManager.Sql.Models;

var serverData = new SqlServerData(AzureLocation.EastUS)
{
    AdministratorLogin = "sqladmin",
    AdministratorLoginPassword = "YourSecurePassword123!",
    Administrators = new ServerExternalAdministrator
    {
        AdministratorType = SqlAdministratorType.ActiveDirectory,
        Login = "admin@contoso.com",