How to use DbContextFactory in Blazor Server when using database per tenant?

[cryo75]

I moved from a single databases to the per-tenant database in a Blazor Server-side app. Currently I have:

services.AddDbContextFactory<AppContext>(options =>
{
    options.UseSqlServer(configuration.GetConnectionString("App"));
});

But now how am I going to change the above service registration to use the per-tenant connection string?

[AndrewTriesToCode]

Hi, it's not using dbcontext factory but if you want to spin up a multitenant db context instance for a given tenant a static create factory method was recently added. Here is the link to the docs:
https://www.finbuckle.com/MultiTenant/Docs/v9.0.0/EFCore#factory-instantiation

Does that get you what you want?

[AndrewTriesToCode]

Also, there is an overload of AddDbContextFactory which accepts a service provider. Using that you can get the tenant by resoving IMultiTenantContextAccessor<TTenantType> then getting the connection string from the current tenant and plugging it into you UseSqlServerLine. That might be better for your use case unless you need to spin up a dbcontext for multiple tenants at once, then the option I described in the prior response will be better.