Hosting multitenancy using hybrid data approach with Angular

[amsantoki]

Hello @iammukeshm and team, you are doing fantastic job and saving our lots of time. I am looking for multitenancy .Net core webapi in backend and Angular as frontend and I landed here.

First of all I am eagerly waiting for latest version of .NET Web API Boilerplate architecture, along with angular-material-boilerplate. So please let me know when we can get that, so I can start my project.

My Question.
I am going to start developing SAAS based application where my client wants distribute the application copy to their subscriber. So for that I did some planning to distribute based on some research, let me share with you.

I will go with by hosting multitenancy using virtual subdomain like abc.domain.com, xyz.domain.com where "abc" & "xyz" will be the tenant.

From database side I would like to go with hybrid database approach client have option to go with standalone database or shared database. In shared database will go with schema approach where every tenant has own table. So to achieve this will follow below step.

1. I will create a page which has only access to Admin.
2. There will be a form in that page where Admin can create tenant by filling some fields like
   • Tenant Name
   • Tenant detail (There will be multiple field)
   • ______.domain.com
   • Standalone database / Shared database
   • And many more necessary field.
3. When I create tenant by submitting form it will create virtual subdomain and database based on selection.
4. Where we have single application with hybrid approach database and tenant can access the system.

So, can you please share with me how can I do that by using your architecture.

Let me know if I am fail to explain my question.

[fretje]

From the api point of view, most of what you want is already possible:

• You can configure FinBuckle.Mulittenant using WithBasePathStrategy to support {tenant}.domain.com.
• A hybrid database is supported out of the box. When you create a tenant and you don't supply a connectionstring, the shared root database will be used. In the other case, a new database will be created for that specific tenant. The shared root database doesn't have separate tables per tenant though. It uses a TenantId column to filter for a specific tenant.
• I don't know about angular, but I know from the blazor side of things this admin page you're talking about for creating tenants is already available and almost does exactly what you want.
• The only thing missing is creating a virtual subdomain... I think this is something very specific to where you are hosting your site. I don't think there's a "generic" way of doing something like that? If there is... please let us know, and we might be able to include it in the template (even better if you raise a pr for it! ;-))

[amsantoki]

Thank you @fretje for the quick response.

Are you guys planning to use hybrid approach anywhere near in upcoming release ? Hybrid means
[tenant1].[Product], [tenant2].[Product] where product is table name. If connection string is there then it create new database.

[fretje]

I'm not sure how that would work, as multitenancy is now done by queryfilters. I don't think you can apply a queryfilter that filters on tablename in entityframework core?

Anyways it would be a feature for finbuckle multitenant to implement... maybe can ask over on their repo what they think about this?

[amsantoki]

Thank you so much for reply

[snax4a]

I think that the easiest way with this domain name tenants would be to create asterisk DNS record in your domain registrar so whatever you will type as '*' in *.yourdomain.com will be pointing to your server and then FinBuckle will handle that.

[fretje]

Wrt multitenant based on database schema... there is apparently an open issue on the finbuckle repo: Finbuckle/Finbuckle.MultiTenant#378 but like I said... some kind of support for this is needed in EFCore first...