entity-framework

EF Core with PostgreSQL requires configuring a DbContext, registering it in dependency injection, and applying migrations. This Skill provides standardized patterns for DbContext setup, retry policies, and schema management to ensure consistent data access across Sorcha services.

Soft delete in EF Core uses query filters to exclude deleted records automatically without physical removal. This Skill covers soft-delete semantics and query filter patterns to maintain data integrity while preserving historical records in PostgreSQL.

Database migrations automate schema changes across environments. This Skill provides guidance on generating migrations, applying them automatically in development, and managing PostgreSQL schema changes consistently within the Sorcha codebase.

JSONB is a PostgreSQL native type for storing structured data efficiently. This Skill includes JSONB handling patterns and best practices for leveraging PostgreSQL's JSONB capabilities through EF Core with optimized queries and bulk updates.

Repository patterns abstract data access logic and improve testability. This Skill enforces typed repositories and provides implementation guidance for generic and specialized EF Core repositories across Sorcha services.

Retry policies handle transient connection failures gracefully. This Skill specifies retry policy requirements for EF Core with PostgreSQL to improve reliability and resilience in the Sorcha environment.