Entityframework Dotnet Single Db

Single DB (shared database)

→ Setup: [reference/setup.md](../../reference/setup.md) | Index: [SKILL.md](../../SKILL.md)

Một database; phân tách bằng TenantId + global query filter (ITenantEntity).

Đăng ký DI

Overload một generic, connection cố định, không interceptor:

public static IHostApplicationBuilder AddAppDbContext(this IHostApplicationBuilder builder)
{
    builder.Services.AddScoped();

    builder.Services.AddCoreDbContext(options =>
        options.UseNpgsql(builder.Configuration.GetConnectionString("AppDbContext")!));

    return builder;
}

Hành vi

• Cùng connection mọi request.
• X-Tenant-Id (hoặc claim/query/host) → SetTenantId → filter ITenantEntity.
• Không tenant → TenantId null trên context → thường không thấy dữ liệu tenant.

Khi nào dùng

SaaS nhỏ/vừa, ops đơn giản, không isolate DB per tenant.

Checklist

• [ ] AddCoreDbContext 1 generic
• [ ] Entity business: ITenantEntity
• [ ] ConnectionStrings:AppDbContext
• [ ] Không Master / DbTenantConnectionStringResolver (trừ khi nâng cấp hybrid sau)

Source & license

This open-source skill is cataloged on AgentStack and links to its original source — we do not rehost the code.

• Author: hoangnh2412
• Source: hoangnh2412/ai-skills
• License: MIT

Install and usage instructions live in the source repository linked above.