Entityframework Dotnet Separate Tenant Db

Separate tenant DB

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

Mỗi tenant một DB. Master DB lưu Tenant.Id + ConnectionString.

Đăng ký DI

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

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

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

    return builder;
}

Background job

await using var scope = scopeFactory.CreateAsyncScope();
var uow = scope.ServiceProvider.GetRequiredService();
await uow.SwitchDbContextAsync(tenantId, ct);
var repo = await uow.GetRepositoryAsync>(ct);

Batch: mỗi tenant một scope + UoW; không trộn Master UoW với tenant UoW.

Checklist

• [ ] Master + DbTenantConnectionStringResolver
• [ ] ITenantManagementEntity trên Master
• [ ] Migrate Master + từng DB tenant
• [ ] Job: SwitchDbContextAsync hoặc scope mới

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.