Insert constraint failed nFOREIGN KEY constraint在设定数据种子时失败

Question

我正在尝试播种一些样本数据。

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

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

    public int ConditionId { get; set; }
    public virtual Condition Condition { get; set; }
}

在我的种子方法中..

 protected override void Seed(AppContext context)
 {
      Condition condition1 = new Condition();
      condition1.Name = "Cond1";
      Entity.Entity newEntity1 = new Entity.Entity();
      newEntity1.Name = "Test1";
      newEntity1.Condition = condition1;
      context.Entities.Add(newEntity1);

      Condition condition2 = new Condition();
      condition2.Name = "Cond2";
      Entity.Entity newEntity2 = new Entity.Entity();
      newEntity2.Name = "Test Entity 2";
      newEntity2.Condition = condition2;
      context.Entities.Add(newEntity2);
      context.SaveChanges();
 }

我得到了这个异常约束失败的外键约束失败，我不知道我在这里做错了什么。

我也试着在第一次插入之后调用context.SaveChanges()，它运行得很好。但该错误仅在第二个context.SaveChanges()之后出现。

Answer 1

protected override void Seed(AppContext context)
 {
      Condition condition1 = new Condition();
      condition1.Id=1; 
      condition1.Name = "Cond1";
      Entity.Entity newEntity1 = new Entity.Entity();
      newEntity1.Name = "Test1";
      newEntity1.ConditionId=1
      newEntity1.Condition = condition1;
      context.Entities.Add(newEntity1);

      Condition condition2 = new Condition();
      condition2.Id=2
      condition2.Name = "Cond2";
      Entity.Entity newEntity2 = new Entity.Entity();
      newEntity2.Name = "Test Entity 2";
      newEntity2.ConditionId=2; 
      newEntity2.Condition = condition2;
      context.Entities.Add(newEntity2);
      context.SaveChanges();
 }

希望这能行得通。