Open Closed

Multitenancy Question #1165


0
falsharif created

ABP Framework version: v4.2.2 UI type: Blazor DB provider: EF Core / Tiered (MVC) or Identity Server Separated (Angular): no

Hi Team, i currently have multitenant database per tenant implementation for one of my projects. The scenario is as follows:

Its a supermarket management SaaS, i have one host database and around 400 Databases for the tenants. 1 database per supermarket.

Now i am currently creating a customer mobile app in which the customers can order from the supermarkets. So the user registers and that creates a user in the host database, the user logs into the app then chooses a supermarket to place the order . When the user creates an order, this will create a new order in the relavant database. However, some tables have audited entities, how will the userId be carried over to the tenant database ? do i have to create the user again in the relevant database or how do i navigate such a situation ?

I hope you understand the situation, let me know if you have any questions .


1 Answer(s)
  • 0
    [email protected] created

    Hi,

    Have had similar use case. Generally you need to write some custom logic to take care of the scenario, that's what I did.