Add multi-tenancy to an existing ASP.NET Core application

Keep your organisations table as the tenant registry, resolve the tenant on each request, and isolate EF Core data with one call on the DbContext you already have.