Design, tune, or review EF Core data access with proper modeling, migrations, query translation, performance, and lifetime management for modern .NET applications.
Generate or Scaffold ASP.NET Core Code
Generate or scaffold ASP.NET Core code — Razor Pages, Blazor components, MVC controllers, views, and Minimal API endpoints — without using ASP.NET Core CLI scaffolding/code-generation tools. Use when (1) adding CRUD pages, views, or API endpoints backed by Entity Framework (EF Core) and a database, (2) generating code to create, read, update, and delete data using a DbContext, (3) scaffolding UI components that match the project's existing CSS framework and coding patterns, or (4) creating data-driven forms, tables, and navigation for a model class. Do not use for non-ASP.NET projects or when CLI-based scaffolding is preferred.
Workflow
Step 1: Understand the Scaffolding Request
Parse the scaffolding request to identify:
- Scaffolder type: Razor Pages, Blazor components, MVC controller, Minimal API, empty page/view/component
- Model class and its namespace
- DbContext: new or existing, database provider (SQLite, SQL Server, etc.)
- Named items: controller name, endpoints class name, page name, view name, area name
- Options: OpenAPI, async actions, partial view, custom layout
- FK scope: whether to also scaffold CRUD for parent entities referenced by required foreign keys
Execution Checklists
Complete the applicable checklist in order. Do not stop after creating only the requested child resource when a required foreign key makes a parent resource necessary.
All EF scaffolders
- Inspect the project file,
Program.cs, target model, validation attributes, navigation properties, and foreign keys before editing. - Reuse the requested existing
DbContext; otherwise create the requested context. Add only the required provider package and register it withAddDbContextusing the requested provider and connection string. You will need to add Microsoft.EntityFrameworkCore.Design (PrivateAssets="all") when migrations are needed and it's missing. - Generate complete CRUD for the requested entity and every required parent entity: list, details, create, edit, and delete.
- Use the EF migration lifecycle: create a migration and apply it. Never call
EnsureCreatedor seed the database inProgram.cs. - Restore, build, and test the generated project. Fix errors before reporting completion.
MVC, Razor Pages, and Blazor
- Inspect the existing layout, CSS, and representative UI before generating markup.
- Generate the complete child and required-parent UI flows, including a navigation path to each resource so users can create a parent before creating a child.
- Match the existing UI framework and conventions; preserve existing render-mode configuration for Blazor.
Minimal APIs
- Use a route group for each resource and map
GET(list and by ID),POST,PUT, andDELETEendpoints for both child and required-parent resources. - Add OpenAPI metadata to every endpoint: unique name, tags, description, success/error response metadata, and
WithOpenApiwhen OpenAPI is enabled. - Create an executable
.httpfile with every CRUD request. Create parent records first, capture or clearly reuse their returned IDs in child requests, and run the requests in dependency order.
Step 2: Discover UI Style (non-API scaffolders only)
Skip this step for API controllers and Minimal API endpoints.
- Inspect the project's layout file (
_Layout.cshtml,MainLayout.razor, or equivalent) - Inspect the main CSS file (
site.css,app.css, Tailwind config, etc.) - Inspect 1–2 existing pages, views, or components in the project
All generated files MUST match the existing UI framework, CSS classes, and conventions. If Bootstrap is used, generate Bootstrap markup. If Tailwind is used, generate Tailwind markup.
Step 3: Apply Blazor-Specific Rules (Blazor scaffolders only)
Skip this step for non-Blazor scaffolders.
[SupplyParameterFromForm]properties MUST use= new()(notnull!) — preventsEditFormcrash on initial GETProgram.csmust chain.AddInteractiveServerComponents()onAddRazorComponents()and.AddInteractiveServerRenderMode()onMapRazorComponents<App>(). only add interactive server services/render mode when the generated components actually use @rendermode InteractiveServer (or the project already does).- Do not replace existing chained render mode calls (e.g.,
.AddInteractiveWebAssemblyRenderMode())
Step 4: Generate Code
Generate all code files manually. Follow these constraints:
- DO NOT use any scaffolding CLI tools
- DO NOT add packages beyond those required for the scaffolded functionality (e.g., do not add
RuntimeCompilation, or other convenience packages) - Match the coding style of existing files in the project (naming conventions, indentation, namespace patterns)
#### Enrich API Endpoints with OpenAPI Metadata (API scaffolders only)
When generating Minimal API or MVC API endpoints with OpenAPI support enabled, add rich metadata to every endpoint so the OpenAPI document is descriptive and useful:
.WithName("GetTodoItems")— unique operation ID for each endpoint.WithTags("TodoItems")— group endpoints by resource.WithDescription("Returns all todo items")— human-readable summary.Produces<List<TodoItem>>(StatusCodes.Status200OK)— document success response type.Produces(StatusCodes.Status404NotFound)— document error responses.ProducesValidationProblem()— for endpoints that validate input.WithOpenApi()— opt the endpoint into OpenAPI generation (if not already globally enabled)
Example for a Minimal API GET endpoint:
group.MapGet("/", async (TodoDbContext db) =>
await db.TodoItems.ToListAsync())
.WithName("GetAllTodoItems")
.WithTags("TodoItems")
.WithDescription("Returns all todo items")
.Produces<List<TodoItem>>(StatusCodes.Status200OK);
Step 5: Set Up Entity Framework (if applicable)
Skip this step if the scaffolding request does not involve Entity Framework.
- DO NOT seed the database in
Program.cs— always use migrations - For
dotnet ef: preferdotnet tool restorefrom a local tool manifest. Only install globally if no manifest exists - Inspect the model for navigation properties and foreign keys. Ensure CRUD endpoints/pages exist for referenced entities
- For API scaffolders: the
.httpfile MUST create parent entities before child entities. Use FK values consistent with creation order
Step 6: Generate .http File (API scaffolders only)
Skip this step for non-API scaffolders.
- Create a
.httpfile named{ModelName}.httpin the project directory. If a file with that name exists, append a numeric suffix (Product2.http,Product3.http) until unique - Include sample requests for every CRUD endpoint scaffolded, including endpoints for parent/dependent entities
- Every request must target the correct URL path matching an actual mapped endpoint
- Request labels must accurately describe the action (e.g., "Create a category" must POST to the categories endpoint)
- Order requests by dependency: create parent entities before child entities
- When possible, capture IDs from parent creation responses using your HTTP client's variable/templating features and reuse them as foreign key values in child-entity POST payloads
- If your client cannot capture response values, add comments indicating which FK IDs must be updated after running the parent creation requests; do not leave unrealistic placeholder or assumed FK values that do not correspond to actual parent records when executing the requests
Step 7: Verify
- Run
dotnet restore && dotnet buildfrom the project directory - If Entity Framework is used and this is the first verification:
- Run dotnet ef migrations add InitialCreate - Run dotnet ef database update - You will need to change "InitialCreate" to something else if you run this more than once, as EF Core requires unique migration names.
- If API scaffolder:
- Inspect Properties/launchSettings.json — if a profile named https exists, use dotnet run --launch-profile https - Execute EVERY .http request one at a time in dependency order - Report method, URL, and status code for each request - Stop and fix if any request returns non-2xx
- Fix all errors until a clean build succeeds
References
- Entity Framework Core DbContext Lifetime, Configuration, and Initialization
- OpenAPI overview in ASP.NET Core — .NET 10 specific; similar pages exist for other versions
Related skills
Use ManagedCode.MarkItDown when a .NET application needs deterministic document-to-Markdown conversion for ingestion, indexing, summarization, or content-processing workflows.
Use ManagedCode.Storage when a .NET application needs a provider-agnostic storage abstraction with explicit configuration, container selection, upload and download flows, and…