Two real production scenarios on a 1-million-row catalog - a tiered pricing promotion and a live CSV feed import - with numbers measured on camera: where a hand-rolled EF Core loop is fine, and where BulkUpdate, BulkMerge, and BulkSynchronize from Entity Framework Extensions turn 51 seconds into 12.
Build a self-contained EF Core migration bundle in GitHub Actions, apply it to Azure SQL as a dedicated deploy step, then ship the API to App Service - schema and code moving together, with a smoke test at the end.
Calling Database.Migrate() on startup is the demo answer, not the production one. How to actually ship schema changes - idempotent SQL scripts, migration bundles, a least-privilege migration login, and reviewing what EF generated.
Record who changed what and when, automatically, by overriding SaveChangesAsync and walking the EF Core change tracker - with old/new values as JSON, sensitive fields stripped, and the current user pulled from the request.
EF Core 10 ships first-class LeftJoin and RightJoin operators, named query filters you can disable individually, complex types mapped to JSON, and native vector search for RAG - a tour of what actually changes day to day.
EF Core can map a C# class hierarchy to the database three different ways - one shared table, a table per class with joins, or a table per concrete type. Here is how each one looks on disk and which to pick.
Build a real PDF report in .NET with QuestPDF - a code-first document with a header and logo, a striped data table, and page-numbered footers - served straight from a minimal API endpoint.
Your multi-tenant EF Core app might be leaking one customer's data into another customer's response right now - here's how EF Core 10's named global query filters fix that for good.
Build one generic repository that handles CRUD for every entity, extend it per-aggregate for the queries that do not fit, and wire it into a Clean Architecture solution with MediatR and PostgreSQL.
