使用Fluent NHibernate自动创建多个双向一对多关联

我是NHibernate和.NET框架的新手。 我想映射我的Project类,它具有一对多的关系Subproject和ProjectTask类。
public class Project : ProjectItem
{
    public virtual IList<Subproject> Subprojects { get; set; }

    public virtual IList<ProjectTask> Tasks { get; set; }

    [NotNull]
    public virtual ProjectStatus Status { get; set; }

    public Project()
    {
        Subprojects = new List<Subproject>();
        Tasks = new List<ProjectTask>();
        Status = new ProjectStatus();
    }

    public virtual void AddSubProject(Subproject subproject)
    {
        subproject.Project = this;
        Subprojects.Add(subproject);
    }

    public virtual void RemoveSubProject(Subproject subproject)
    {
        Subprojects.Remove(subproject);
    }

    public virtual void AddTask(ProjectTask task)
    {
        task.Project = this;
        Tasks.Add(task);
    }

    public virtual void RemoveTask(ProjectTask task)
    {
        Tasks.Remove(task);
    }
}

public class ProjectTask : ProjectItemTask
{
    [NotNull]
    public virtual Project Project { get; set; }
}

public class Subproject : ProjectItem
{
    [NotNull]
    public virtual Project Project { get; set; }
}
我的实体从抽象基类继承Id属性。 我使用自动化覆盖来重新定义我的映射:
public class ProjectMappingOverride : IAutoMappingOverride<Project>
{
    public void Override(AutoMapping<Project> mapping)
    {
        mapping.HasMany<Subproject>(x => x.Subprojects)
            .Cascade.All()
            .Inverse()
            .Not.LazyLoad()
            .AsBag();

        mapping.HasMany<ProjectTask>(x => x.Tasks)
            .Cascade.All()
            .Inverse()
            .Not.LazyLoad()
            .AsBag();

        mapping.HasOne<ProjectStatus>(x => x.Status)
            .Cascade.All()
            .Not.LazyLoad();
    }
}

public class SubprojectMappingOverride : IAutoMappingOverride<Subproject>
{
    public void Override(AutoMapping<Subproject> mapping)
    {
        mapping.References<Project>(x => x.Project)
            .ForeignKey("ProjectId");
    }
}

public class ProjectTaskMappingOverride : IAutoMappingOverride<ProjectTask>
{
    public void Override(AutoMapping<ProjectTask> mapping)
    {
        mapping.References<Project>(x => x.Project)
            .ForeignKey("ProjectId");
    }
}
当我只映射与Subproject类的关联时,一切正常,Project.Subprojects中Subproject类的所有实例都将正确存储到数据库中。当我使用ProjectTask类的第二个覆盖时,我得到以下异常: ---> NHibernate.HibernateException:数据库中已经存在一个名为“ProjectId”的对象。无法创建约束。查看以前的错误。 ---> System.Data.SqlClient.SqlException:数据库中已经有一个名为“ProjectId”的对象。 有谁知道,为什么会这样?     
已邀请:
您应该使用
Column
而不是
ForeignKey
映射项目引用
mapping.References<Project>(x => x.Project)
            .Column("ProjectId");
    

要回复问题请先登录注册