PGWmsWebApi/host/WmsWebApi.HttpApi.Host/EntityFrameworkCore/WmsWebApiHttpApiHostMigrationsDbContextFactory.cs

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

namespace WmsWebApi.EntityFrameworkCore
{
    public class WmsWebApiHttpApiHostMigrationsDbContextFactory : IDesignTimeDbContextFactory<WmsWebApiHttpApiHostMigrationsDbContext>
    {
        public WmsWebApiHttpApiHostMigrationsDbContext CreateDbContext(string[] args)
        {
            var configuration = BuildConfiguration();

            var builder = new DbContextOptionsBuilder<WmsWebApiHttpApiHostMigrationsDbContext>()
                .UseSqlServer(configuration.GetConnectionString("WmsWebApi"));

            return new WmsWebApiHttpApiHostMigrationsDbContext(builder.Options);
        }

        private static IConfigurationRoot BuildConfiguration()
        {
            var builder = new ConfigurationBuilder()
                .SetBasePath(Directory.GetCurrentDirectory())
                .AddJsonFile("appsettings.json", optional: false);

            return builder.Build();
        }
    }
}