EF Core connections and DbContext Designtime factory

ApplicationDbContext

public class ApplicationDbContext : DbContext
{
  public ApplicationDbContext(){}

  public ApplicationDbContext(DbContextOptions<ApplicationDbContext> options): base(options){}
}

ApplicationDbContextFactory

using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Design;
using Microsoft.Extensions.Configuration;

public class ApplicationDbContextFactory : IDesignTimeDbContextFactory<AppicationDbContext>
{
        readonly string cnString;
        public ApplicationDbContextFactory()
        {
            var baseDir = Path.GetDirectoryName(Assembly.GetExecutingAssembly().GetName().CodeBase);
            baseDir = baseDir.Replace("file:\\", "");
            
            IConfiguration configuration = new ConfigurationBuilder()
                .SetBasePath(baseDir) // Directory where the json files are located
                .AddJsonFile("appsettings.json", optional: false, reloadOnChange: true)
    #if LOCAL
                .AddJsonFile($"appsettings.local.json", optional: true, reloadOnChange: true)
    #else
                .AddJsonFile($"appsettings.development.json", optional: true, reloadOnChange: true)
    #endif
                
                .Build();
            cnString = configuration.GetConnectionString("DbConnectionString");
        }
        
        public AppicationDbContext CreateDbContext(string[] args)
        {
            var optionsBuilder = new DbContextOptionsBuilder<AppicationDbContext>();
            optionsBuilder.UseSqlServer(cnString, b => b.MigrationsAssembly("EF-Assembley"));
            return new eArchiveContext(optionsBuilder.Options);
        }

}

Program.cs

public class Program
{

  public static async Task Main(string[] args)

  {
      var environment = arguments["-env"]?.ToLower() ?? "development";

      var configBuilder = new ConfigurationBuilder()            
        .SetBasePath(baseDir)
        .AddJsonFile("appsettings.json", true, true)            
        .AddJsonFile($"appsettings.{environment.ToLower()}.json", optional: true, reloadOnChange: true)
        .AddEnvironmentVariables();
      ......
  }
  public static void Configure(HostBuilderContext hostContext, IServiceCollection services)
  {
    var cnString = configuration.GetConnectionString("DbConnectionString");
    services.AddDbContext<DbContext, ApplicationDbContext>(x => x.UseSqlServer(cnString));
    ...
  }
}

Program is the self-host
ApplicationDbContext lives in a library file and the dotnet ef tooling is cranky about that so I created a separate console application to create/run the migrations. It works well but has to have the -s or be executed from the same directory as that project