<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2">

<class name="NorthWindNHibernate.OrdersEntity, NorthWindNHibernate" table="Orders">

<id name="orderID" column="OrderID" type="System.Int32"><generator class="native"/></id>

<property name="orderDate" column="OrderDate" access="field.pascalcase-underscore" not-null="false" type="System.DateTime" insert="true" update="true"></property>
<property name="requiredDate" column="RequiredDate" access="field.pascalcase-underscore" not-null="false" type="System.DateTime" insert="true" update="true"></property>
<property name="shippedDate" column="ShippedDate" access="field.pascalcase-underscore" not-null="false" type="System.DateTime" insert="true" update="true"></property>
<property name="freight" column="Freight" access="field.pascalcase-underscore" not-null="false" type="System.Decimal" insert="true" update="true"></property>
<property name="shipName" column="ShipName" access="field.pascalcase-underscore" not-null="false" type="System.String" length="40" insert="true" update="true"></property>
<property name="shipAddress" column="ShipAddress" access="field.pascalcase-underscore" not-null="false" type="System.String" length="60" insert="true" update="true"></property>
<property name="shipCity" column="ShipCity" access="field.pascalcase-underscore" not-null="false" type="System.String" length="15" insert="true" update="true"></property>
<property name="shipRegion" column="ShipRegion" access="field.pascalcase-underscore" not-null="false" type="System.String" length="15" insert="true" update="true"></property>
<property name="shipPostalCode" column="ShipPostalCode" access="field.pascalcase-underscore" not-null="false" type="System.String" length="10" insert="true" update="true"></property>
<property name="shipCountry" column="ShipCountry" access="field.pascalcase-underscore" not-null="false" type="System.String" length="15" insert="true" update="true"></property>

<many-to-one name="Customer"  access="field.pascalcase-underscore" not-null="false" outer-join="auto" insert="true" update="true">
   <column name="CustomerID"/>
</many-to-one>
<many-to-one name="Employee"  access="field.pascalcase-underscore" not-null="false" outer-join="auto" insert="true" update="true">
   <column name="EmployeeID"/>
</many-to-one>
<many-to-one name="ShipVia"  access="field.pascalcase-underscore" not-null="false" outer-join="auto" insert="true" update="true">
   <column name="ShipVia"/>
</many-to-one>

</class>
</hibernate-mapping>

<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2">

<class name="NorthWindNHibernate.OrderDetailsEntity, NorthWindNHibernate" table="[Order Details]">

<composite-id>
<key-property name="orderID" column="OrderID" type="System.Int32"></key-property>
<key-property name="productID" column="ProductID" type="System.Int32"></key-property>
</composite-id>

<property name="unitPrice" column="UnitPrice" access="field.pascalcase-underscore" not-null="true" type="System.Decimal" insert="true" update="true"></property>
<property name="quantity" column="Quantity" access="field.pascalcase-underscore" not-null="true" type="System.Int16" insert="true" update="true"></property>
<property name="discount" column="Discount" access="field.pascalcase-underscore" not-null="true" type="System.Single" insert="true" update="true"></property>
<many-to-one name="Order" column="OrderID" access="field.pascalcase-underscore" not-null="true" outer-join="auto" insert="false" update="false"></many-to-one>
<many-to-one name="Product" column="ProductID" access="field.pascalcase-underscore" not-null="true" outer-join="auto" insert="false" update="false"></many-to-one>

</class>
</hibernate-mapping>