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(...)) |

Handles Entity Framework Core database access, migrations, and repository patterns for PostgreSQL. Use when: Creating DbContext classes, writing migrations, implementing repositories, configuring entity relationships, or optimizing database queries. Source: stuartf303/sorcha.

View raw