Base solution for your next web application
Open Closed

Can I access data from all tenants in a multitenancy dedicated database approach ? #10540


User avatar
0
bofenstein created

Prerequisites

  • What is your product version? ABP 6.3.0
  • What is your product type (Angular or MVC)? Angular 11.2
  • What is product framework type (.net framework or .net core)? .net Core

If issue related with ABP Framework

  • What is ABP Framework version? abp-zero-template : 10.3.0

Is Multi insert possible in same table of different database at the simultaneously?

I am developing a Multitenant based software with dedicated database for each tenant. I want to store jobs data in tenant database as well as host database. Is that possible ?

Connection strings would be unique for all, so is this possible with 1 dbcontext ? I want to show jobs data on tenant dashboard as well as host dashboard. That is only possible if I manage to insert in jobs table for host database as well as tenant database at the same time.

Please help.


1 Answer(s)
  • User Avatar
    0
    ismcagdas created
    Support Team

    Hi @bofenstein

    By default, jobs are stored in Host database and executed from that database. But, in a job, you can switch to any tenant database and get data from tenant database.