UseConnectionPerTenant

UseConnectionPerTenant.cs

        public static IServiceCollection UseConnectionPerTenant(this IServiceCollection services, IConfiguration configuration)
        {
            services.AddScoped<ProductsDbContext>((serviceProvider) =>
            {
                var tenant = serviceProvider.GetRequiredService<TenantInfo>(); // Get from parent service provider (ASP.NET MVC Pipeline)
                var connectionString = configuration.GetConnectionString(tenant.Name);
                var options = new DbContextOptionsBuilder<ProductsDbContext>()
                    .UseSqlServer(connectionString)
                    .Options;
                var context = new ProductsDbContext(options);
                return context;
            });

            return services;
        }