I’m working on a multi-tenant ASP.NET Core 7 MVC application where each tenant has its own database. The connection string changes based on the URL, with each URL corresponding to a different tenant and its specific database connection string. I need to integrate Hangfire to handle background jobs, but I’m facing challenges with configuring Hangfire to use dynamic connection strings based on the tenant. Additionally, I need to handle the Hangfire Dashboard to show data specific to the current tenant.

Here is the setup I currently have:
ASP.NET Core 7 MVC
Multi-tenancy implementation
Different connection strings for different tenants, determined by the URL
Hangfire for background job processing
My Problem:
I need to configure Hangfire to use the correct connection string for each tenant dynamically. However, I’m not sure how to properly set up Hangfire in a multi-tenant environment where the connection string changes based on the URL. I also need to configure the Hangfire Dashboard to display data for the current tenant only.

What I’ve Tried:
Custom Middleware: I implemented custom middleware to intercept the request and set the connection string.
Dynamic DbContext: Attempted to configure the DbContext dynamically based on the connection string stored in the HttpContext.

Example Code:
Tenant Middleware:

public class TenantResolutionMiddleware
{
    private readonly RequestDelegate _next;

    public TenantResolutionMiddleware(RequestDelegate next)
    {
        _next = next;
    }

    public async Task InvokeAsync(HttpContext context, ITenantService tenantService)
    {
        try
        {
            await tenantService.IdentifyTenant(context);
            var tenant = await tenantService.GetCurrentTenantAsync(context);
            if (tenant != null)
            {
                context.Items["ConnectionString"] = tenant.ConnectionString;
                context.Items["TenantConnectionString"] = tenant.ConnectionString;
                context.Items["TenantId"] = tenant.Id;
            }
            else
            {
                var defaultConnectionString = context.RequestServices.GetRequiredService<IConfiguration>().GetConnectionString("Web");
                context.Items["ConnectionString"] = defaultConnectionString;
                context.Items["TenantConnectionString"] = defaultConnectionString;
            }
        }
        catch (Exception ex)
        {
            context.Response.StatusCode = 500; // Internal Server Error
            await context.Response.WriteAsync("An error occurred while identifying the tenant.");
            return;
        }
        await _next(context);
    }
}

Initialize Tenant Databases:

public static void InitializeTenantDatabases(this WebApplication app)
{
    using var scope = app.Services.CreateScope();
    var tenantService = scope.ServiceProvider.GetRequiredService<ITenantService>();

    var tenants = tenantService.GetAllTenants();

    foreach (var tenant in tenants)
    {
        using var tenantScope = app.Services.CreateScope();
        var dbContext = tenantScope.ServiceProvider.GetRequiredService<ApplicationDbContext>();

        dbContext.Database.SetConnectionString(tenant.ConnectionString);
        dbContext.Database.Migrate();

        var dataInitializers = tenantScope.ServiceProvider.GetServices<IDataInitializer>();
        foreach (var dataInitializer in dataInitializers)
            dataInitializer.InitializeData();
    }
}

ITenantService Interface:

public interface ITenantService
{
    Task IdentifyTenant(HttpContext context);
    Task<Entities.Tenant.Tenant> GetCurrentTenantAsync(HttpContext context);
    string GetCurrentTenantConnectionString();
    Guid GetCurrentTenantId();
    string GetCurrentTenantIdString();
    Entities.Tenant.Tenant GetCurrentTenant();
    Task<Entities.Tenant.Tenant> GetCurrentTenantAsyncCashing(HttpContext context);
    string GetConnectionStringByTenantId(Guid tenantId);
    string GetDatabaseProvider();
    IEnumerable<Entities.Tenant.Tenant> GetAllTenants();
}

What I’m Looking For:
How to configure Hangfire to dynamically use the correct connection string for each tenant based on the URL.
How to handle the Hangfire Dashboard to show data specific to the current tenant.
Examples or resources on how to properly implement Hangfire in a multi-tenant ASP.NET Core 7 MVC application.
Any potential pitfalls or best practices I should be aware of when integrating Hangfire with multi-tenancy.

I tried implementing custom middleware to set the connection string based on the URL and integrating it with Hangfire. I expected Hangfire to use the correct connection string for each tenant dynamically and execute background jobs for each tenant using their respective databases.

Expected Result:

Hangfire would dynamically pick up the connection string from the middleware and execute jobs for the correct tenant database.
The Hangfire Dashboard would display data specific to the current tenant.
Actual Result:

Hangfire did not use the dynamic connection string, and background jobs failed to connect to the correct tenant database.
The Hangfire Dashboard did not show tenant-specific data.