entity-framework

What problem does it solve?

Sorcha projects often require robust data access layers using EF Core with PostgreSQL. This skill provides a clear pattern for configuring DbContext, applying migrations automatically in development, and implementing repository patterns with soft delete and JSONB support to improve data integrity and performance.

Core Features & Use Cases

• EF Core configuration patterns: DbContext setup, retry policies, and schema management for PostgreSQL.
• Migration & Repository patterns: Guidance on generating and applying migrations and implementing generic and specialized EF Core repositories.
• Best practices: Soft delete via query filters, JSONB usage, and optimized queries with bulk updates.

Quick Start

To start using EF Core with PostgreSQL in Sorcha, set up a DbContext, register it in DI, add and apply migrations, and utilize the EFCoreRepository pattern in services.