KoreForge.Data 1.1.2

KoreForge.Data

Database-first EF Core data layer for KoreForge applications.

Overview

KoreForge.Data provides scaffolded EF Core DbContext and entity classes generated from existing SQL Server databases. The library follows a database-first approach — the database schema is the source of truth, and all entity code is produced by dotnet ef dbcontext scaffold.

Design Principles

1. Database-first — schema is authoritative; EF migrations are not used
2. Generated code is disposable — scaffold output can be deleted and recreated at any time
3. Custom code survives regeneration — extensions live in partial classes outside the Generated/ folder
4. Scripts are the entry point — developers use PowerShell scripts, not raw CLI commands
5. Lookup tables, not enums — reference data lives in database tables with FK relationships

Package

Package	NuGet
KoreForge.Data

Project Structure

KoreForge.Data/
├── config/
│   └── scaffold-config.json          # Drives scaffolding — one entry per database
├── scr/
│   ├── scaffold-db.ps1               # Config-driven scaffold runner
│   └── AlertsDB-Notification-Schema.sql  # DDL for the Notification schema
├── src/KoreForge.Data/
│   ├── AlertsDbContext.cs             # Partial context extension  (ns: KoreForge.Data)
│   ├── AlertsDbOptions.cs             # Connection options          (ns: KoreForge.Data)
│   ├── AlertsDbServiceCollectionExtensions.cs  # DI registration   (ns: KoreForge.Data)
│   └── Generated/                     # Scaffold output — DO NOT EDIT
│       └── Alerts/                    # AlertsDB database
│           ├── AlertsDbContext.cs      # Generated context          (ns: KoreForge.Data)
│           └── Notification/          # Notification schema entities
│               ├── Channel.cs         # (ns: KoreForge.Data.Alerts.Notification)
│               ├── Priority.cs
│               ├── OutboxStatus.cs
│               ├── SendOutcome.cs
│               ├── NotificationOutbox.cs
│               ├── EmailPayload.cs
│               └── SmsPayload.cs
├── tst/KoreForge.Data.Tests/
├── scr/                              # Build & release scripts
├── doc/                              # Documentation
└── artifacts/                        # NuGet package output

Quick Start

1. Install

dotnet add package KoreForge.Data

2. Register in Program.cs

using KoreForge.Data;

builder.Services.AddAlertsDb(opts =>
    opts.ConnectionString = builder.Configuration.GetConnectionString("AlertsDB")!);

Or with a raw connection string:

builder.Services.AddAlertsDb("Server=.;Database=AlertsDB;...";

3. Inject and Use

using KoreForge.Data.Alerts.Notification;

public class NotificationService(AlertsDbContext db)
{
    public async Task<List<NotificationOutbox>> GetPendingAsync(CancellationToken ct)
    {
        var pendingStatus = await db.OutboxStatus
            .SingleAsync(s => s.Name == "Pending", ct);

        return await db.NotificationOutbox
            .Include(n => n.Channel)
            .Include(n => n.Priority)
            .Where(n => n.OutboxStatusId == pendingStatus.OutboxStatusId)
            .OrderBy(n => n.CreatedAt)
            .ToListAsync(ct);
    }
}

Databases

AlertsDB — Notification Schema

All lookup values are database rows — no C# enums. FK relationships provide navigation properties automatically via scaffold.

Scaffolding

Prerequisites

• .NET 10 SDK
• SQL Server instance with the target database
• Run dotnet tool restore once to install dotnet-ef

Running the Scaffold

.\scr\scaffold-db.ps1

This reads config/scaffold-config.json, cleans existing generated output, and runs dotnet ef dbcontext scaffold for each configured database.

To scaffold a single database:

.\scr\scaffold-db.ps1 -Database AlertsDB

Adding a New Database

1. Run the SQL DDL against the target server
2. Add a new entry to config/scaffold-config.json
3. Run .\scr\scaffold-db.ps1 -Database NewDbName
4. Add options class, DI registration, and empty partial context at src/KoreForge.Data/ project root
5. Set namespace and contextNamespace in the config to keep "Generated" out of namespaces

Extending Generated Code

Generated files live in Generated/ and must never be edited by hand. To add custom behaviour, create partial classes at the project root (or any folder outside Generated/):

// src/KoreForge.Data/NotificationOutboxExtensions.cs
namespace KoreForge.Data.Alerts.Notification;

public partial class NotificationOutbox
{
    public bool IsOverdue => OutboxStatus?.Name == "Pending"
        && CreatedAt < DateTimeOffset.UtcNow.AddHours(-1);
}

An empty partial AlertsDbContext is provided at src/KoreForge.Data/AlertsDbContext.cs for context-level extensions.

Namespace Convention

"Generated" never appears in a namespace — it is purely a folder for scaffold output.

Scripts

License

MIT