azure-resource-manager-sql-dotnet

You can provision Azure SQL databases in .NET by instantiating an ArmClient with DefaultAzureCredential and using the Azure.ResourceManager.Sql namespace to manage servers, databases, and elastic pools via the Azure Resource Manager API.

No, this SDK is intended for management-plane operations like provisioning and lifecycle management. Data-plane tasks such as executing queries require dedicated data-plane SDKs like Microsoft.Data.SqlClient.

The best way to manage Azure SQL firewall rules and failover groups in C# is using the Azure.ResourceManager.Sql package, which enables configuring these resources across subscriptions and resource groups through the ARM API.

Yes, authentication via DefaultAzureCredential is required. You instantiate an ArmClient using this credential to authorize the management-plane operations for your SQL resources in a .NET project.

Automate Azure SQL deployments across subscriptions by applying the Azure.ResourceManager.Sql SDK to manage resources programmatically, enabling automated deployments, governance, and lifecycle management of SQL assets.

You should not use this SDK for data-plane operations like executing queries or managing table data. It is strictly for management-plane tasks including provisioning servers, databases, elastic pools, and firewall rules.