skills.rest
zeshone
zeshoneCOMMUNITY
Explore all skills by this author →
GitHub

net8-apirest-dataaccess

Standardize EF Core data access patterns for ASP.NET Core 8 REST APIs.

Updated Mar 25, 2026
Search Tags:#data-access#soft-delete#ef-core#repository-pattern#sql-safety#dotnet-8#audit-interceptor
One-click install
npx skills add https://github.com/zeshone/zesh-one-skills --skill net8-apirest-dataaccess
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: net8-apirest-dataaccess
Source: https://github.com/zeshone/zesh-one-skills/tree/main/skills/backend/dataaccess
Command: npx skills add https://github.com/zeshone/zesh-one-skills --skill net8-apirest-dataaccess

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Entity Framework Core data access standards for ASP.NET Core 8 REST APIs. Addresses repeated boilerplate patterns, anti-patterns, audit/soft-delete inconsistencies, and unsafe SQL usage by establishing a consistent, production-ready baseline.

Core Features & Use Cases

  • DbContext pooling with AddDbContextPool to improve performance and resource utilization.
  • IEntityTypeConfiguration<T> based entity configurations to modularize model setup.
  • Audit automation via ISaveChangesInterceptor to standardize CreatedAt and UpdatedAt fields.
  • Global query filters for soft delete and explicit handling of IsDeleted.
  • Safe SQL usage with FromSql and stored procedures, plus explicit transaction guidance.
  • Clear repository patterns with domain entities and service-layer mapping.

Quick Start

Adopt these conventions in your .NET 8 APIs to standardize EF Core data access and auditing.

Frequently Asked Questions about net8-apirest-dataaccess

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I standardize EF Core data access for .NET 8 APIs?▼

Standardize EF Core data access for .NET 8 APIs by using pool-based DbContext registration, modular IEntityTypeConfiguration setups, and repository patterns to eliminate boilerplate and ensure a consistent backend service baseline.

How does EF Core audit automation work for CreatedAt and UpdatedAt fields?▼

EF Core audit automation works via an ISaveChangesInterceptor that automatically stamps CreatedAt and UpdatedAt fields during context saves, ensuring consistent audit trails across all domain entities without manual tracking.

What is the best way to implement soft delete with EF Core in ASP.NET Core 8?▼

The best way to implement soft delete with EF Core is by applying global query filters to automatically exclude entities marked IsDeleted, while providing explicit handling for when those deleted records need to be accessed.

Can I safely execute raw SQL and stored procedures using EF Core?▼

You can safely execute raw SQL and stored procedures using EF Core by following explicit transaction guidance and utilizing FromSql patterns correctly to prevent unsafe SQL usage in your data access layer.

Does AddDbContextPool improve performance for ASP.NET Core 8 REST APIs?▼

AddDbContextPool improves ASP.NET Core 8 REST API performance and resource utilization by reusing DbContext instances rather than instantiating new ones for every request, establishing a production-ready baseline.

Related Skills

Explore More Software Engineering Skills→
jim60105jim60105
21

csharp-project-init

Initialize C# ASP.NET Core Web API projects with Entity Framework Core and configuration files.

Community
Intermediate
filiptrivanfiliptrivan
61

ef-migrations

Execute EF Core migrations for Spiderly's database schema using dotnet ef tooling.

Community
Intermediate
MacPhobosMacPhobos

Software Patterns Primer

Selects architectural patterns based on identified problems and system requirements via decision tree.

Community
Intermediate
bbsbotbbsbot
1

database-performance

Optimize database access patterns with CQRS, AsNoTracking, row limits, and SQL joins for EF Core and Dapper.

Community
Advanced