using Microsoft.EntityFrameworkCore.Design; namespace OpenWarehouse.auth.api.Data; public class ApplicationDbFactory : IDesignTimeDbContextFactory { public ApplicationDbContext CreateDbContext(string[] args) { IConfigurationRoot configuration = new ConfigurationBuilder() .SetBasePath(Directory.GetCurrentDirectory()) .AddJsonFile("appsettings.json") .AddEnvironmentVariables() .Build(); var optionsBuilder = new DbContextOptionsBuilder(); // Use the connection string from configuration var connectionString = configuration.GetConnectionString("DefaultConnection"); optionsBuilder.UseNpgsql(connectionString); return new ApplicationDbContext(optionsBuilder.Options); } }