skills.rest
hoangnh2412
hoangnh2412COMMUNITY
Explore all skills by this author →
WebsiteGitHub

entityframework-dotnet-hybrid

Configure hybrid multitenancy for Entity Framework Core in ASP.NET Core applications.

12|2|Updated May 4, 2020
Search Tags:#asp.net-core#multitenancy#database-migration#tenant-isolation#jarvis-framework#entityframework-core#hybrid-multitenancy
One-click install
npx skills add https://github.com/hoangnh2412/jarvis --skill entityframework-dotnet-hybrid
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: entityframework-dotnet-hybrid
Source: https://github.com/hoangnh2412/jarvis/tree/main/.opencode/skills/entityframework-dotnet/patterns/hybrid
Command: npx skills add https://github.com/hoangnh2412/jarvis --skill entityframework-dotnet-hybrid

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill addresses the challenge of implementing flexible multitenancy patterns for ASP.NET Core applications using Entity Framework Core, where different tenant tiers require either cost-effective shared database access or isolated dedicated databases for compliance and performance, eliminating the need to build and maintain separate multitenancy implementations for each scenario.

Core Features & Use Cases

  • Hybrid Tenant Database Support: Configure a master tenant registry to route tenants to either a shared database connection pool or individual dedicated databases based on tenant tier or requirements.
  • Tenant Isolation Guardrails: Enforce mandatory ITenantEntity and TenantId usage for all tenants accessing the shared database pool to prevent cross-tenant data leakage.
  • Streamlined Migration Workflows: Provides clear, separate migration steps for the master tenant registry, shared database pool, and individual dedicated tenant databases to ensure schema consistency.
  • Use Case: A SaaS platform serving small business clients on a shared cost-effective database pool, while enterprise clients receive isolated dedicated databases to meet strict data residency and performance requirements.

Quick Start

Use the entityframework-dotnet-hybrid skill to configure hybrid multitenancy for your Jarvis ASP.NET Core application with a master tenant registry, shared database connection pool, and dedicated per-tenant databases.

Frequently Asked Questions about entityframework-dotnet-hybrid

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
What is hybrid multitenancy in Entity Framework Core and when do I need it?▼

Hybrid multitenancy in Entity Framework Core routes tenants to either a shared database pool or isolated dedicated databases. You need it when SaaS tiers require cost-effective shared access for standard clients alongside isolated databases for compliance-sensitive enterprise tenants.

How do I configure a master tenant registry for ASP.NET Core hybrid multitenancy?▼

Configure a master tenant registry in your ASP.NET Core application to map tenant tiers to shared pool or dedicated databases. This registry routes connections, enforcing ITenantEntity and TenantId for shared pool tenants to ensure data isolation.

How do I run database migrations for shared and dedicated tenant databases?▼

Run separate database migration workflows for the master tenant registry, shared database pool, and individual dedicated tenant databases. This separation ensures schema consistency across both shared pool tenants and isolated dedicated databases.

Does this hybrid multitenancy pattern work with Jarvis clean architecture dependency injection?▼

Yes, this hybrid multitenancy pattern integrates with Jarvis clean architecture dependency injection systems. It configures tenant routing and database context resolution within the ASP.NET Core DI container for shared and dedicated databases.

How do I prevent cross-tenant data leakage in a shared database pool?▼

Prevent cross-tenant data leakage in a shared database pool by enforcing mandatory ITenantEntity implementation and TenantId filtering for all shared pool tenants. These guardrails ensure strict tenant data isolation.

Related Skills

Explore More Software Engineering Skills→
hoangnh2412hoangnh2412
12

entityframework-dotnet-separate-tenant-db

Configure isolated per-tenant database access for ASP.NET Core Jarvis applications.

Community
Intermediate
aleonsaaleonsa

multi-tenant-saas

Implement multi-tenant SaaS patterns with PostgreSQL RLS and SQLAlchemy.

Community
Advanced
microsoftmicrosoft
19

migrating-ef-dbcontext

Migrate Entity Framework DbContext registrations to ASP.NET Core dependency injection.

Official
Advanced
hoangnh2412hoangnh2412
12

entityframework-dotnet

Configure Entity Framework Core multitenancy and unit of work for .NET 9 projects.

Community
Advanced