🎯

entity-framework

🎯Skill

from stuartf303/sorcha

What it does

Manages Entity Framework Core database operations with PostgreSQL, enabling efficient data access, migrations, and repository patterns.

entity-framework

Installation

Install skill:

npx skills add https://github.com/stuartf303/sorcha --skill entity-framework

AddedJan 27, 2026

View on GitHub Back to Skills

Skill Details

SKILL.md

Overview

# Entity Framework Core Skill

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.

Quick Start

Register DbContext with PostgreSQL

```csharp

// src/Common/Sorcha.Storage.EFCore/Extensions/EFCoreServiceExtensions.cs

services.AddDbContext((sp, options) =>

{

var dataSource = sp.GetRequiredService();

options.UseNpgsql(dataSource, npgsql =>

{

npgsql.EnableRetryOnFailure(maxRetryCount: 10, maxRetryDelay: TimeSpan.FromSeconds(30), errorCodesToAdd: null);

npgsql.MigrationsHistoryTable("__EFMigrationsHistory", "wallet");

});

```

Create a Migration

```bash

# From project directory containing DbContext

dotnet ef migrations add InitialSchema --project src/Common/Sorcha.Wallet.Core --startup-project src/Services/Sorcha.Wallet.Service

```

Apply Migrations Programmatically

```csharp

// Startup pattern used in Sorcha services

var pending = await dbContext.Database.GetPendingMigrationsAsync();

if (pending.Any())

await dbContext.Database.MigrateAsync();

```

Key Concepts

| Concept | Usage | Example |

|---------|-------|---------|

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

Common Patterns

Repository with Optional Eager Loading

```csharp

// src/Common/Sorcha.Wallet.Core/Repositories/EfCoreWalletRepository.cs

public async Task GetByAddressAsync(string address, bool includeAddresses = false)

{

IQueryable query = _context.Wallets;

if (includeAddresses)

query = query.Include(w => w.Addresses);

return await query.AsNoTracking().FirstOrDefaultAsync(w => w.Address == address);

}

```

Soft Delete with Filter Bypass

```csharp

// Bypass query filter for admin operations

var deleted = await _context.Wallets

.IgnoreQueryFilters()

.FirstOrDefaultAsync(w => w.Address == address);

```

Related Skills

See the postgresql skill for connection configuration and PostgreSQL-specific features
See the aspire skill for service registration and health checks
See the xunit skill for testing DbContext with InMemory provider

Documentation Resources

> Fetch latest EF Core documentation with Context7.

Library ID: /dotnet/entityframework.docs

Recommended Queries:

"DbContext pooling configuration dependency injection"
"migrations code-first apply production deployment"
"query filters soft delete global filters"
"bulk operations ExecuteUpdate ExecuteDelete"

More from this repository7

🎯

blazor🎯Skill

Builds and manages Blazor WebAssembly components with MudBlazor, supporting multiple render modes and authentication for interactive web applications.

🎯

dotnet🎯Skill

Configures .NET 10 projects with C# 13 features, service defaults, dependency injection, and modern development patterns.

🎯

aspire🎯Skill

Orchestrates .NET Aspire microservices by configuring service discovery, telemetry, health checks, and shared configurations.

🎯

minimal-apis🎯Skill

Defines and configures REST endpoints using .NET Minimal APIs with Scalar OpenAPI documentation and authorization policies.

🎯

signalr🎯Skill

Enables real-time WebSocket communication for broadcasting notifications and events across groups using SignalR hubs with JWT authentication.