Use multiple dbcontext in the same query

[Bandude]

In order to maintain code, we've decided to separate the dbcontext into multiple files per schema.

We're using the Poold DbContext Factory in the start-up class.

We have a scenario where we would like to pull data from two different schemas and combine those into a custom object on the return.

The problem is we can't seem to add two different scoped services.
We could potentially just move everything into a single dbcontext, but we're concerned about maintainability long term.

this is not a working example of course, but might give you an idea of what we're trying to accomplish.

I'm new to pooled dbcontext so I'm sure I'm missing something.

Any help would be greatly appreciated.

[tobias-tengler]

From your example you are missing the UseDbContext attribute for the second DbContext. What's happening is that the UseDbContext middleware creates an instance of the DbContext using the factory and pushes it onto the local state in order to make it available to the resolver. The ScopedServiceAttribute is then used to retrieve the instance from the local state. When using the ScopedServiceAttribute you alwqys need to have a call to the UseDbContext middleware with the same DbContext type.

[Bandude]

Thanks, should have caught that. I appreciate your help!