How do you connect an ASP.NET Core app to Azure SQL?

• Use connection string in appsettings.json:

"ConnectionStrings": {

"DefaultConnection":

"Server=tcp:myserver.database.windows.net,1433;Initial

Catalog=MyDb;Persist Security Info=False;User

ID=myuser;Password=mypassword;MultipleActiveResultSets=False;Encrypt

=True;TrustServerCertificate=False;Connection Timeout=30;"

• Inject DbContext using Entity Framework Core:

builder.Services.AddDbContext<MyDbContext>(options =>

options.UseSqlServer(builder.Configuration.GetConnectionString("Defa

ultConnection")));