Skip to content

microsoft/microsoft-sql

v1.0.0

Build and operate Azure SQL Database applications, from provisioning and secure connections through schema design, deployment, data movement, performance tuning, vector search, RAG, and local development with the Azure SQL Database container.

ef-core-azure-sql

Configures Entity Framework Core against Azure SQL Database, where retry is on by default and redefines a transaction: the execution strategy refuses a user-initiated transaction, and the wrapper it tells you to write replays the whole unit, so a fault after the commit writes the row twice and reports success. Also covers UseAzureSql versus UseSqlServer, EnableRetryOnFailure, JSON mapping and split queries. Use when a DbContext targets Azure SQL Database, and for "EnableRetryOnFailure", "connection resiliency for EF Core", "UseAzureSql or UseSqlServer", "AsSplitQuery", an Include returning tens of thousands of rows, "does not support user-initiated transactions", duplicated rows after a retry, or a migration that retypes JSON columns. Not general EF Core: pooling is connect-from-dotnet, retry connect-to-azure-sql, identity entra-id-auth, a pipeline github-actions-for-sql.

Read SKILL.md at the source

Pinned to revision eeb1c6867c2d, so it is the text this page describes rather than whatever the author pushed since.

Files

Every link opens the file at its source, pinned to the revision this page describes.