休眠 多对多桥表 保持为空

本文关键字：休眠 | 更新日期: 2023-09-27 18:32:46

我有两个表，与桥表具有多对多关系。

用户类映射： 

<class name="MatrixCore.User" table="MatrixUser" lazy="false">
    <id name="ID" column="ID" unsaved-value="0">
      <generator class="native"/>
    </id>
    <property name="FirstName"/>
    <property name="LastName"/>
    <property name="UserName"/>
    <property name="Password"/>
    <many-to-one name="UserType" class="MatrixCore.UserType" />
    <set name="Projects" table="UserInProject" cascade="All">
      <key column="MatrixUser_ID"/>
      <many-to-many class="Project" column="Project_ID"/>
    </set>
  </class>

项目类映射：

<class name="MatrixCore.Project" table="Project" lazy="false">
   <id name="ID" column="ID" unsaved-value="0">
     <generator class="native"/>
   </id>
   <property name="Name" />
   <property name="Acronym"/>
   <property name="StartDate"/>
   <property name="EndDate"/>
   <set name="Users" table="UserInProject" cascade="All">
     <key column="Project_ID"/>
     <many-to-many class="User" column="MatrixUser_ID" />
   </set>
</class>
类

实现太简单每个类都有一个集合的。我正在尝试在桥表保持为空的表中插入记录。

    ICollection<Project> ps = new HashSet<Project>() { project};
            UserType tp = (UserType)session.Get("UserType", 1);
            User u = new User()
            {
                FirstName = "Hussein",
                LastName = "Hussein",
                UserName = "Hussein",
                Password = "welcome",
                UserType = tp,
                Projects = ps
            };
            session.Save(u);

休眠 多对多桥表 保持为空

试试这个映射 对于用户类

<set name="Projects" table="UserInProject" inverse="true" cascade="save-update" lazy="false">
  <key column="MatrixUser_ID" />
  <many-to-many class="Project" column="Project_ID"/>
</set>

和项目类

<set name="Users" table="UserInProject" cascade="save-update" lazy="false">
  <key column="Project_ID"  />
  <many-to-many class="User" column="MatrixUser_ID"/>
</set>
您需要

将用户添加到每个Projects中的 Users 属性中。

在Save之前添加以下循环 -

foreach (Project project in u.Projects)
{
   project.Users.Add(u);
}
相关文章：