# Neo Dotnet Ef Core

> >

- **Type:** Skill
- **Install:** `agentstack add skill-benknightdark-neo-skills-neo-dotnet-ef-core`
- **Verified:** Yes — security-reviewed for prompt injection and unsafe behavior
- **Seller:** [Benknightdark](https://agentstack.voostack.com/s/benknightdark)
- **Installs:** 0
- **Category:** [Agent Skills](https://agentstack.voostack.com/c/agent-skills)
- **Latest version:** 0.1.0
- **License:** MIT
- **Upstream author:** [Benknightdark](https://github.com/Benknightdark)
- **Source:** https://github.com/Benknightdark/neo-skills/tree/main/skills/neo-dotnet-ef-core
- **Website:** https://neo-blog-iota.vercel.app/

## Install

```sh
agentstack add skill-benknightdark-neo-skills-neo-dotnet-ef-core
```

Requires the [AgentStack CLI](https://agentstack.voostack.com/docs/cli). Works with Claude Code, Cursor, and any MCP-compatible agent.

## About

# 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**: Solve the Cartesian product problem.
- **Bulk Operations**: Use `ExecuteUpdate/Delete` for high-performance updates.
- **JSON Columns**: Built-in JSON mapping support.
- **Compiled Models**: Reduce startup time for large models.

### .NET 8 & 9 (Productivity)
- **Primitive Collections**: Use simple type collections in queries.
- **HierarchyId**: Support for SQL Server hierarchical data.
- **Auto-compiled Queries**: Further optimize the query compilation process.
- **Complex Types**: Better support for Value Objects.

### .NET 10+ (Version-Specific Features)
- **Advanced Interceptors**: More query lifecycle hooks.
- **Optimized AOT Support**: AOT pre-compilation optimization for cloud-native environments.

## Coding Standards
- **Fluent API Preference**: Prioritize entity configuration classes over Data Annotations.
- **Async Always**: All I/O operations must be asynchronous.
- **No-Tracking by Default**: Read-only queries must always use `.AsNoTracking()`.
- **Naming**: Entity names correspond to tables, foreign key names have clear semantics.

## Deliver
- **Optimized Linq Queries**: Provide query code with the potential for high-performance SQL translation.
- **Migration Scripts & Guidance**: Provide correct migration commands and manual adjustment suggestions.
- **Database Schema Design**: Design normalized entity relationships based on business requirements.

## Validate
- Ensure the provided code complies with EF Core performance best practices.
- Validate whether the code correctly handles Nulls and database constraints.
- Confirm database connection and resource release logic is correct (using `using` or Scoped DI).

## Documentation
### Official References
- [Entity Framework Core Overview](https://learn.microsoft.com/en-us/ef/core/)
- [Performance Optimization in EF Core](https://learn.microsoft.com/en-us/ef/core/performance/)
- [Supported Database Providers](https://learn.microsoft.com/en-us/ef/core/providers/)

### Internal References
- [EF Core Coding Style and Naming Conventions](reference/coding-style.md)
- [EF Core Anti-Patterns and Best Practices](reference/anti-patterns.md)
- [EF Core Modern Patterns Guide](reference/patterns.md)

## Source & license

This open-source skill is cataloged on AgentStack and links to its original source — we do not rehost the code.

- **Author:** [Benknightdark](https://github.com/Benknightdark)
- **Source:** [Benknightdark/neo-skills](https://github.com/Benknightdark/neo-skills)
- **License:** MIT
- **Homepage:** https://neo-blog-iota.vercel.app/

Install and usage instructions live in the source repository linked above.

## Pricing

- **Free** — Free

## Security capabilities

Automated source analysis of v0.1.0 — what this tool can access:

- **Network access:** no
- **Filesystem access:** no
- **Shell / process execution:** no
- **Environment & secrets:** no
- **Dynamic code execution:** no

*"Yes" means the capability is present in the source — more access means more to trust, not that it is unsafe.*


## Versions

- **0.1.0** — security scan: passed — Imported from the upstream source.

## Links

- Listing page: https://agentstack.voostack.com/l/skill-benknightdark-neo-skills-neo-dotnet-ef-core
- Seller: https://agentstack.voostack.com/s/benknightdark
- Browse the marketplace: https://agentstack.voostack.com/browse

---
Listed on AgentStack — the marketplace for AI agent skills and MCP servers. Every listing is security-reviewed. Creators keep 70%.