Following Up on Our Azure Deployment Journey

Introduction

In the previous post, we deployed a .NET Web API inside a Docker container and hosted it on Azure Web Apps.

That was step one—getting the app running.

Now, it’s time for step two—connecting to a database so we can persist data. This means:

• Creating an Azure SQL Database
• Configuring firewall rules so our Web App and local machine can talk to it
• Setting up the database schema with EF Core migrations
• Seeding the database with some initial data
• Verifying the connection & exposing API endpoints

If you just want the step-by-step commands to set up Azure SQL and connect it to your API, jump to the bottom for the TL;DR Deployment Guide.