ef-code-first – 我的人际关系错在哪里？由两个依赖实体引用的

该模型定义为;

public class AccessControlList
{
    [Key] public int Id { get; set; }
    public string Name { get; set; }
}

public class ManagedFile
{
    [Key] public int Id { get; set; }
    public string Name { get; set; }
    public virtual AccessControlList AccessControl { get; set; }
}

public class ManagedFolder
{
    [Key] public int Id { get; set; }
    public string Name { get; set; }
    public virtual AccessControlList AccessControl { get; set; }
    public virtual ISet<ManagedFile> Files { get; private set; }

    public ManagedFolder()
    {
        Files = new HashSet<ManagedFile>();
    }
}

基本上,我有一个可由ManagedFile或ManagedFolder实体引用的AccessControl实体.

为了确保将外键添加到ManagedFile和ManagedFolder,我添加了以下流畅的映射

protected override void OnModelCreating(DbModelBuilder modelBuilder)
    {
        modelBuilder.Conventions.Remove<OneToManyCascadeDeleteConvention>();
        modelBuilder.Conventions.Remove<PluralizingTableNameConvention>();

        modelBuilder.Entity<ManagedFile>()
                    .HasRequired(mf => mf.AccessControl)
                    .WithRequiredDependent()
                    .Map(m => m.MapKey("AccessControlListId"));


        modelBuilder.Entity<ManagedFolder>()
                    .HasRequired(mf => mf.AccessControl)
                    .WithRequiredDependent()
                    .Map(m => m.MapKey("AccessControlListId"));

        base.OnModelCreating(modelBuilder);
    }

这将构建一个完全符合我预期的数据库,每个ManagedFile和ManagedFolder都有一个外键AccessControlListId.

这一切看起来都不错,但是当我尝试使用此代码插入一些数据时

using(var ctx = new MyContext())
{
    var mf = ctx.Folders.Add(new ManagedFolder {Name = "$/"});
    mf.AccessControl = new AccessControlList();

    var file = new ManagedFile {Name = "myfile.txt"};
    mf.Files.Add(file);
    file.AccessControl = new AccessControlList();

    ctx.SaveChanges();
}

它抛出一个错误……

我无法弄清楚我做了什么,这是不正确的？

据我了解我的映射,EF可以保存一个新的AccessControlList实体,然后使用Id来编写ManagedFolder或ManagedFile表.

一如既往,我感谢您提供的任何帮助.

谢谢安迪