Quickstart: Data API builder and Azure SQL database

01/27/2025

This is an ASP.NET Blazor web application that illustrates using Data API builder with Azure SQL database. This sample application uses a Blazor front-end to access an Azure SQL database account using the Data API builder container image.

This template illustrates these practices:

Using a user-assigned managed identity to connect hosting and database services
- Using managed identity to connect Azure Container Apps containers to an Azure SQL database account
- Assigning managed identity as the admin for the Azure SQL database account
Deploying a AdventureWorks-derived sample database to Azure SQL database
Disabling local and key-based authentication to Azure SQL database

Prerequisites

This template will create infrastructure and deploy code to Azure. If you don't have an Azure Subscription, you can sign up for a free account here. Make sure you have the contributor role in the Azure subscription.

The following prerequisites are required to use this application. Please ensure that you have them all installed locally.

Get started

Follow these steps to authenticate to Azure, initialize thetemplate, provision infrastructure in Azure, and deploy the code to Azure.

Log in to azd. Only required once per-install.
```
azd auth login
```
Run the first-time project setup. Initialize a project in the current directory, using this template.
```
azd init --template dab-azure-sql-quickstart
```
Provision the resources in Azure and deploy the application code.
```
azd up
```
Navigate to the running web application.

Tip

Azure Developer CLI will output the URL of the web application after deployment.

Application Architecture

This application utilizes the following Azure resources:

Azure Container Apps
- This service hosts the ASP.NET Blazor web application
- This service also hosts the Data API builder container
Azure SQL database
- This service stores the relational data

Here's a high level architecture diagram that illustrates these components. Notice that these are all contained within a single resource group, that will be created for you when you create the resources.

%%{ init: { 'theme': 'base', 'themeVariables': { 'background': '#243A5E', 'primaryColor': '#50E6FF', 'primaryBorderColor': '#243A5E', 'tertiaryBorderColor': '#50E6FF', 'tertiaryColor': '#243A5E', 'fontFamily': 'Segoe UI', 'lineColor': '#FFFFFF', 'primaryTextColor': '#243A5E', 'tertiaryTextColor': '#FFFFFF' } }}%%
flowchart TB
    subgraph web-app[Azure Container Apps]
        app-framework([.NET 9 - Blazor])
    end
    subgraph data-api-builder[Azure Container Apps]
        api-framework[[Data API builder]]
    end
    subgraph azure-sql[Azure SQL database]
        subgraph database-cosmicworks[Database: CosmicWorks]
            subgraph container-products[Container: Products]
            end
        end
    end
    web-app --> data-api-builder
    data-api-builder --> azure-sql

Cost of provisioning and deploying this template

This template provisions resources to an Azure subscription that you will select upon provisioning them. Refer to the Pricing calculator for Microsoft Azure to estimate the cost you might incur when this template is running on Azure and, if needed, update the included Azure resource definitions found in infra/main.bicep to suit your needs.

Tooling

This template is structured using the Azure Developer CLI. You can learn more about azd architecture in the official documentation.

Next steps

At this point, you have a complete application deployed on Azure. But there is much more that the Azure Developer CLI can do. These next steps will introduce you to additional commands that will make creating applications on Azure much easier.

azd down - to delete all the Azure resources created with this template

Attributions

This project uses

TailwindCSS, licensed under the MIT License
HeroIcons, licensed under the MIT License

Share via