我在SQL中有一个现有的多对多关系,正通过nhibernate映射到我的业务实体。
我要向子级(下面的类别)添加一个仅适用于父级和子级之间关系的属性。在SQL中,我将向联接表添加一个字段。
如何使用nhibernate从联接表中提取该值并将其与孩子的属性关联?
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2"
namespace="MyProject.Core.Entities"
assembly="MyProject.Core">
<class name="Product" table="Products" lazy="false">
<id name="ProductId" access="field">
<generator class="native" />
</id>
<property name="ProductName" access="field" />
<idbag name="Categories" table="ProductCategory">
<collection-id column="ProductCategoryId" type="int">
<generator class="native" />
</collection-id>
<key column="ProductId" />
<many-to-many column="CategoryId" class="Category" />
</idbag>
</class>
</hibernate-mapping>
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2"
namespace="MyProject.Core.Entities"
assembly="MyProject.Core">
<class name="Category" table="Categories" lazy="false">
<id name="CategoryId" access="field">
<generator class="native" />
</id>
<property name="CategoryName" access="field" />
</class>
</hibernate-mapping>