1

I'm trying to extend an older application with a new Web API and GraphQL / Hotchocolate was chosen as the technology to go.

The underlying SQL Server database consists of at least 3 databases. "at least" means, there can be more databases, depending on the amount of tenants, that are managed by the application.

This brings me to the problem, that I can't add the dbcontext services in the ConfigureService method of the Startup class, because the actual tenant is unknown at the time when the startup class is instanciated.

The first of the three databases is always the same, so there is no problem, but database 2 and 3 have slightly different connectionstrings and look like this "...Initial Catalog=TenantStructure{0}..." and "...Initial Catalog=TenantData{0}..." in the appsettings.json.

The suffix "{0}" needs to be replaced by the actual tenantid, which must be somewhere part of the query.

It seems as if I have to open the connections to the structure and data databases at each query and my question is, how I can pass additional informations like the necessary tenantid to the query. As far as I can see, I can't use the tenantid as a filter value.

Thanks for any help.

Holger
  • 25
  • 1
  • 7
  • Create your own factory(method) that returns dbcontext based on the right connection string? we have a similar setup – sommmen Nov 15 '21 at 08:08
  • Thanks for your answer. Unfortunately I'm not sure if I completely understand what you mean. Do you have any example code? How would that look like? – Holger Nov 15 '21 at 09:53
  • @Holger Did you find a solution to this? I am looking for a solution similar to yours. Thanks! – Heena Patel Jul 07 '22 at 02:51

0 Answers0