This sample project uses the nHydrate modeler to define a multi-tenant entity model. Tenant access is controlled using connection strings. Each tenant has a unique database user. The code shows how to create a SQL Server user and use it to manage database entities with no data bleed. A tenant's data cannot "bleed" to other tenants. A Where statement is not necessary to limit tenant data. The framework handles all permissions to tenant data to ensure that bleed does not occur. In fact, it is not possible to query data across tenants.
nhydrate / efcoremultitenant Goto Github PK
View Code? Open in Web Editor NEWSample project that uses the nHydrate modeler to define a multi-tenant entity model.
Home Page: https://nhydrate.com