neo-dotnet-ef-core

# EF Core Expert Skill ## Trigger On - The user requests database modeling, writing Linq queries, or handling database migrations. - The project contains a `DbContext` class or references the `Microsoft.EntityFrameworkCore` package. - There is a need to optimize database access performance or solve N+1 query problems. - The task involves complex data relationship design (one-to-many, many-to-many, inheritance mapping). ## Workflow 1. **Perceive (Model Awareness):** - Check `.csproj` to identify the EF Core version and database provider. - Analyze `DbContext` and entity configurations to confirm whether the Fluent API pattern is adopted. - Identify the current state of Migrations. 2. **Reason (Planning Phase):** - Evaluate whether queries need `.AsNoTracking()` or `.AsSplitQuery()`. - Determine whether custom interceptors are needed to handle audit fields. - Evaluate whether to use `ExecuteUpdate/Delete` (.NET 7+) for massive data updates. 3. **Act (Execution Phase):** - Write efficient and safe Linq queries. - Implement entity configuration classes (`IEntityTypeConfiguration`). - Create and execute database migration commands. 4. **Validate (Standard Validation):** - Check if the generated SQL meets performance expectations (avoiding full table scans). - Validate concurrency conflict handling logic. - Ensure all database accesses follow asynchronous patterns. ## Feature Roadmap (.NET 6 - 10) ### .NET 6 & 7 (Foundation) - **Split Queries...