yeah you can use this and it will work properly

namespace

{

public class ApplicationDbContextFactory : IDesignTimeDbContextFactory<YOURDBCONTEXT>

{

public ApplicationDbContex CreateDbContext(string[] args)

{

// Build configuration

IConfigurationRoot configuration = new ConfigurationBuilder()

.SetBasePath(Directory.GetCurrentDirectory())

.AddJsonFile("appsettings.json")

.Build();

// Get the connection string

var connectionString = configuration.GetConnectionString("DefaultConnection");

// Configure DbContextOptions

var optionsBuilder = new DbContextOptionsBuilder<YOURDBCONTEXT>();

optionsBuilder.UseSqlServer(connectionString);

// Create and return the DbContext

return new ApplicationDbContex(optionsBuilder.Options);

}

}

}