DbContext.SaveChanges

Question

我有一个问题，在实体ProfessionalEmploymentRecord EF中插入一条记录会分别复制每个实体中现有的专业人员、计划和角色记录。我尝试使用数据库中现有的键/值对显式初始化Professional、Program、Role，但EF仍然使用新键创建重复的值。

public class ProfessionalEmploymentRecord
{
    public int ProfessionalEmploymentRecordId {get; set; }

    public virtual Professional Professional { get; set; }
    public virtual Program Program { get; set; }
    public virtual Role Role { get; set; }
}
public class Program
{
    public int ProgramId { get; set; }
    [MaxLength(20)]
    public string Name { get; set; }
}
public class Role
{
    public int RoleId { get; set; }
    [MaxLength(50)]
    public string Name { get; set; }
}
public class Professional
{
    public int ProfessionalId { get; set; }
    [MaxLength(20)]
    public string Name { get; set; }
}

当使用下面的Create时，我最终得到了三个相关实体中的新记录，尽管它们存在并且有一个键集。换句话说，我最终得到了三个相关实体中具有新主键(递增1)的值的副本。

    public ActionResult Create(ProfessionalEmploymentRecord professionalemploymentrecord)
    {
        if (ModelState.IsValid)
        {
            db.ProfessionalEmploymentRecords.Add(professionalemploymentrecord);
            db.SaveChanges();
            return RedirectToAction("Index");  
        }
        return View(professionalemploymentrecord);
    }

按要求

@model My.Models.ProfessionalEmploymentRecord
@{
ViewBag.Title = "Create";
}
<h2>Create</h2>
@using (Html.BeginForm()) {
@Html.ValidationSummary(true)
<fieldset>
    <legend> Professional Employment Record</legend>

    <div class="editor-label">
        Professional
    </div>
    <div class="editor-field">
        @Html.EditorFor(model => model.Professional.Name)
        @Html.ValidationMessageFor(model => model.Professional.Name)
    </div>
    <div class="editor-label">
         Program
    </div>
    <div class="editor-field">
        @Html.EditorFor(model => model.Program.Name)
        @Html.ValidationMessageFor(model => model.Program.Name)
    </div>
    <div class="editor-label">
         Role
    </div>
    <div class="editor-field">
        @Html.EditorFor(model => model.Role.Name)
        @Html.ValidationMessageFor(model => model.Role.Name)
    </div>
    <p>
        <input type="submit" value="Create" />
    </p>
</fieldset>
}

<div>
@Html.ActionLink("Back to List", "Index")
</div>

我已经使用下面的代码进行了测试。(我看到执行SaveChanges会在reco中设置*Id++ )。

    public void TestDummyAdd()
    {
        Professional prof = new Professional { ProfessionalId = 1, Name = "Chris" };
        Program prog = new Program { ProgramId = 1, Name = "A" };
        Role role = new Role { RoleId = 1, Name = "B" };
        ProfessionalEmploymentRecord reco = new ProfessionalEmploymentRecord { Professional = prof, Role = role, Program = prog, ProfessionalEmploymentRecordId = 0 };

        if (ModelState.IsValid)
        {
            db.ProfessionalEmploymentRecords.Add(reco);
            db.SaveChanges();
        }
    }

Answer 1

Add是在整个对象图上执行的操作。如果你添加你的记录，你也会添加它的所有关系，它们的关系，等等。有两个选项可以解决这个问题，这两个选项都要求你在持久化对象图中手动设置一些实体(有时还有关系)的状态：

• 像您一样调用Add，但之后您必须将图中所有现有实体的状态设置为Unchanged或Modified (实体将在数据库中更新)
• 调用Attach而不是Add，然后将所有新实体的状态设置为Add

设置状态可以通过以下方式完成：

db.Entry(entity).State = EntityState.Added;