entityframework-dotnet-hybrid

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.