Entity Framework Code-First：多对多关系种子数据填充失败问题

Hey, I’ve run into this exact issue a bunch of times—EF auto-generates the join table (like your QuestionSections), but the seed data doesn’t end up in it. The main culprits are usually missing bidirectional associations or EF not tracking the relationships properly in your seed method. Here are a few solid fixes:

1. Establish Bidirectional Associations Between Entities #

You need to make sure both sides of the relationship are linked. EF relies on tracking these collections to populate the join table. Here’s how to do it in your seed code:

// Create your Question instances first
var mathQuestion = new Question { Title = "What's 2+2?", /* other properties */ };
var scienceQuestion = new Question { Title = "What's the boiling point of water?", /* other properties */ };

// Create the Section and add questions to its collection
var basicSkillsSection = new Section 
{ 
    Name = "Basic Skills", 
    Questions = new List<Question> { mathQuestion, scienceQuestion }
};

// Don't forget to add the section to each question's Sections collection too!
mathQuestion.Sections.Add(basicSkillsSection);
scienceQuestion.Sections.Add(basicSkillsSection);

// Add everything to the context and save
context.Sections.Add(basicSkillsSection);
context.Questions.AddRange(mathQuestion, scienceQuestion);
context.SaveChanges();

If you only add questions to the section’s collection (and not vice versa), EF might not pick up the relationship—especially in one-off seed operations where tracking is more finicky.

2. Manually Insert into the Join Table (For Fine-Grained Control) #

If you don’t have a DbSet for the auto-generated QuestionSections table (which EF hides by default), you can first explicitly configure the relationship with Fluent API, then insert directly into the join table.

First, configure the relationship in your DbContext’s OnModelCreating method:

protected override void OnModelCreating(ModelBuilder modelBuilder)
{
    modelBuilder.Entity<Section>()
        .HasMany(s => s.Questions)
        .WithMany(q => q.Sections)
        .UsingEntity<Dictionary<string, object>>(
            "QuestionSections", // Match the auto-generated table name
            j => j.HasOne<Question>().WithMany().HasForeignKey("QuestionId"),
            j => j.HasOne<Section>().WithMany().HasForeignKey("SectionId")
        );
}

Then in your seed method, you can add entries directly to the join table:

// First save the sections and questions to get their IDs
context.Sections.Add(basicSkillsSection);
context.Questions.Add(mathQuestion);
context.SaveChanges();

// Manually add the association
context.Set<Dictionary<string, object>>("QuestionSections").Add(
    new Dictionary<string, object>
    {
        {"SectionId", basicSkillsSection.Id},
        {"QuestionId", mathQuestion.Id}
    }
);
context.SaveChanges();

This is great if you need to bulk-add associations or don’t want to modify the entity collections.

3. Verify Seed Execution Timing & Use HasData (For Static Seed Data) #

Make sure your seed method runs after migrations are applied. In EF Core, that usually means calling context.Database.Migrate() before your seed logic.

If you prefer using HasData (for static, pre-defined seed data), you need to seed the join table explicitly too:

// Seed Sections
modelBuilder.Entity<Section>().HasData(
    new Section { Id = 1, Name = "Basic Skills" }
);

// Seed Questions
modelBuilder.Entity<Question>().HasData(
    new Question { Id = 1, Title = "What's 2+2?" }
);

// Seed the join table associations
modelBuilder.Entity<Section>()
    .HasMany(s => s.Questions)
    .WithMany(q => q.Sections)
    .UsingEntity<Dictionary<string, object>>(
        "QuestionSections",
        j => j.HasData(
            new { SectionId = 1, QuestionId = 1 }
        )
    );

This method works best for fixed initial data that doesn’t need to be dynamic.

9 times out of 10, the issue is just missing the bidirectional association—start with method 1, and it should fix your QuestionSections table not populating.

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