Entity Framework Core Cookbook - Second Edition

Implementing multitenancy

Multitenancy is the ability by which an application can act (and seem) different when observed in different ways. Think, for example, of a website that displays a different look and feel when it is accessed as http://abc.com or http://xyz.net. Here, we are talking about the same physical site having two different domain names bound to it, abc.com and xyz.net, which are the tenants.

When it comes to relational databases, there are essentially three techniques for achieving multitenancy:

• Separate database: Each tenant's data is kept in a separate database instance, with a different connection string for each; the multitenant system should pick automatically the one appropriate for the current tenant as shown in the following ...