SQL Database Recipe — REFERENCE ONLY
Adds Azure SQL Database integration to an App Service base template.
Overview
This recipe composes with a Web API or Web App base template to add Azure SQL Database connectivity. It provides the IaC delta (SQL Server, database, firewall, RBAC) and per-language source code using EF Core, Prisma, or SQLAlchemy.
Integration Type
| Aspect | Value |
|---|---|
| Database | Azure SQL Database (Serverless or Provisioned) |
| Auth | Managed identity (passwordless) |
| ORM | EF Core (.NET), Prisma (Node.js), SQLAlchemy (Python) |
| Hosting | App Service (from base template) |
| Local Auth | Disabled in Azure (Entra ID only); local dev may use SQL auth |