如何在EF Core中实现关联未知ID实体的数据种子填充？

首先得明确你遇到的核心问题：在EntityTypeBuilder的Configure方法里直接实例化AtlasDbContext是致命错误——EF Core在生成迁移、构建模型的过程中会调用所有实体的Configure方法，这时候实例化上下文会再次触发模型构建，形成无限循环，直接导致迁移进程卡住不动。

下面给你两种靠谱的解决方案，你可以根据场景选择：

方案一：硬编码固定ID（最适合初始化种子数据） #

种子数据本身就是用来初始化数据库的固定基础数据，完全可以给这些实体指定固定的ID（比如手动生成一个Guid字符串），这样就能直接在Movie的种子里关联对应的DirectorId，不需要查询上下文。

修改后的Person种子代码 #

public void Configure(EntityTypeBuilder<Person> builder)
{
    builder.ToTable("Persons");
    builder.Property(p => p.Id).HasColumnName("Id");
    
    // 手动指定固定的Guid作为ID
    var ridleyScottId = "d2f5a1a0-1234-4567-89ab-cdef01234567";
    builder.HasData(
        new Person { Id = ridleyScottId, Name = "Ridley Scott" }
    );
}

修改后的Movie种子代码 #

public void Configure(EntityTypeBuilder<Movie> builder)
{
    builder.ToTable("Movies");
    builder.Property(m => m.Id).HasColumnName("Id");
    
    // 直接使用上面固定的导演ID
    var ridleyScottId = "d2f5a1a0-1234-4567-89ab-cdef01234567";
    builder.HasData(
        new Movie
        {
            Id = Guid.NewGuid().ToString(), // 电影ID可以随机，也可以固定
            Title = "The Martian",
            Poster = File.ReadAllBytes($"{Environment.CurrentDirectory}\\wwwroot\\img\\TheMartian.poster.jpg"),
            Cover = File.ReadAllBytes($"{Environment.CurrentDirectory}\\wwwroot\\img\\TheMartian.cover.jpg"),
            ReleaseYear = "2015",
            SubTitle = "Bring Him Home",
            UserScore = 77,
            Overview = "During a manned mission to Mars," +
                        "Astronaut Mark Watney is presumed dead after a fierce storm and left behind by his crew. " +
                        "But Watney has survived and finds himself stranded and alone on the hostile planet. " +
                        "With only meager supplies, he must draw upon his ingenuity, " +
                        "wit and spirit to subsist and find a way to signal to Earth that he is alive.",
            DirectorId = ridleyScottId, // 直接关联固定ID
            Budget = 108000000,
            Revenue = 630161890,
            Genres = new List<Genre> { Genre.Adventure, Genre.Drama, Genre.ScienceFiction }
        }
    );
}

这种方法简单直接，完全符合EF Core迁移时种子填充的设计逻辑，不会出现循环问题。

方案二：运行时种子填充（适合动态或大量关联数据） #

如果你的种子数据需要动态查询（比如不想硬编码ID），可以把种子逻辑放到应用启动时，而不是迁移时的Configure方法里。这样可以通过依赖注入获取DbContext，彻底避免循环问题。

步骤1：创建种子扩展方法 #

public static class DbContextSeed
{
    public static async Task SeedAsync(AtlasDbContext context)
    {
        // 先检查导演是否存在，不存在则添加
        var ridleyScott = await context.Persons.FirstOrDefaultAsync(p => p.Name == "Ridley Scott");
        if (ridleyScott == null)
        {
            ridleyScott = new Person { Id = Guid.NewGuid().ToString(), Name = "Ridley Scott" };
            context.Persons.Add(ridleyScott);
            await context.SaveChangesAsync();
        }

        // 检查电影是否存在，不存在则添加并关联导演
        var theMartian = await context.Movies.FirstOrDefaultAsync(m => m.Title == "The Martian");
        if (theMartian == null)
        {
            context.Movies.Add(new Movie
            {
                Id = Guid.NewGuid().ToString(),
                Title = "The Martian",
                Poster = File.ReadAllBytes($"{Environment.CurrentDirectory}\\wwwroot\\img\\TheMartian.poster.jpg"),
                Cover = File.ReadAllBytes($"{Environment.CurrentDirectory}\\wwwroot\\img\\TheMartian.cover.jpg"),
                ReleaseYear = "2015",
                SubTitle = "Bring Him Home",
                UserScore = 77,
                Overview = "During a manned mission to Mars," +
                            "Astronaut Mark Watney is presumed dead after a fierce storm and left behind by his crew. " +
                            "But Watney has survived and finds himself stranded and alone on the hostile planet. " +
                            "With only meager supplies, he must draw upon his ingenuity, " +
                            "wit and spirit to subsist and find a way to signal to Earth that he is alive.",
                DirectorId = ridleyScott.Id,
                Budget = 108000000,
                Revenue = 630161890,
                Genres = new List<Genre> { Genre.Adventure, Genre.Drama, Genre.ScienceFiction }
            });
            await context.SaveChangesAsync();
        }
    }
}

步骤2：在Program.cs中调用种子方法 #

var builder = WebApplication.CreateBuilder(args);

// 添加DbContext
builder.Services.AddDbContext<AtlasDbContext>(options =>
    options.UseSqlServer(builder.Configuration.GetConnectionString("DefaultConnection")));

var app = builder.Build();

// 执行种子填充
using (var scope = app.Services.CreateScope())
{
    var services = scope.ServiceProvider;
    try
    {
        var context = services.GetRequiredService<AtlasDbContext>();
        await DbContextSeed.SeedAsync(context);
    }
    catch (Exception ex)
    {
        // 处理种子填充异常，比如记录日志
        var logger = services.GetRequiredService<ILogger<Program>>();
        logger.LogError(ex, "An error occurred seeding the database.");
    }
}

// 其他中间件配置...
app.Run();

这种方法的优势是可以动态处理关联数据，不需要硬编码ID，而且是在应用启动时执行，不会干扰迁移过程。

再复盘下你的原代码问题 #

EF Core在生成迁移时，会遍历所有实体的IEntityTypeConfiguration实现，调用Configure方法来构建模型。当你在Configure里实例化AtlasDbContext时，这个上下文的初始化又会触发模型构建，再次调用所有Configure方法，形成无限递归循环，导致迁移进程永远卡在构建模型的步骤里，无法生成迁移文件。

内容的提问来源于stack exchange，提问作者Emberfire