How to handle multi-tenancy in EF Core?

Multi-tenancy can be handled via Database-per-Tenant, Schema-per-Tenant, or a Shared Database using a TenantId column.

For a Shared Database, you implement multi-tenancy using Global Query Filters. Inject an ITenantProvider into the DbContext. In OnModelCreating, configure a filter HasQueryFilter(e => e.TenantId == _tenantProvider.TenantId). For Database-per-Tenant, dynamically switch the connection string during DbContext instantiation based on the current tenant context.