• 一个继承关系类型通过NHibernate进行映射的案例


    以下内容译自我发往NHibernate国际用户组的邮件。

    look at the summary of type definition
    首先来看类型定义的摘要:

    public abstract class Person
    {
            public abstract Guid PersonID
            {
                get;
                set;
            }

            public abstract string FirstName
            {
                get;
                set;
            }

            public abstract string LastName
            {
                get;
                set;
            }
    }

    public class Customer:Person
    {
       
        #region override some properties of Person here
            #endregion

        public Guid CustomerID
        {
            get;
            set;
        }

        public String Email
        {
           get;
           set;
        }

        public ISet<Store> Stores
        {
           get;
           set;
        }
    }

    public class Store
    {
        public Guid StoreID
        {
               get;
           set;
        }

        public String Name
        {
           get;
           set;
        }

        public Customer Owner
        {
          get;
              set;
        }
    }

    Now, we do the mapping
    现在来看映射的实现:

    The Person with Customer:
    含有子类Customer的Person类:
    <class name="DAL.Model.Person, DataAccessLayer" table="Person" abstract="true" >
    <id name="PersonID" column="PersonID" type="Guid"  length="36" >
       <generator class="guid" />
    </id>
    <property name="FirstName" column="FistName" type="String" length="100" />
    <property name="LastName" column="LastName" type="String" length="100" />

      <!-- Customer-->
      <joined-subclass table ="Customer" name="DAL.Model.Customer, DataAccessLayer" >
        <key column="PersonID"/>
        <property name="CustomerID" column="CustomerID" type="Guid" length="36" update="false"/>
        <property name="Email" column="Email" type="String" length="100" />

        <!--  
        note: As the Customer type inherited from the Person type
        注意:如上所示,Customer类型继承自Person类型
         when you insert a new Store in DB, The Person's ID value will inserted into the Store table OwnerID column.

         当你在数据库中插入新的Store数据时,Person类型的主键值将会插入到Store表的外键列OwnerID中。
         so Store table foreign key constraint's primary key must be the Person's ID column.
          所以,Store表的外键约束的主键必须是Person表的主键列。
         If the Store table foreign key constraint's primary key set to Customer's primary key column, NH will be unable to properly handle this mapping.

         如果Store表的外键约束的主键设为Customer类型的主键列,NHibernate将无法正确处理这种映射。
        -->
        <set name="Stores" table="Store" generic="true"  cascade="all-delete-orphan"  >
          <key column="OwnerID" foreign-key="FK_Store_Person"   />
          <one-to-many class="DAL.Model.Store, DataAccessLayer" />
        </set>
      </joined-subclass>
     
    </class>

    The Store
    Store类型:
    <class name="DAL.Model.Store, DataAccessLayer" table="Store">
        <id name="StoreID" column="StoreID" type="Guid"  length="36" >
          <generator class="guid" />
        </id>
           
        <many-to-one name="Owner" class="DAL.Model.Customer" column="OwnerID" />   
        <property name="Name" column="Name" type="String" length="100" />
       
    </class>

  • 相关阅读:
    媒体定律:马航失联客机取代昆明袭击
    讨论世界的意义是否存在
    神与信仰和人的意义
    读《人生哲思录》论“人”与“意义”
    如果人类世界灭亡 幸存者有多少资源
    stagewidth stage.width 区别
    flash的render延迟渲染
    【翻译】自定义 UIViewController Transitions
    [功能]点击ImageView进入页面,时间响应者链实现
    开学面试笔试总结
  • 原文地址:https://www.cnblogs.com/JiangMingFeng/p/1563343.html
Copyright © 2020-2023  润新知