gpeipman / aspnetcoremultitenant

Multitenant ASP.NET Core application to serve as a starting point for real multitenant applications

Multi-tenant ASP.NET Core

This is demo project for my Multi-tenant ASP.NET Core presentation. It demonstrates multi-tenant solutions I have worked out for ASP.NET Core. I'm using the same demo also for presentations. Solutions provided here are not absolute truth. There are cases when something different is needed and then the code here serves as a good starting point.

Features

There are multiple features and solutions demonstrated in demo application:

• Using database per tenant strategy
• Using shared database for tenants
• Multi-tenant EF Core database context with security net
• Loading tenants configuration
• Missing tenant middleware
• Tenants provider to get current tenant
• Tenant-based dependency injection
• Unit-testing multi-tenant database context (coming soon)
• Multi-tenant configurable composite commands

Setting every thing up

To demonstrate multi-tenant features I have built I'm using SQL Server LocalDB and MySQL databases. SQL Server LocalDB uses integrated security. For MySQL some user account is needed to access database. Those who plan to run this example on Linux must use some Linux version of SQL Server or SQL Server running on some other machine.

There are two web applications in the solution:

• AspNetCoreMultitenant.Web - safe multitenant web application to use as an example and starting point
• AspNetCoreMultitenant.WebDangerous - dangerous approach to shared resources (shared database tables)

AspNetCoreMultitenant.Web defines three tenants:

• bigcorp - uses dedicated MySQL database
• sme1 - uses SQL Server database
• sme2 - uses SQL Server database

AspNetCoreMultitenant.WebDangerous defines two tenants:

• sme1 - uses same SQL Server database as sme2
• sme2 - uses same SQL Server database as sme1

There are also some host name mappings needed to run this demo on local machine:

• 127.0.0.1 bigcorp
• 127.0.0.1 sme1
• 127.0.0.1 sme2

Web application uses port 5000 and it must be added to URL of all tenants:

• http://bigcorp:5000
• http://sme1:5000
• http://sme2:5000

Dangerous web application uses port 5001 and it must be added to URL of all tenants:

• http://sme1:5001
• http://sme2:5001

When using public server to host this application make sure you turn on HTTPS in application startup.

Concepts

This solution has some important concepts to know:

• Tenant source - class that knows how to read tenant definitions from tenants store
• Tenant provider - class that knows how to find current tenant
• Dynamic cache key provider - class that provides EF Core with caching keys for DbContext model
• Missing tenant middleware - ASP.NET Core request pipeline middleware that acts when tenant is not found

aspnetcoremultitenant's Issues

Dashboard with all Tenant data and Creating Database on Tenant Registration.

I am trying to implement Multi-Tenant -per Tenant separate Schema (Database single Instance).
https://gunnarpeipman.com/aspnet-core-database-per-tenant/ Taking help from this tutorial. Now I have one Situation That the Owner of the Application wants to have a dashboard which will show data from all the Tenant - Is this possible to connect with different DBContext and get data, the number of Tenant is not fixed it can increase at run time.
Apart from that -
Is this possible to create database at runtime - when the send metadata is added in DB - That time if we can have a button to initiate the the process.
Need some suggestion- which way should I go.
Thanks

Use StorageConnectionString in Startup.cs

The Startup.cs file under AspNetCoreMultitenant.Web uses the following code:

services.AddScoped<IFileClient>(service =>
{
	var provider = service.GetRequiredService<ITenantProvider>();
	var tenant = provider.GetTenant();

	if(tenant.StorageType == "GoogleDrive")
	{
		return new GoogleDriveFileClient(tenant.ConnectionString);
	}

	if(tenant.StorageType == "AzureBlob")
	{
		return new AzureBlobStorageFileClient(tenant.ConnectionString);
	}

	return null;
});

The code should be return new GoogleDriveFileClient(tenant.StorageConnectionString); and return new AzureBlobStorageFileClient(tenant.StorageConnectionString);