NHibernate 映射外键

Question

我有两个表，Vehicle 和 Make。使用 MakeId 作为 Vehicle 表上的外键将两者连接起来。我的映射文件看起来与此类似

    <?xml version="1.0" encoding="utf-8" ?>
    <hibernate-mapping  xmlns="urn:nhibernate-mapping-2.2">
      <class name="Demo.Business.Objects.Vehicle, Demo.Business.Objects" table="Vehicle" >
        <id name="VehicleId" type="int" >
          <generator class="native"  />
        </id>
        <property name="RegNumber" type="String" />
        <property name="VehicleId" type="int" />
        <property name="CustomerId" type="int" />

        <join table="Make"  fetch="join">

          <key column="MakeId" foreign-key="MakeId"/>
          <property name="Description"  type="String"  />
        </join>
      </class>
    </hibernate-mapping>

我原以为这会在 make id 上连接两个表，但是 ios 生成的 SQL 尝试以下连接:vehicle.vehicleid = make.makeid。

我怎样才能让它发挥作用？ IE。我希望:

    select * from Vehicle
    inner join Make on Make.MakeId = Vehicle.Make Id

Answer 1

您需要以不同方式映射 Make 类:

<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping  xmlns="urn:nhibernate-mapping-2.2">
  <class name="Demo.Business.Objects.Vehicle, Demo.Business.Objects" table="Vehicle" >
    <id name="VehicleId" type="int" >
      <generator class="native"  />
    </id>
    <property name="RegNumber" type="String" />
    <property name="VehicleId" type="int" />
    <property name="CustomerId" type="int" />
    <many-to-one name="Make" column="MakeId"/>
  </class>
  <class name="(blahblah).Make, blahblah">
    <id name="MakeId" type="int">
      <generator class="native" />
    </id>

    <property name="Description"  type="String"  />
  </class>
</hibernate-mapping>

您的“Vehicle”类应该有一个 Make 类型的 Make 属性。