如何在运行时读取迁移文件并将其应用到EF Core中的数据库？

using Microsoft.EntityFrameworkCore;
using Microsoft.Extensions.DependencyInjection;
using System;
using System.IO;

namespace EFCoreMigration
{
    class Program
    {
        static void Main(string[] args)
        {
            var serviceProvider = new ServiceCollection()
                .AddDbContext<MyDbContext>(options => options.UseSqlServer("<connection_string>"))
                .BuildServiceProvider();

            var dbContext = serviceProvider.GetService<MyDbContext>();

            // 设置当前目录为包含迁移文件的目录
            var migrationFilesPath = Path.Combine(Directory.GetCurrentDirectory(), "Migrations");
            Directory.SetCurrentDirectory(migrationFilesPath);

            // 创建迁移对象
            var migrator = dbContext.Database.GetService<IMigrator>();

            // 获取数据库提供程序
            var databaseProvider = dbContext.Database.ProviderName;

            // 应用迁移到数据库
            migrator.Migrate();

            Console.WriteLine("Migration applied successfully.");
        }
    }

    public class MyDbContext : DbContext
    {
        public MyDbContext(DbContextOptions<MyDbContext> options) : base(options)
        {
        }

        // 定义数据库上下文中的实体集合
        public DbSet<User> Users { get; set; }
    }

    public class User
    {
        public int Id { get; set; }
        public string Name { get; set; }
    }
}