EF Core is the most popular way to work with a database in .NET.

Azure SQL Database is the managed SQL Server you get in the cloud, with backups, patching, and high availability handled for you.

Putting the two together is straightforward, but the cloud adds a few things you never deal with on a local SQL Server.

Connections drop under load. The firewall blocks you by default. And a database password sitting in your connection string is a risk you want to remove before production.

Today I want to present you with a complete guide to getting started with Azure SQL Database in .NET.

In this post, we will explore:

What Azure SQL Database is

How to create an Azure SQL Database in the Azure Portal

Connecting EF Core to Azure SQL

Running EF Core migrations against Azure SQL

Adding connection resilience for transient faults

Setting up Azure SQL with .NET Aspire

Passwordless authentication with Microsoft Entra ID

Let's dive in.

👉 Read original article on my newsletter:…