ProductsDbContextFactory2

ProductsDbContextFactory2.cs

public class ProductsDbContextFactory : IDesignTimeDbContextFactory<ProductsDbContext>
{
    public ProductsDbContext CreateDbContext(string[] args)
    {
        // Build config
        IConfiguration config = new ConfigurationBuilder()
            .SetBasePath(Path.Combine(Directory.GetCurrentDirectory(), "../EfDesignDemo"))
            .AddJsonFile("appsettings.json")
            .Build();

        // Get connection string
        var optionsBuilder = new DbContextOptionsBuilder<ProductsDbContext>();
        var connectionString = config.GetConnectionString(nameof(ProductsDbContext));
        optionsBuilder.UseSqlServer(connectionString, b => b.MigrationsAssembly("EfDesignDemo.EF.Design"));
        return new ProductsDbContext(optionsBuilder.Options);
    }
}