net8-apirest-dataaccess

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.