This example shows how you can use EF Core and ASP.NET Core to build multi-tenancy mechanisms into your web applications.
The general flow of the application:
sequenceDiagram
participant request
participant middleware
participant endpoint
request->>middleware: /?tenant=Khalid
middleware->>endpoint: TenantService.Set("Khalid")
endpoint->>request: Filtered Query by Tenant
We are utilizing EF Core Query Filters, but they are optional.
public Database(DbContextOptions<Database> options, ITenantService tenantService)
: base(options)
{
tenant = tenantService.Tenant;
}
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
modelBuilder
.Entity<Animal>()
.HasQueryFilter(a => a.Tenant == tenant)
.HasData(
new() {Id = 1, Kind = "Dog", Name = "Samson", Tenant = "Khalid"},
new() {Id = 2, Kind = "Dog", Name = "Guiness", Tenant = "Khalid"},
new() {Id = 3, Kind = "Cat", Name = "Grumpy Cat", Tenant = "Internet"},
new() {Id = 4, Kind = "Cat", Name = "Mr. Bigglesworth", Tenant = "Internet"}
);
}Have fun.
This is using .NET 7 and EF Core 7 bits, but should work with .NET 6 and EF Core 6.