entity-framework

SKILL.md

Sorcha uses EF Core 9+ with PostgreSQL (Npgsql) as the primary relational data store. The codebase implements a layered repository pattern with generic and specialized repositories, soft delete via query filters, and automatic migrations on startup.

| DbContext | Schema definition + change tracking | WalletDbContext, TenantDbContext | | Repository | Data access abstraction | EFCoreRepository | | Soft Delete | Query filter on DeletedAt | .HasQueryFilter(e => e.DeletedAt == null) | | JSONB | PostgreSQL JSON columns | .HasColumnType("jsonb") |

| ExecuteUpdate | Bulk updates without loading | ExecuteUpdateAsync(s => s.SetProperty(...)) |

Maneja el acceso a la base de datos, las migraciones y los patrones de repositorio de Entity Framework Core para PostgreSQL. Úselo cuando: cree clases de DbContext, escriba migraciones, implemente repositorios, configure relaciones entre entidades u optimice consultas de bases de datos. Fuente: stuartf303/sorcha.

Ver original