home *** CD-ROM | disk | FTP | other *** search
/ Introducing the New Way to Shop from Home / Iceland.iso / pc / unipower / Data1.cab / IcelandRevisions_Client.xml1 < prev    next >
Text File  |  2003-03-05  |  71KB  |  1,320 lines
  1. <models>
  2.     <model name="IcelandRevisions">
  3.         <dataconnections>
  4.             <dataconnection name="Iceland" type="dcserver" connectionstring="IcelandOffline_Sync"/>
  5.             <dataconnection name="IcelandMain" type="dcserver" connectionstring="IcelandOffline"/>
  6.             <dataconnection name="IcelandRevisions" type="dcserver" connectionstring=""/>
  7.             <dataconnection name="MediaWWWRoot" type="file" connectionstring="%SMRuntime\Applications\IcelandOffline\Media_WWWRoot_Path%"/>
  8.             <dataconnection name="MediaStoreContent" type="file" connectionstring="%SMRuntime\Applications\IcelandOfflineStoreContent\Media_WWWRoot_Path%"/>
  9.             <dataconnection name="MediaRepository" type="file" connectionstring="%SMRuntime\Applications\IcelandOffline\Media_Repository_Path%"/>
  10.             <dataconnection name="MediaSoftware" type="file" connectionstring="%SMRuntime\Applications\IcelandOffline\Media_Software_Path%"/>
  11.         </dataconnections>
  12.         <objects>
  13.             <!-- Count set -->
  14.             <object name="Count">
  15.                 <datasource>
  16.                     <query id="Attributes" default="false">
  17.                         <select name="SELECT COUNT(*) AS RowCnt FROM Attribute" connection="Iceland" type="replace" use="raw"/>
  18.                     </query>
  19.                     <query id="AttributeGroups" default="false">
  20.                         <select name="SELECT COUNT(*) AS RowCnt FROM AttributeGroup" connection="Iceland" type="replace" use="raw"/>
  21.                     </query>
  22.                     <query id="AttributeMaps" default="false">
  23.                         <select name="SELECT COUNT(*) AS RowCnt FROM AttributeMap" connection="Iceland" type="replace" use="raw"/>
  24.                     </query>
  25.                     <query id="Barcodes" default="false">
  26.                         <select name="SELECT COUNT(*) AS RowCnt FROM Barcode" connection="Iceland" type="replace" use="raw"/>
  27.                     </query>
  28.                     <query id="Campaigns" default="false">
  29.                         <select name="SELECT COUNT(*) AS RowCnt FROM Campaign" connection="Iceland" type="replace" use="raw"/>
  30.                     </query>
  31.                     <query id="Categories" default="false">
  32.                         <select name="SELECT COUNT(*) AS RowCnt FROM Category" connection="Iceland" type="replace" use="raw"/>
  33.                     </query>
  34.                     <query id="Parameters" default="false">
  35.                         <select name="SELECT COUNT(*) AS RowCnt FROM Parameter" connection="Iceland" type="replace" use="raw"/>
  36.                     </query>
  37.                     <query id="PriceChanges" default="false">
  38.                         <select name="SELECT COUNT(*) AS RowCnt FROM PriceChange" connection="Iceland" type="replace" use="raw"/>
  39.                     </query>
  40.                     <query id="Products" default="false">
  41.                         <select name="SELECT COUNT(*) AS RowCnt FROM Product" connection="Iceland" type="replace" use="raw"/>
  42.                     </query>
  43.                     <query id="ProductAttributeValues" default="false">
  44.                         <select name="SELECT COUNT(*) AS RowCnt FROM ProductAttributeValue" connection="Iceland" type="replace" use="raw"/>
  45.                     </query>
  46.                     <query id="ProductGroups" default="false">
  47.                         <select name="SELECT COUNT(*) AS RowCnt FROM ProductGroup" connection="Iceland" type="replace" use="raw"/>
  48.                     </query>
  49.                     <query id="ProductInCategories" default="false">
  50.                         <select name="SELECT COUNT(*) AS RowCnt FROM ProductInCategory" connection="Iceland" type="replace" use="raw"/>
  51.                     </query>
  52.                     <query id="ProductInPromosets" default="false">
  53.                         <select name="SELECT COUNT(*) AS RowCnt FROM ProductInPromoset" connection="Iceland" type="replace" use="raw"/>
  54.                     </query>
  55.                     <query id="ProductOptions" default="false">
  56.                         <select name="SELECT COUNT(*) AS RowCnt FROM ProductOption" connection="Iceland" type="replace" use="raw"/>
  57.                     </query>
  58.                     <query id="ProductOptionValues" default="false">
  59.                         <select name="SELECT COUNT(*) AS RowCnt FROM ProductOptionValue" connection="Iceland" type="replace" use="raw"/>
  60.                     </query>
  61.                     <query id="Promos" default="false">
  62.                         <select name="SELECT COUNT(*) AS RowCnt FROM Promo" connection="Iceland" type="replace" use="raw"/>
  63.                     </query>
  64.                     <query id="PromoSets" default="false">
  65.                         <select name="SELECT COUNT(*) AS RowCnt FROM Promoset" connection="Iceland" type="replace" use="raw"/>
  66.                     </query>
  67.                     <query id="RelatedProductInProducts" default="false">
  68.                         <select name="SELECT COUNT(*) AS RowCnt FROM RelatedProductInProduct" connection="Iceland" type="replace" use="raw"/>
  69.                     </query>
  70.                     <query id="SelectableAttributeInProdGroups" default="false">
  71.                         <select name="SELECT COUNT(*) AS RowCnt FROM SelectableAttributeInProdGroup" connection="Iceland" type="replace" use="raw"/>
  72.                     </query>
  73.                     <query id="StoreGroups" default="false">
  74.                         <select name="SELECT COUNT(*) AS RowCnt FROM StoreGroup" connection="Iceland" type="replace" use="raw"/>
  75.                     </query>
  76.                     <query id="SubstituteProductInProducts" default="false">
  77.                         <select name="SELECT COUNT(*) AS RowCnt FROM SubstituteProductInProduct" connection="Iceland" type="replace" use="raw"/>
  78.                     </query>
  79.                     <query id="Units" default="false">
  80.                         <select name="SELECT COUNT(*) AS RowCnt FROM Unit" connection="Iceland" type="replace" use="raw"/>
  81.                     </query>
  82.                     <query id="UnitGroups" default="false">
  83.                         <select name="SELECT COUNT(*) AS RowCnt FROM UnitGroup" connection="Iceland" type="replace" use="raw"/>
  84.                     </query>
  85.                 </datasource>
  86.                 <properties>
  87.                     <property name="RowCnt" alias="RowCnt" datatype="integer" nullable="false"/>
  88.                 </properties>
  89.                 <relationships>
  90.                     <relationship name="Store" collection="true" keyprop="none" object="StoreCount" query="Store">
  91.                         <key fkey="StoreID" pkey="StoreID" to="child" from="parent"/>
  92.                     </relationship>
  93.                     <relationship name="Stores" collection="true" keyprop="none" object="StoreCount" query="Stores"/>
  94.                     <relationship name="Attributes" collection="false" keyprop="none" object="Count" query="Attributes"/>
  95.                     <relationship name="AttributeGroups" collection="false" keyprop="none" object="Count" query="AttributeGroups"/>
  96.                     <relationship name="AttributeMaps" collection="false" keyprop="none" object="Count" query="AttributeMaps"/>
  97.                     <relationship name="Barcodes" collection="false" keyprop="none" object="Count" query="Barcodes"/>
  98.                     <relationship name="Campaigns" collection="false" keyprop="none" object="Count" query="Campaigns"/>
  99.                     <relationship name="Categories" collection="false" keyprop="none" object="Count" query="Categories"/>
  100.                     <relationship name="Parameters" collection="false" keyprop="none" object="Count" query="Parameters"/>
  101.                     <relationship name="PriceChanges" collection="false" keyprop="none" object="Count" query="PriceChanges"/>
  102.                     <relationship name="Products" collection="false" keyprop="none" object="Count" query="Products"/>
  103.                     <relationship name="ProductAttributeValues" collection="false" keyprop="none" object="Count" query="ProductAttributeValues"/>
  104.                     <relationship name="ProductGroups" collection="false" keyprop="none" object="Count" query="ProductGroups"/>
  105.                     <relationship name="ProductInCategories" collection="false" keyprop="none" object="Count" query="ProductInCategories"/>
  106.                     <relationship name="ProductInPromosets" collection="false" keyprop="none" object="Count" query="ProductInPromosets"/>
  107.                     <relationship name="ProductOptions" collection="false" keyprop="none" object="Count" query="ProductOptions"/>
  108.                     <relationship name="ProductOptionValues" collection="false" keyprop="none" object="Count" query="ProductOptionValues"/>
  109.                     <relationship name="Promos" collection="false" keyprop="none" object="Count" query="Promos"/>
  110.                     <relationship name="Promosets" collection="false" keyprop="none" object="Count" query="Promosets"/>
  111.                     <relationship name="RelatedProductInProducts" collection="false" keyprop="none" object="Count" query="RelatedProductInProducts"/>
  112.                     <relationship name="SelectableAttributeInProdGroups" collection="false" keyprop="none" object="Count" query="SelectableAttributeInProdGroups"/>
  113.                     <relationship name="StoreGroups" collection="false" keyprop="none" object="Count" query="StoreGroups"/>
  114.                     <relationship name="SubstituteProductInProducts" collection="false" keyprop="none" object="Count" query="SubstituteProductInProducts"/>
  115.                     <relationship name="Units" collection="false" keyprop="none" object="Count" query="Units"/>
  116.                     <relationship name="UnitGroups" collection="false" keyprop="none" object="Count" query="UnitGroups"/>
  117.                 </relationships>
  118.             </object>
  119.             <object name="StoreCount">
  120.                 <datasource>
  121.                     <query id="Store" default="true">
  122.                         <select name="SELECT StoreID, 1 AS RowCnt FROM Store WHERE StoreID=@StoreID" connection="Iceland" type="replace" use="raw">
  123.                             <parameter name="StoreID" datatype="integer" direction="in"/>
  124.                         </select>
  125.                     </query>
  126.                     <query id="Stores" default="true">
  127.                         <select name="SELECT StoreID, 1 AS RowCnt FROM Store" connection="Iceland" type="replace" use="raw"/>
  128.                     </query>
  129.                     <query id="ProductInStore" default="false">
  130.                         <select name="SELECT COUNT(*) AS RowCnt FROM ProductInStore WHERE StoreID=@StoreID" connection="Iceland" type="replace" use="raw">
  131.                             <parameter name="StoreID" datatype="integer" direction="in"/>
  132.                         </select>
  133.                     </query>
  134.                     <query id="PromoInStore" default="false">
  135.                         <select name="SELECT COUNT(*) AS RowCnt FROM PromoInStore WHERE StoreID=@StoreID" connection="Iceland" type="replace" use="raw">
  136.                             <parameter name="StoreID" datatype="integer" direction="in"/>
  137.                         </select>
  138.                     </query>
  139.                     <query id="CategoryInStore" default="false">
  140.                         <select name="SELECT COUNT(*) AS RowCnt FROM CategoryInStore WHERE StoreID=@StoreID" connection="Iceland" type="replace" use="raw">
  141.                             <parameter name="StoreID" datatype="integer" direction="in"/>
  142.                         </select>
  143.                     </query>
  144.                 </datasource>
  145.                 <properties>
  146.                     <property name="RowCnt" alias="RowCnt" datatype="integer" nullable="false"/>
  147.                     <property name="StoreID" alias="StoreID" datatype="integer" nullable="false"/>
  148.                 </properties>
  149.                 <relationships>
  150.                     <relationship object="StoreCount" name="ProductInStore" keyprop="down" collection="false" query="ProductInStore">
  151.                         <key fkey="StoreID" pkey="StoreID" to="child" from="parent"/>
  152.                     </relationship>
  153.                     <relationship object="StoreCount" name="PromoInStore" keyprop="down" collection="false" query="PromoInStore">
  154.                         <key fkey="StoreID" pkey="StoreID" to="child" from="parent"/>
  155.                     </relationship>
  156.                     <relationship object="StoreCount" name="CategoryInStore" keyprop="down" collection="false" query="CategoryInStore">
  157.                         <key fkey="StoreID" pkey="StoreID" to="child" from="parent"/>
  158.                     </relationship>
  159.                 </relationships>
  160.             </object>
  161.             <!-- Revision set -->
  162.             <object name="Attribute">
  163.                 <dcserver dc="IcelandRevisions" enable="true"/>
  164.                 <datasource>
  165.                     <query id="RS" default="true">
  166.                         <select name="Attribute" connection="Iceland" type="table" use="dcserver"/>
  167.                         <select name="Attribute" connection="Iceland" type="table" use="raw"/>
  168.                         <insert name="Attribute" connection="Iceland" type="table" use="raw"/>
  169.                         <update name="Attribute" connection="Iceland" type="table" use="raw"/>
  170.                         <delete name="Attribute" connection="Iceland" type="table" use="raw"/>
  171.                     </query>
  172.                 </datasource>
  173.                 <properties>
  174.                     <property name="AttributeID" alias="AttributeID" datatype="long" pkey="true"/>
  175.                     <property name="AttributeGroupID" alias="AttributeGroupID" datatype="long"/>
  176.                     <property name="Name" alias="Name" datatype="string"/>
  177.                     <property name="SortValue" alias="SortValue" datatype="short"/>
  178.                     <property name="IsAllowedInList" alias="IsAllowedInList" datatype="boolean"/>
  179.                     <property name="Revision" nullable="true" datatype="integer"/>
  180.                 </properties>
  181.                 <relationships>
  182.                     <relationship name="Revisions" object="Attribute" collection="true" keyprop="none" query="RS"/>
  183.                 </relationships>
  184.             </object>
  185.             <object name="AttributeGroup">
  186.                 <dcserver dc="IcelandRevisions" enable="true"/>
  187.                 <datasource>
  188.                     <query id="RS" default="true">
  189.                         <select name="AttributeGroup" connection="Iceland" type="table" use="dcserver"/>
  190.                         <select name="AttributeGroup" connection="Iceland" type="table" use="raw"/>
  191.                         <insert name="AttributeGroup" connection="Iceland" type="table" use="raw"/>
  192.                         <update name="AttributeGroup" connection="Iceland" type="table" use="raw"/>
  193.                         <delete name="AttributeGroup" connection="Iceland" type="table" use="raw"/>
  194.                     </query>
  195.                 </datasource>
  196.                 <properties>
  197.                     <property name="AttributeGroupID" alias="AttributeGroupID" datatype="long" pkey="true"/>
  198.                     <property name="Name" alias="Name" datatype="string"/>
  199.                     <property name="AttributeMapID" alias="AttributeMapID" datatype="long"/>
  200.                     <property name="Revision" nullable="true" datatype="integer"/>
  201.                 </properties>
  202.                 <relationships>
  203.                     <relationship name="Revisions" object="AttributeGroup" collection="true" keyprop="none" query="RS"/>
  204.                 </relationships>
  205.             </object>
  206.             <object name="AttributeMap">
  207.                 <dcserver dc="IcelandRevisions" enable="true"/>
  208.                 <datasource>
  209.                     <query id="RS" default="true">
  210.                         <select name="AttributeMap" connection="Iceland" type="table" use="dcserver"/>
  211.                         <select name="AttributeMap" connection="Iceland" type="table" use="raw"/>
  212.                         <insert name="AttributeMap" connection="Iceland" type="table" use="raw"/>
  213.                         <update name="AttributeMap" connection="Iceland" type="table" use="raw"/>
  214.                         <delete name="AttributeMap" connection="Iceland" type="table" use="raw"/>
  215.                     </query>
  216.                 </datasource>
  217.                 <properties>
  218.                     <property name="AttributeMapID" alias="AttributeMapID" datatype="long" pkey="true"/>
  219.                     <property name="AttributeMapName" alias="AttributeMapName" datatype="string"/>
  220.                     <property name="Revision" nullable="true" datatype="integer"/>
  221.                 </properties>
  222.                 <relationships>
  223.                     <relationship name="Revisions" object="AttributeMap" collection="true" keyprop="none" query="RS"/>
  224.                 </relationships>
  225.             </object>
  226.             <object name="Barcode">
  227.                 <dcserver dc="IcelandRevisions" enable="true"/>
  228.                 <datasource>
  229.                     <query id="RS" default="true">
  230.                         <select name="Barcode" connection="Iceland" type="table" use="dcserver"/>
  231.                         <select name="Barcode" connection="Iceland" type="table" use="raw"/>
  232.                         <insert name="Barcode" connection="Iceland" type="table" use="raw"/>
  233.                         <update name="Barcode" connection="Iceland" type="table" use="raw"/>
  234.                         <delete name="Barcode" connection="Iceland" type="table" use="raw"/>
  235.                     </query>
  236.                 </datasource>
  237.                 <properties>
  238.                     <property name="Barcode" alias="Barcode" datatype="string" pkey="true"/>
  239.                     <property name="ProductID" alias="ProductID" datatype="long" pkey="true"/>
  240.                     <property name="Revision" nullable="true" datatype="integer"/>
  241.                 </properties>
  242.                 <relationships>
  243.                     <relationship name="Revisions" object="Barcode" collection="true" keyprop="none" query="RS"/>
  244.                 </relationships>
  245.             </object>
  246.             <object name="Campaign">
  247.                 <dcserver dc="IcelandRevisions" enable="true"/>
  248.                 <datasource>
  249.                     <query id="RS" default="true">
  250.                         <select name="Campaign" connection="Iceland" type="table" use="dcserver"/>
  251.                         <select name="Campaign" connection="Iceland" type="table" use="raw"/>
  252.                         <insert name="Campaign" connection="Iceland" type="table" use="raw"/>
  253.                         <update name="Campaign" connection="Iceland" type="table" use="raw"/>
  254.                         <delete name="Campaign" connection="Iceland" type="table" use="raw"/>
  255.                     </query>
  256.                 </datasource>
  257.                 <properties>
  258.                     <property name="CampaignID" alias="CampaignID" datatype="long" pkey="true"/>
  259.                     <property name="Description" alias="Description" datatype="string"/>
  260.                     <property name="Revision" nullable="true" datatype="integer"/>
  261.                 </properties>
  262.                 <relationships>
  263.                     <relationship name="Revisions" object="Campaign" collection="true" keyprop="none" query="RS"/>
  264.                 </relationships>
  265.             </object>
  266.             <object name="Category">
  267.                 <dcserver dc="IcelandRevisions" enable="true"/>
  268.                 <datasource>
  269.                     <query id="RS" default="true">
  270.                         <select name="Category" connection="Iceland" type="table" use="dcserver"/>
  271.                         <select name="Category" connection="Iceland" type="table" use="raw"/>
  272.                         <insert name="Category" connection="Iceland" type="table" use="raw"/>
  273.                         <update name="Category" connection="Iceland" type="table" use="raw"/>
  274.                         <delete name="Category" connection="Iceland" type="table" use="raw"/>
  275.                     </query>
  276.                 </datasource>
  277.                 <properties>
  278.                     <property name="CategoryID" alias="CategoryID" datatype="long" pkey="true"/>
  279.                     <property name="Name" alias="Name" datatype="string"/>
  280.                     <property name="ParentID" alias="ParentID" datatype="long"/>
  281.                     <property name="LevelNo" alias="LevelNo" datatype="short"/>
  282.                     <property name="IsLeaf" alias="IsLeaf" datatype="boolean"/>
  283.                     <property name="TopLevelID" alias="TopLevelID" datatype="long"/>
  284.                     <property name="ColorCode" alias="ColorCode" datatype="string"/>
  285.                     <property name="SortOrder" alias="SortOrder" datatype="long"/>
  286.                     <property name="Revision" nullable="true" datatype="integer"/>
  287.                 </properties>
  288.                 <relationships>
  289.                     <relationship name="Revisions" object="Category" collection="true" keyprop="none" query="RS"/>
  290.                 </relationships>
  291.             </object>
  292.             <object name="CategoryInStore">
  293.                 <dcserver dc="IcelandRevisions" enable="true"/>
  294.                 <datasource>
  295.                     <query id="RS" default="false">
  296.                         <select name="CategoryInStore" connection="Iceland" type="table" use="dcserver"/>
  297.                         <select name="CategoryInStore" connection="Iceland" type="table" use="raw"/>
  298.                         <insert name="CategoryInStore" connection="Iceland" type="table" use="raw"/>
  299.                         <update name="CategoryInStore" connection="Iceland" type="table" use="raw"/>
  300.                         <delete name="CategoryInStore" connection="Iceland" type="table" use="raw"/>
  301.                     </query>
  302.                 </datasource>
  303.                 <properties>
  304.                     <property name="StoreID" alias="StoreID" datatype="long" pkey="true"/>
  305.                     <property name="CategoryID" alias="CategoryID" datatype="long" pkey="true"/>
  306.                     <property name="Revision" alias="Revision" nullable="true" datatype="integer"/>
  307.                 </properties>
  308.                 <relationships>
  309.                     <!--<relationship name="Revisions" object="CategoryInStore" collection="true" keyprop="none" query="RS"/>-->
  310.                 </relationships>
  311.             </object>
  312.             <object name="Parameter">
  313.                 <dcserver dc="IcelandRevisions" enable="true"/>
  314.                 <datasource>
  315.                     <query id="RS" default="true">
  316.                         <select name="Parameter" connection="Iceland" type="table" use="dcserver"/>
  317.                         <select name="Parameter" connection="Iceland" type="table" use="raw"/>
  318.                         <insert name="Parameter" connection="Iceland" type="table" use="raw"/>
  319.                         <update name="Parameter" connection="Iceland" type="table" use="raw"/>
  320.                         <delete name="Parameter" connection="Iceland" type="table" use="raw"/>
  321.                     </query>
  322.                 </datasource>
  323.                 <properties>
  324.                     <property name="ParameterID" alias="ParameterID" datatype="long" pkey="true"/>
  325.                     <property name="Name" alias="Name" datatype="string"/>
  326.                     <property name="ParameterValue" alias="ParameterValue" datatype="string"/>
  327.                     <property name="Revision" nullable="true" datatype="integer"/>
  328.                 </properties>
  329.                 <relationships>
  330.                     <relationship name="Revisions" object="Parameter" collection="true" keyprop="none" query="RS"/>
  331.                 </relationships>
  332.             </object>
  333.             <object name="PostcodeZone">
  334.                 <dcserver dc="IcelandRevisions" enable="true"/>
  335.                 <datasource>
  336.                     <query id="RS" default="true">
  337.                         <select name="PostcodeZone" connection="Iceland" type="table" use="dcserver"/>
  338.                         <select name="PostcodeZone" connection="Iceland" type="table" use="raw"/>
  339.                         <insert name="PostcodeZone" connection="Iceland" type="table" use="raw"/>
  340.                         <update name="PostcodeZone" connection="Iceland" type="table" use="raw"/>
  341.                         <delete name="PostcodeZone" connection="Iceland" type="table" use="raw"/>
  342.                     </query>
  343.                 </datasource>
  344.                 <properties>
  345.                     <property name="Postcode" alias="Postcode" datatype="string" pkey="true"/>
  346.                     <property name="ZoneID" alias="ZoneID" datatype="long"/>
  347.                     <property name="Revision" nullable="true" datatype="integer"/>
  348.                 </properties>
  349.                 <relationships>
  350.                     <relationship name="Revisions" object="PostcodeZone" collection="true" keyprop="none" query="RS"/>
  351.                 </relationships>
  352.             </object>
  353.             <object name="PriceChange">
  354.                 <dcserver dc="IcelandRevisions" enable="true"/>
  355.                 <datasource>
  356.                     <query id="RS" default="true">
  357.                         <select name="PriceChange" connection="Iceland" type="table" use="dcserver"/>
  358.                         <select name="PriceChange" connection="Iceland" type="table" use="raw"/>
  359.                         <insert name="PriceChange" connection="Iceland" type="table" use="raw"/>
  360.                         <update name="PriceChange" connection="Iceland" type="table" use="raw"/>
  361.                         <delete name="PriceChange" connection="Iceland" type="table" use="raw"/>
  362.                     </query>
  363.                 </datasource>
  364.                 <properties>
  365.                     <property name="PriceChangeID" alias="PriceChangeID" datatype="long" pkey="true"/>
  366.                     <property name="PriceChangeDate" alias="PriceChangeDate" datatype="date"/>
  367.                     <property name="Revision" nullable="true" datatype="integer"/>
  368.                 </properties>
  369.                 <relationships>
  370.                     <relationship name="Revisions" object="PriceChange" collection="true" keyprop="none" query="RS"/>
  371.                 </relationships>
  372.             </object>
  373.             <object name="Product">
  374.                 <dcserver dc="IcelandRevisions" enable="true"/>
  375.                 <datasource>
  376.                     <query id="RS" default="true">
  377.                         <select name="Product" connection="Iceland" type="table" use="dcserver"/>
  378.                         <select name="Product" connection="Iceland" type="table" use="raw"/>
  379.                         <insert name="Product" connection="Iceland" type="table" use="raw"/>
  380.                         <update name="Product" connection="Iceland" type="table" use="raw"/>
  381.                         <delete name="Product" connection="Iceland" type="table" use="raw"/>
  382.                     </query>
  383.                 </datasource>
  384.                 <properties>
  385.                     <property name="ProductID" alias="ProductID" datatype="long" pkey="true"/>
  386.                     <property name="ProductGroupID" alias="ProductGroupID" datatype="long" nullable="true"/>
  387.                     <property name="Name" alias="Name" datatype="string"/>
  388.                     <property name="Description" alias="Description" datatype="string" nullable="true"/>
  389.                     <property name="PackSize" alias="PackSize" datatype="short"/>
  390.                     <property name="UnitSize" alias="UnitSize" datatype="double" nullable="true"/>
  391.                     <property name="UnitID" alias="UnitID" datatype="long"/>
  392.                     <property name="IsUnitSelectable" alias="IsUnitSelectable" datatype="boolean"/>
  393.                     <property name="ProductCode" alias="ProductCode" datatype="string" nullable="true"/>
  394.                     <property name="CaseDealParentID" alias="CaseDealParentID" datatype="long" nullable="true"/>
  395.                     <property name="HasLabelData" alias="hasLabelData" datatype="boolean" nullable="false"/>
  396.                     <property name="Revision" nullable="true" datatype="integer"/>
  397.                 </properties>
  398.                 <relationships>
  399.                     <relationship name="Revisions" object="Product" collection="true" keyprop="none" query="RS"/>
  400.                 </relationships>
  401.             </object>
  402.             <object name="ProductAttributeValue">
  403.                 <dcserver dc="IcelandRevisions" enable="true"/>
  404.                 <datasource>
  405.                     <query id="RS" default="true">
  406.                         <select name="ProductAttributeValue" connection="Iceland" type="table" use="dcserver"/>
  407.                         <select name="ProductAttributeValue" connection="Iceland" type="table" use="raw"/>
  408.                         <insert name="ProductAttributeValue" connection="Iceland" type="table" use="raw"/>
  409.                         <update name="ProductAttributeValue" connection="Iceland" type="table" use="raw"/>
  410.                         <delete name="ProductAttributeValue" connection="Iceland" type="table" use="raw"/>
  411.                     </query>
  412.                 </datasource>
  413.                 <properties>
  414.                     <property name="PAVID" alias="PAVID" datatype="long" pkey="true"/>
  415.                     <property name="ProductID" alias="ProductID" datatype="long"/>
  416.                     <property name="AttributeID" alias="AttributeID" datatype="long"/>
  417.                     <property name="AttributeValue" alias="AttributeValue" datatype="string"/>
  418.                     <property name="UnitID" alias="UnitID" datatype="long" nullable="true"/>
  419.                     <property name="OrderNumber" alias="OrderNumber" datatype="long"/>
  420.                     <property name="PartName" alias="PartName" datatype="string" nullable="true"/>
  421.                     <property name="ColumnNumber" alias="ColumnNumber" datatype="long" nullable="true"/>
  422.                     <property name="Revision" nullable="true" datatype="integer"/>
  423.                 </properties>
  424.                 <relationships>
  425.                     <relationship name="Revisions" object="ProductAttributeValue" collection="true" keyprop="none" query="RS"/>
  426.                 </relationships>
  427.             </object>
  428.             <object name="ProductGroup">
  429.                 <dcserver dc="IcelandRevisions" enable="true"/>
  430.                 <datasource>
  431.                     <query id="RS" default="true">
  432.                         <select name="ProductGroup" connection="Iceland" type="table" use="dcserver"/>
  433.                         <select name="ProductGroup" connection="Iceland" type="table" use="raw"/>
  434.                         <insert name="ProductGroup" connection="Iceland" type="table" use="raw"/>
  435.                         <update name="ProductGroup" connection="Iceland" type="table" use="raw"/>
  436.                         <delete name="ProductGroup" connection="Iceland" type="table" use="raw"/>
  437.                     </query>
  438.                 </datasource>
  439.                 <properties>
  440.                     <property name="ProductGroupID" alias="ProductGroupID" datatype="long" pkey="true"/>
  441.                     <property name="Name" alias="Name" datatype="string"/>
  442.                     <property name="Revision" nullable="true" datatype="integer"/>
  443.                 </properties>
  444.                 <relationships>
  445.                     <relationship name="Revisions" object="ProductGroup" collection="true" keyprop="none" query="RS"/>
  446.                 </relationships>
  447.             </object>
  448.             <object name="ProductInCategory">
  449.                 <dcserver dc="IcelandRevisions" enable="true"/>
  450.                 <datasource>
  451.                     <query id="RS" default="true">
  452.                         <select name="ProductInCategory" connection="Iceland" type="table" use="dcserver"/>
  453.                         <select name="ProductInCategory" connection="Iceland" type="table" use="raw"/>
  454.                         <insert name="ProductInCategory" connection="Iceland" type="table" use="raw"/>
  455.                         <update name="ProductInCategory" connection="Iceland" type="table" use="raw"/>
  456.                         <delete name="ProductInCategory" connection="Iceland" type="table" use="raw"/>
  457.                     </query>
  458.                 </datasource>
  459.                 <properties>
  460.                     <property name="CategoryID" alias="CategoryID" datatype="long" pkey="true"/>
  461.                     <property name="ProductID" alias="ProductID" datatype="long" pkey="true"/>
  462.                     <property name="Revision" nullable="true" datatype="integer"/>
  463.                 </properties>
  464.                 <relationships>
  465.                     <relationship name="Revisions" object="ProductInCategory" collection="true" keyprop="none" query="RS"/>
  466.                 </relationships>
  467.             </object>
  468.             <object name="ProductInPromoSet">
  469.                 <dcserver dc="IcelandRevisions" enable="true"/>
  470.                 <datasource>
  471.                     <query id="RS" default="true">
  472.                         <select name="ProductInPromoSet" connection="Iceland" type="table" use="dcserver"/>
  473.                         <select name="ProductInPromoSet" connection="Iceland" type="table" use="raw"/>
  474.                         <insert name="ProductInPromoSet" connection="Iceland" type="table" use="raw"/>
  475.                         <update name="ProductInPromoSet" connection="Iceland" type="table" use="raw"/>
  476.                         <delete name="ProductInPromoSet" connection="Iceland" type="table" use="raw"/>
  477.                     </query>
  478.                 </datasource>
  479.                 <properties>
  480.                     <property name="PromoSetID" alias="PromoSetID" datatype="long" pkey="true"/>
  481.                     <property name="ProductID" alias="ProductID" datatype="long" pkey="true"/>
  482.                     <property name="Revision" nullable="true" datatype="integer"/>
  483.                 </properties>
  484.                 <relationships>
  485.                     <relationship name="Revisions" object="ProductInPromoSet" collection="true" keyprop="none" query="RS"/>
  486.                 </relationships>
  487.             </object>
  488.             <object name="ProductInStore">
  489.                 <dcserver dc="IcelandRevisions" enable="true"/>
  490.                 <datasource>
  491.                     <query id="RS" default="false">
  492.                         <select name="ProductInStore" connection="Iceland" type="table" use="dcserver"/>
  493.                         <select name="ProductInStore" connection="Iceland" type="table" use="raw"/>
  494.                         <insert name="ProductInStore" connection="Iceland" type="table" use="raw"/>
  495.                         <update name="ProductInStore" connection="Iceland" type="table" use="raw"/>
  496.                         <delete name="ProductInStore" connection="Iceland" type="table" use="raw"/>
  497.                     </query>
  498.                 </datasource>
  499.                 <properties>
  500.                     <property name="StoreID" alias="StoreID" datatype="long" pkey="true"/>
  501.                     <property name="ProductID" alias="ProductID" datatype="long" pkey="true"/>
  502.                     <property name="Price" alias="Price" datatype="currency"/>
  503.                     <property name="IntroductionDate" alias="IntroductionDate" datatype="date" pkey="true"/>
  504.                     <property name="ComparativeSizeInfo" alias="ComparativeSizeInfo" datatype="string"/>
  505.                     <property name="IsNew" alias="IsNew" datatype="boolean"/>
  506.                     <property name="Saving" alias="Saving" datatype="currency" nullable="true"/>
  507.                     <property name="AddedVal" alias="AddedVal" datatype="string" nullable="true"/>
  508.                     <property name="IsCaseDealParent" alias="IsCaseDealParent" datatype="boolean" nullable="false"/>
  509.                     <property name="CaseDealSaving" alias="CaseDealSaving" datatype="long" nullable="true"/>
  510.                     <property name="CaseDealImageID" alias="CaseDealImageID" datatype="string" nullable="true"/>
  511.                     <property name="Revision" alias="Revision" datatype="integer" nullable="true"/>
  512.                 </properties>
  513.                 <relationships>
  514.                     <!--<relationship name="Revisions" object="ProductInStore" collection="true" keyprop="none" query="RS"/>-->
  515.                 </relationships>
  516.             </object>
  517.             <object name="ProductOption">
  518.                 <dcserver dc="IcelandRevisions" enable="true"/>
  519.                 <datasource>
  520.                     <query id="RS" default="true">
  521.                         <select name="ProductOption" connection="Iceland" type="table" use="dcserver"/>
  522.                         <select name="ProductOption" connection="Iceland" type="table" use="raw"/>
  523.                         <insert name="ProductOption" connection="Iceland" type="table" use="raw"/>
  524.                         <update name="ProductOption" connection="Iceland" type="table" use="raw"/>
  525.                         <delete name="ProductOption" connection="Iceland" type="table" use="raw"/>
  526.                     </query>
  527.                 </datasource>
  528.                 <properties>
  529.                     <property name="ProductOptionID" alias="ProductOptionID" datatype="long" pkey="true"/>
  530.                     <property name="Name" alias="Name" datatype="string"/>
  531.                     <property name="SortValue" alias="SortValue" datatype="short"/>
  532.                     <property name="Revision" nullable="true" datatype="integer"/>
  533.                 </properties>
  534.                 <relationships>
  535.                     <relationship name="Revisions" object="ProductOption" collection="true" keyprop="none" query="RS"/>
  536.                 </relationships>
  537.             </object>
  538.             <object name="ProductOptionValue">
  539.                 <dcserver dc="IcelandRevisions" enable="true"/>
  540.                 <datasource>
  541.                     <query id="RS" default="true">
  542.                         <select name="ProductOptionValue" connection="Iceland" type="table" use="dcserver"/>
  543.                         <select name="ProductOptionValue" connection="Iceland" type="table" use="raw"/>
  544.                         <insert name="ProductOptionValue" connection="Iceland" type="table" use="raw"/>
  545.                         <update name="ProductOptionValue" connection="Iceland" type="table" use="raw"/>
  546.                         <delete name="ProductOptionValue" connection="Iceland" type="table" use="raw"/>
  547.                     </query>
  548.                 </datasource>
  549.                 <properties>
  550.                     <property name="ProductID" alias="ProductID" datatype="long" pkey="true"/>
  551.                     <property name="ProductOptionID" alias="ProductOptionID" datatype="long" pkey="true"/>
  552.                     <property name="SortValue" alias="SortValue" datatype="short"/>
  553.                     <property name="OptionValue" alias="OptionValue" datatype="string"/>
  554.                     <property name="IsDefault" alias="IsDefault" datatype="boolean"/>
  555.                     <property name="Revision" nullable="true" datatype="integer"/>
  556.                 </properties>
  557.                 <relationships>
  558.                     <relationship name="Revisions" object="ProductOptionValue" collection="true" keyprop="none" query="RS"/>
  559.                 </relationships>
  560.             </object>
  561.             <object name="Promo">
  562.                 <dcserver dc="IcelandRevisions" enable="true"/>
  563.                 <datasource>
  564.                     <query id="RS" default="true">
  565.                         <select name="Promo" connection="Iceland" type="table" use="dcserver"/>
  566.                         <select name="Promo" connection="Iceland" type="table" use="raw"/>
  567.                         <insert name="Promo" connection="Iceland" type="table" use="raw"/>
  568.                         <update name="Promo" connection="Iceland" type="table" use="raw"/>
  569.                         <delete name="Promo" connection="Iceland" type="table" use="raw"/>
  570.                     </query>
  571.                 </datasource>
  572.                 <properties>
  573.                     <property name="PromoID" alias="PromoID" datatype="long" pkey="true"/>
  574.                     <property name="PromoType" alias="PromoType" datatype="long"/>
  575.                     <property name="ImageID" alias="ImageID" datatype="long"/>
  576.                     <property name="Description" alias="Description" datatype="string"/>
  577.                     <property name="StartDate" alias="StartDate" datatype="date"/>
  578.                     <property name="EndDate" alias="EndDate" datatype="date"/>
  579.                     <property name="LoyaltyClubOnly" alias="LoyaltyClubOnly" datatype="boolean"/>
  580.                     <property name="IsOneTime" alias="IsOneTime" datatype="boolean"/>
  581.                     <property name="Revision" nullable="true" datatype="integer"/>
  582.                 </properties>
  583.                 <relationships>
  584.                     <relationship name="Revisions" object="Promo" collection="true" keyprop="none" query="RS"/>
  585.                 </relationships>
  586.             </object>
  587.             <object name="PromoInStore">
  588.                 <dcserver dc="IcelandRevisions" enable="true"/>
  589.                 <datasource>
  590.                     <query id="RS" default="false">
  591.                         <select name="PromoInStore" connection="Iceland" type="table" use="dcserver"/>
  592.                         <select name="PromoInStore" connection="Iceland" type="table" use="raw"/>
  593.                         <insert name="PromoInStore" connection="Iceland" type="table" use="raw"/>
  594.                         <update name="PromoInStore" connection="Iceland" type="table" use="raw"/>
  595.                         <delete name="PromoInStore" connection="Iceland" type="table" use="raw"/>
  596.                     </query>
  597.                 </datasource>
  598.                 <properties>
  599.                     <property name="StoreID" alias="StoreID" datatype="long" pkey="true"/>
  600.                     <property name="PromoID" alias="PromoID" datatype="long" pkey="true"/>
  601.                     <property name="Revision" alias="Revision" nullable="true" datatype="integer"/>
  602.                 </properties>
  603.                 <relationships>
  604.                     <relationship name="Revisions" object="PromoInStore" collection="true" keyprop="none" query="RS"/>
  605.                 </relationships>
  606.             </object>
  607.             <object name="PromoSet">
  608.                 <dcserver dc="IcelandRevisions" enable="true"/>
  609.                 <datasource>
  610.                     <query id="RS" default="true">
  611.                         <select name="PromoSet" connection="Iceland" type="table" use="dcserver"/>
  612.                         <select name="PromoSet" connection="Iceland" type="table" use="raw"/>
  613.                         <insert name="PromoSet" connection="Iceland" type="table" use="raw"/>
  614.                         <update name="PromoSet" connection="Iceland" type="table" use="raw"/>
  615.                         <delete name="PromoSet" connection="Iceland" type="table" use="raw"/>
  616.                     </query>
  617.                 </datasource>
  618.                 <properties>
  619.                     <property name="PromoSetID" alias="PromoSetID" datatype="long" pkey="true"/>
  620.                     <property name="PromoID" alias="PromoID" datatype="long"/>
  621.                     <property name="Quantity" alias="Quantity" datatype="double" nullable="true"/>
  622.                     <property name="MaxQuantity" alias="MaxQuantity" datatype="double" nullable="true"/>
  623.                     <property name="LoyaltyPointsReward" alias="LoyaltyPointsReward" datatype="long" nullable="true"/>
  624.                     <property name="Reduction" alias="Reduction" datatype="currency" nullable="true"/>
  625.                     <property name="DiscountQuantity" alias="DiscountQuantity" datatype="long" nullable="true"/>
  626.                     <property name="Discount" alias="Discount" datatype="double" nullable="true"/>
  627.                     <property name="CostThreshold" alias="CostThreshold" datatype="currency" nullable="true"/>
  628.                     <property name="CostMultiplier" alias="CostMultiplier" datatype="currency" nullable="true"/>
  629.                     <property name="CostFrom" alias="CostFrom" datatype="currency" nullable="true"/>
  630.                     <property name="CostTo" alias="CostTo" datatype="string" nullable="true"/>
  631.                     <property name="CouponPromoID" alias="CouponPromoID" datatype="long" nullable="true"/>
  632.                     <property name="Revision" nullable="true" datatype="integer"/>
  633.                 </properties>
  634.                 <relationships>
  635.                     <relationship name="Revisions" object="PromoSet" collection="true" keyprop="none" query="RS"/>
  636.                 </relationships>
  637.             </object>
  638.             <object name="RelatedProductInProduct">
  639.                 <dcserver dc="IcelandRevisions" enable="true"/>
  640.                 <datasource>
  641.                     <query id="RS" default="true">
  642.                         <select name="RelatedProductInProduct" connection="Iceland" type="table" use="dcserver"/>
  643.                         <select name="RelatedProductInProduct" connection="Iceland" type="table" use="raw"/>
  644.                         <insert name="RelatedProductInProduct" connection="Iceland" type="table" use="raw"/>
  645.                         <update name="RelatedProductInProduct" connection="Iceland" type="table" use="raw"/>
  646.                         <delete name="RelatedProductInProduct" connection="Iceland" type="table" use="raw"/>
  647.                     </query>
  648.                 </datasource>
  649.                 <properties>
  650.                     <property name="ProductID" alias="ProductID" datatype="long" pkey="true"/>
  651.                     <property name="RelatedProductID" alias="RelatedProductID" datatype="long" pkey="true"/>
  652.                     <property name="Revision" nullable="true" datatype="integer"/>
  653.                 </properties>
  654.                 <relationships>
  655.                     <relationship name="Revisions" object="RelatedProductInProduct" collection="true" keyprop="none" query="RS"/>
  656.                 </relationships>
  657.             </object>
  658.             <object name="SelectableAttributeInProdGroup">
  659.                 <dcserver dc="IcelandRevisions" enable="true"/>
  660.                 <datasource>
  661.                     <query id="RS" default="true">
  662.                         <select name="SelectableAttributeInProdGroup" connection="Iceland" type="table" use="dcserver"/>
  663.                         <select name="SelectableAttributeInProdGroup" connection="Iceland" type="table" use="raw"/>
  664.                         <insert name="SelectableAttributeInProdGroup" connection="Iceland" type="table" use="raw"/>
  665.                         <update name="SelectableAttributeInProdGroup" connection="Iceland" type="table" use="raw"/>
  666.                         <delete name="SelectableAttributeInProdGroup" connection="Iceland" type="table" use="raw"/>
  667.                     </query>
  668.                 </datasource>
  669.                 <properties>
  670.                     <property name="ProductGroupID" alias="ProductGroupID" datatype="long" pkey="true"/>
  671.                     <property name="AttributeID" alias="AttributeID" datatype="long" pkey="true"/>
  672.                     <property name="Revision" nullable="true" datatype="integer"/>
  673.                 </properties>
  674.                 <relationships>
  675.                     <relationship name="Revisions" object="SelectableAttributeInProdGroup" collection="true" keyprop="none" query="RS"/>
  676.                 </relationships>
  677.             </object>
  678.             <object name="Store">
  679.                 <dcserver dc="IcelandRevisions" enable="true"/>
  680.                 <datasource>
  681.                     <query id="RS" default="true">
  682.                         <select name="Store" connection="Iceland" type="table" use="dcserver"/>
  683.                         <select name="Store" connection="Iceland" type="table" use="raw"/>
  684.                         <insert name="Store" connection="Iceland" type="table" use="raw"/>
  685.                         <update name="Store" connection="Iceland" type="table" use="raw"/>
  686.                         <delete name="Store" connection="Iceland" type="table" use="raw"/>
  687.                     </query>
  688.                 </datasource>
  689.                 <properties>
  690.                     <property name="StoreID" alias="StoreID" datatype="long" pkey="true"/>
  691.                     <property name="Name" alias="Name" datatype="string"/>
  692.                     <property name="Enabled" alias="Enabled" datatype="boolean"/>
  693.                     <property name="Revision" alias="Revision" nullable="true" datatype="integer"/>
  694.                 </properties>
  695.                 <relationships>
  696.                     <relationship name="Revisions" object="Store" collection="true" keyprop="none" query="RS"/>
  697.                     <relationship name="Products" object="ProductInStore" collection="true" keyprop="down" query="RS">
  698.                         <key pkey="StoreID" fkey="StoreID" from="parent" to="child"/>
  699.                     </relationship>
  700.                     <relationship name="Categories" object="CategoryInStore" collection="true" keyprop="down" query="RS">
  701.                         <key pkey="StoreID" fkey="StoreID" from="parent" to="child"/>
  702.                     </relationship>
  703.                     <relationship name="Promos" object="PromoInStore" collection="true" keyprop="down" query="RS">
  704.                         <key pkey="StoreID" fkey="StoreID" from="parent" to="child"/>
  705.                     </relationship>
  706.                 </relationships>
  707.             </object>
  708.             <object name="StoreGroup">
  709.                 <dcserver dc="IcelandRevisions" enable="true"/>
  710.                 <datasource>
  711.                     <query id="RS" default="true">
  712.                         <select name="StoreGroup" connection="Iceland" type="table" use="dcserver"/>
  713.                         <select name="StoreGroup" connection="Iceland" type="table" use="raw"/>
  714.                         <insert name="StoreGroup" connection="Iceland" type="table" use="raw"/>
  715.                         <update name="StoreGroup" connection="Iceland" type="table" use="raw"/>
  716.                         <delete name="StoreGroup" connection="Iceland" type="table" use="raw"/>
  717.                     </query>
  718.                 </datasource>
  719.                 <properties>
  720.                     <property name="StoreGroupID" alias="StoreGroupID" datatype="long" pkey="true"/>
  721.                     <property name="StoreGroupName" alias="StoreGroupName" datatype="string"/>
  722.                     <property name="ContentPath" alias="ContentPath" datatype="string"/>
  723.                     <property name="AllowProductNotes" alias="AllowProductNotes" datatype="boolean"/>
  724.                     <property name="Revision" nullable="true" datatype="integer"/>
  725.                 </properties>
  726.                 <relationships>
  727.                     <relationship name="Revisions" object="StoreGroup" collection="true" keyprop="none" query="RS"/>
  728.                 </relationships>
  729.             </object>
  730.             <object name="StoreInStoreGroup">
  731.                 <dcserver dc="IcelandRevisions" enable="true"/>
  732.                 <datasource>
  733.                     <query id="RS" default="true">
  734.                         <select name="StoreInStoreGroup" connection="Iceland" type="table" use="dcserver"/>
  735.                         <select name="StoreInStoreGroup" connection="Iceland" type="table" use="raw"/>
  736.                         <insert name="StoreInStoreGroup" connection="Iceland" type="table" use="raw"/>
  737.                         <update name="StoreInStoreGroup" connection="Iceland" type="table" use="raw"/>
  738.                         <delete name="StoreInStoreGroup" connection="Iceland" type="table" use="raw"/>
  739.                     </query>
  740.                 </datasource>
  741.                 <properties>
  742.                     <property name="StoreGroupID" alias="StoreGroupID" datatype="long" pkey="true"/>
  743.                     <property name="StoreID" alias="StoreID" datatype="long" pkey="true"/>
  744.                     <property name="Revision" alias="Revision" nullable="true" datatype="integer"/>
  745.                 </properties>
  746.                 <relationships>
  747.                     <relationship name="Revisions" object="StoreInStoreGroup" collection="true" keyprop="none" query="RS"/>
  748.                 </relationships>
  749.             </object>
  750.             <object name="SubstituteProductInProduct">
  751.                 <dcserver dc="IcelandRevisions" enable="true"/>
  752.                 <datasource>
  753.                     <query id="RS" default="true">
  754.                         <select name="SubstituteProductInProduct" connection="Iceland" type="table" use="dcserver"/>
  755.                         <select name="SubstituteProductInProduct" connection="Iceland" type="table" use="raw"/>
  756.                         <insert name="SubstituteProductInProduct" connection="Iceland" type="table" use="raw"/>
  757.                         <update name="SubstituteProductInProduct" connection="Iceland" type="table" use="raw"/>
  758.                         <delete name="SubstituteProductInProduct" connection="Iceland" type="table" use="raw"/>
  759.                     </query>
  760.                 </datasource>
  761.                 <properties>
  762.                     <property name="ProductID" alias="ProductID" datatype="long" pkey="true"/>
  763.                     <property name="SubstituteProductID" alias="SubstituteProductID" datatype="long" pkey="true"/>
  764.                     <property name="Revision" nullable="true" datatype="integer"/>
  765.                 </properties>
  766.                 <relationships>
  767.                     <relationship name="Revisions" object="SubstituteProductInProduct" collection="true" keyprop="none" query="RS"/>
  768.                 </relationships>
  769.             </object>
  770.             <object name="Unit">
  771.                 <dcserver dc="IcelandRevisions" enable="true"/>
  772.                 <datasource>
  773.                     <query id="RS" default="true">
  774.                         <select name="Unit" connection="Iceland" type="table" use="dcserver"/>
  775.                         <select name="Unit" connection="Iceland" type="table" use="raw"/>
  776.                         <insert name="Unit" connection="Iceland" type="table" use="raw"/>
  777.                         <update name="Unit" connection="Iceland" type="table" use="raw"/>
  778.                         <delete name="Unit" connection="Iceland" type="table" use="raw"/>
  779.                     </query>
  780.                 </datasource>
  781.                 <properties>
  782.                     <property name="UnitID" alias="UnitID" datatype="long" pkey="true"/>
  783.                     <property name="UnitGroupID" alias="UnitGroupID" datatype="long" nullable="true"/>
  784.                     <property name="Name" alias="Name" datatype="string"/>
  785.                     <property name="Description" alias="Description" datatype="string"/>
  786.                     <property name="ConvertRate" alias="ConvertRate" datatype="single"/>
  787.                     <property name="IsInteger" alias="IsInteger" datatype="boolean"/>
  788.                     <property name="Revision" nullable="true" datatype="integer"/>
  789.                 </properties>
  790.                 <relationships>
  791.                     <relationship name="Revisions" object="Unit" collection="true" keyprop="none" query="RS"/>
  792.                 </relationships>
  793.             </object>
  794.             <object name="UnitGroup">
  795.                 <dcserver dc="IcelandRevisions" enable="true"/>
  796.                 <datasource>
  797.                     <query id="RS" default="true">
  798.                         <select name="UnitGroup" connection="Iceland" type="table" use="dcserver"/>
  799.                         <select name="UnitGroup" connection="Iceland" type="table" use="raw"/>
  800.                         <insert name="UnitGroup" connection="Iceland" type="table" use="raw"/>
  801.                         <update name="UnitGroup" connection="Iceland" type="table" use="raw"/>
  802.                         <delete name="UnitGroup" connection="Iceland" type="table" use="raw"/>
  803.                     </query>
  804.                 </datasource>
  805.                 <properties>
  806.                     <property name="UnitGroupID" alias="UnitGroupID" datatype="long" pkey="true"/>
  807.                     <property name="Name" alias="Name" datatype="string"/>
  808.                     <property name="ConvertRateUnitID" alias="ConvertRateUnitID" datatype="long"/>
  809.                     <property name="Revision" nullable="true" datatype="integer"/>
  810.                 </properties>
  811.                 <relationships>
  812.                     <relationship name="Revisions" object="UnitGroup" collection="true" keyprop="none" query="RS"/>
  813.                 </relationships>
  814.             </object>
  815.             <!-- Customer Data set -->
  816.             <object name="Customer">
  817.                 <datasource>
  818.                     <query id="Customer" default="true">
  819.                         <select name="Customer" connection="Iceland" type="table" use="raw"/>
  820.                         <insert name="Customer" connection="Iceland" type="table" use="raw"/>
  821.                         <update name="Customer" connection="Iceland" type="table" use="raw"/>
  822.                         <delete name="Customer" connection="Iceland" type="table" use="raw"/>
  823.                     </query>
  824.                 </datasource>
  825.                 <properties>
  826.                     <property name="CustomerID" alias="CustomerID" datatype="integer" nullable="false" pkey="true" identity="true"/>
  827.                     <property name="SessionGuid" alias="SessionGuid" datatype="guid" nullable="false"/>
  828.                     <property name="LastLogin" alias="LastLogin" datatype="date" nullable="false"/>
  829.                     <property name="CreationDate" alias="CreationDate" datatype="date" nullable="true"/>
  830.                     <property name="Title" alias="Title" datatype="string" nullable="false"/>
  831.                     <property name="Surname" alias="Surname" datatype="string" nullable="false"/>
  832.                     <property name="Forename" alias="Forename" datatype="string" nullable="false"/>
  833.                     <property name="EMail" alias="EMail" datatype="string" nullable="true"/>
  834.                     <property name="Password" alias="Password" datatype="string" nullable="true"/>
  835.                     <property name="HomeTel" alias="HomeTel" datatype="string" nullable="true"/>
  836.                     <property name="CustomerType" alias="CustomerType" datatype="short" nullable="true"/>
  837.                     <property name="Status" alias="Status" datatype="short" nullable="true"/>
  838.                     <property name="GuestPostcode" alias="GuestPostcode" datatype="string" nullable="true"/>
  839.                     <property name="LoyaltyPoints" alias="LoyaltyPoints" datatype="float" nullable="true"/>
  840.                     <property name="LoginID" alias="LoginID" datatype="string" nullable="true"/>
  841.                     <property name="LastAddressID" alias="LastAddressID" datatype="integer" nullable="true"/>
  842.                     <property name="IsAdmin" alias="IsAdmin" datatype="boolean" nullable="true"/>
  843.                     <property name="CCNo" alias="CCNo" datatype="string" nullable="true"/>
  844.                     <property name="CCName" alias="CCName" datatype="string" nullable="true"/>
  845.                     <property name="CCFromDate" alias="CCFromDate" datatype="date" nullable="true"/>
  846.                     <property name="CCExpDate" alias="CCExpDate" datatype="date" nullable="true"/>
  847.                     <property name="CCIssueNo" alias="CCIssueNo" datatype="integer" nullable="true"/>
  848.                     <property name="CCSave" alias="CCSave" datatype="boolean" nullable="true"/>
  849.                     <property name="RecieveInfoIceland" alias="RecieveInfoIceland" datatype="boolean" nullable="true"/>
  850.                     <property name="RecieveInfoOther" alias="RecieveInfoOther" datatype="boolean" nullable="true"/>
  851.                     <property name="UpdateFlag" alias="UpdateFlag" datatype="boolean" nullable="true"/>
  852.                     <property name="Source" alias="Source" datatype="string" nullable="true"/>
  853.                 </properties>
  854.                 <relationships>
  855.                     <relationship name="BasketItems" object="BasketItem" collection="true" keyprop="down" query="BasketItems">
  856.                         <key fkey="SessionGuid" pkey="SessionGuid" to="child" from="parent"/>
  857.                     </relationship>
  858.                     <relationship name="Lists" object="List" collection="true" keyprop="down" query="CustomerLists">
  859.                         <key fkey="SessionGuid" pkey="SessionGuid" to="child" from="parent"/>
  860.                     </relationship>
  861.                     <relationship name="Favourites" object="Favourite" collection="true" keyprop="down" query="CustomerFavourites">
  862.                         <key fkey="SessionGuid" pkey="SessionGuid" to="child" from="parent"/>
  863.                     </relationship>
  864.                     <relationship name="Addresses" object="Address" collection="true" keyprop="down" query="CustomerAddresses">
  865.                         <key fkey="SessionGuid" pkey="SessionGuid" to="child" from="parent"/>
  866.                     </relationship>
  867.                     <relationship name="Orders" object="Order" collection="true" keyprop="down" query="CustomerOrders">
  868.                         <key fkey="SessionGuid" pkey="SessionGuid" to="child" from="parent"/>
  869.                     </relationship>
  870.                     <relationship name="Zones" object="Zone" collection="true" keyprop="down" query="CustomerZones">
  871.                         <key fkey="SessionGuid" pkey="SessionGuid" to="child" from="parent"/>
  872.                     </relationship>
  873.                     <relationship name="Deliveries" object="Delivery" collection="true" keyprop="down" query="CustomerDeliveries">
  874.                         <key fkey="SessionGuid" pkey="SessionGuid" to="child" from="parent"/>
  875.                     </relationship>
  876.                 </relationships>
  877.             </object>
  878.             <object name="Order">
  879.                 <datasource>
  880.                     <query id="CustomerOrders" default="true">
  881.                         <select connection="Iceland" name="SELECT
  882.     Orders.OrderID,
  883.     Orders.CustomerID,
  884.     Orders.StoreID,
  885.     Orders.OrderCost,
  886.     Orders.TotalItemCost,
  887.     Orders.TotalItems,
  888.     Orders.OrderDate,
  889.     Orders.Status,
  890.     Orders.PromoReduction,
  891.     Orders.LoyaltyPoints,
  892.     Orders.InvoiceAddress,
  893.     Orders.DeliveryHouseName,
  894.     Orders.DeliveryStreet,
  895.     Orders.DeliveryArea,
  896.     Orders.DeliveryTown,
  897.     Orders.DeliveryCounty,
  898.     Orders.DeliveryPostcode,
  899.     Orders.IsMailingAddress,
  900.     Orders.DeliveryID,
  901.     Orders.DeliveryStartDate,
  902.     Orders.DeliveryEndDate,
  903.     Orders.AcceptSubs,
  904.     Orders.Instructions,
  905.     Orders.DeliveryInstructions,
  906.     Orders.Source
  907. FROM Orders
  908. INNER JOIN Customer
  909.     ON Orders.CustomerID=Customer.CustomerID
  910. WHERE Customer.SessionGuid=@SessionGuid
  911. AND Orders.OrderID>@MaxOrderID" type="replace" use="raw">
  912.                             <parameter name="SessionGuid" datatype="string" direction="in"/>
  913.                             <parameter name="MaxOrderID" datatype="long" direction="in"/>
  914.                         </select>
  915.                         <insert use="raw" connection="Iceland" name="Orders" type="table"/>
  916.                         <update use="raw" connection="Iceland" name="Orders" type="table"/>
  917.                         <delete use="raw" connection="Iceland" name="Orders" type="table"/>
  918.                     </query>
  919.                 </datasource>
  920.                 <properties>
  921.                     <property name="OrderID" alias="OrderID" datatype="integer" nullable="false" pkey="true" identity="true"/>
  922.                     <property name="StoreID" alias="StoreID" datatype="integer" nullable="false"/>
  923.                     <property name="CustomerID" alias="CustomerID" datatype="integer" nullable="true"/>
  924.                     <property name="OrderCost" alias="OrderCost" datatype="money" nullable="true"/>
  925.                     <property name="TotalItemCost" alias="TotalItemCost" datatype="money" nullable="true"/>
  926.                     <property name="TotalItems" alias="TotalItems" datatype="short" nullable="true"/>
  927.                     <property name="OrderDate" alias="OrderDate" datatype="date" nullable="true"/>
  928.                     <property name="Status" alias="Status" datatype="short" nullable="true"/>
  929.                     <property name="PromoReduction" alias="PromoReduction" datatype="money" nullable="true"/>
  930.                     <property name="LoyaltyPoints" alias="LoyaltyPoints" datatype="integer" nullable="true"/>
  931.                     <property name="InvoiceAddress" alias="InvoiceAddress" datatype="string" nullable="true"/>
  932.                     <property name="DeliveryHouseName" alias="DeliveryHouseName" datatype="string" nullable="true"/>
  933.                     <property name="DeliveryStreet" alias="DeliveryStreet" datatype="string" nullable="true"/>
  934.                     <property name="DeliveryArea" alias="DeliveryArea" datatype="string" nullable="true"/>
  935.                     <property name="DeliveryTown" alias="DeliveryTown" datatype="string" nullable="true"/>
  936.                     <property name="DeliveryCounty" alias="DeliveryCounty" datatype="string" nullable="true"/>
  937.                     <property name="DeliveryPostcode" alias="DeliveryPostcode" datatype="string" nullable="true"/>
  938.                     <property name="IsMailingAddress" alias="IsMailingAddress" datatype="boolean" nullable="true"/>
  939.                     <property name="DeliveryID" alias="DeliveryID" datatype="integer" nullable="true"/>
  940.                     <property name="DeliveryStartDate" alias="DeliveryStartDate" datatype="date" nullable="true"/>
  941.                     <property name="DeliveryEndDate" alias="DeliveryEndDate" datatype="date" nullable="true"/>
  942.                     <property name="AcceptSubs" alias="AcceptSubs" datatype="boolean" nullable="true"/>
  943.                     <property name="Instructions" alias="Instructions" datatype="string" nullable="true"/>
  944.                     <property name="DeliveryInstructions" alias="DeliveryInstructions" datatype="string" nullable="true"/>
  945.                     <property name="Source" alias="Source" datatype="string" nullable="true"/>
  946.                 </properties>
  947.                 <relationships>
  948.                     <relationship name="Items" object="OrderItem" collection="true" keyprop="down" query="OrderItems">
  949.                         <key fkey="OrderID" pkey="OrderID" to="child" from="parent"/>
  950.                     </relationship>
  951.                 </relationships>
  952.             </object>
  953.             <object name="OrderItem">
  954.                 <datasource>
  955.                     <query id="OrderItems" default="true">
  956.                         <select name="SELECT 
  957.     OrderItem.OrderItemID, 
  958.     OrderItem.OrderID, 
  959.     OrderItem.ProductID, 
  960.     OrderItem.Quantity, 
  961.     OrderItem.UnitID, 
  962.     OrderItem.ItemCost,
  963.     OrderItem.ItemNo, 
  964.     OrderItem.Note,
  965.     OrderItem.PromoReduction
  966. FROM OrderItem 
  967. WHERE OrderID=@OrderID" type="replace" use="raw" connection="Iceland">
  968.                             <parameter name="OrderID" datatype="long" direction="in"/>
  969.                         </select>
  970.                         <insert use="raw" connection="Iceland" name="OrderItem" type="table"/>
  971.                         <update use="raw" connection="Iceland" name="OrderItem" type="table"/>
  972.                         <delete use="raw" connection="Iceland" name="OrderItem" type="table"/>
  973.                     </query>
  974.                 </datasource>
  975.                 <properties>
  976.                     <property name="OrderItemID" alias="OrderItemID" datatype="long" nullable="false" pkey="true" identity="true"/>
  977.                     <property name="OrderID" alias="OrderID" datatype="long" nullable="false"/>
  978.                     <property name="ProductID" alias="ProductID" datatype="integer" nullable="false"/>
  979.                     <property name="Quantity" alias="Quantity" datatype="integer" nullable="false"/>
  980.                     <property name="UnitID" alias="UnitID" datatype="integer" nullable="false"/>
  981.                     <property name="ItemNo" alias="ItemNo" datatype="integer" nullable="false"/>
  982.                     <property name="ItemCost" alias="ItemCost" datatype="float" nullable="false"/>
  983.                     <property name="Note" alias="Note" datatype="string" nullable="false"/>
  984.                     <property name="PromoReduction" alias="PromoReduction" datatype="float" nullable="false"/>
  985.                 </properties>
  986.                 <relationships/>
  987.             </object>
  988.             <object name="List">
  989.                 <datasource>
  990.                     <query id="CustomerLists" default="true">
  991.                         <select connection="Iceland" name="SELECT 
  992.     List.ListID,
  993.     List.Name,
  994.     List.CustomerID 
  995. FROM List 
  996. INNER JOIN Customer
  997.     ON List.CustomerID = Customer.CustomerID
  998. WHERE Customer.SessionGuid=@SessionGUID" type="replace" use="raw">
  999.                             <parameter name="SessionGuid" datatype="string" direction="in"/>
  1000.                         </select>
  1001.                         <insert use="raw" connection="Iceland" name="List" type="table"/>
  1002.                         <update use="raw" connection="Iceland" name="List" type="table"/>
  1003.                         <delete use="raw" connection="Iceland" name="List" type="table"/>
  1004.                     </query>
  1005.                 </datasource>
  1006.                 <properties>
  1007.                     <property name="ListID" alias="ListID" datatype="integer" nullable="false" pkey="true" identity="true"/>
  1008.                     <property name="CustomerID" alias="CustomerID" datatype="integer" nullable="false"/>
  1009.                     <property name="Name" alias="Name" datatype="string" nullable="true"/>
  1010.                 </properties>
  1011.                 <relationships>
  1012.                     <relationship name="Items" object="ListItem" collection="true" keyprop="down" query="ListItems">
  1013.                         <key fkey="ListID" pkey="ListID" to="child" from="parent"/>
  1014.                     </relationship>
  1015.                 </relationships>
  1016.             </object>
  1017.             <object name="ListItem">
  1018.                 <datasource>
  1019.                     <query id="ListItems" default="true">
  1020.                         <select name="SELECT 
  1021.     ListItemID, 
  1022.     ListID, 
  1023.     ProductID, 
  1024.     Quantity, 
  1025.     UnitID, 
  1026.     ItemNo, 
  1027.     Note 
  1028. FROM ListItem 
  1029. WHERE ListID=@ListID" type="replace" use="raw" connection="Iceland">
  1030.                             <parameter name="ListID" datatype="long" direction="in"/>
  1031.                         </select>
  1032.                         <insert use="raw" connection="Iceland" name="ListItem" type="table"/>
  1033.                         <update use="raw" connection="Iceland" name="ListItem" type="table"/>
  1034.                         <delete use="raw" connection="Iceland" name="ListItem" type="table"/>
  1035.                     </query>
  1036.                 </datasource>
  1037.                 <properties>
  1038.                     <property name="ListItemID" alias="ListItemID" datatype="long" nullable="false" pkey="true" identity="true"/>
  1039.                     <property name="ListID" alias="ListID" datatype="long" nullable="false"/>
  1040.                     <property name="ProductID" alias="ProductID" datatype="integer" nullable="false"/>
  1041.                     <property name="Quantity" alias="Quantity" datatype="integer" nullable="false"/>
  1042.                     <property name="UnitID" alias="UnitID" datatype="integer" nullable="false"/>
  1043.                     <property name="ItemNo" alias="ItemNo" datatype="integer" nullable="false"/>
  1044.                     <property name="Note" alias="Note" datatype="string" nullable="false"/>
  1045.                 </properties>
  1046.                 <relationships/>
  1047.             </object>
  1048.             <object name="BasketItem">
  1049.                 <datasource>
  1050.                     <query id="BasketItems" default="true">
  1051.                         <select name="SELECT 
  1052.     BasketItem.BasketItemID, 
  1053.     BasketItem.CustomerID, 
  1054.     BasketItem.ProductID, 
  1055.     BasketItem.Quantity, 
  1056.     BasketItem.UnitID, 
  1057.     BasketItem.ItemNo, 
  1058.     BasketItem.Note 
  1059. FROM BasketItem 
  1060. INNER JOIN Customer
  1061.     ON Customer.CustomerID = BasketItem.CustomerID
  1062. WHERE Customer.SessionGuid=@SessionGUID" type="replace" use="raw" connection="Iceland">
  1063.                             <parameter name="SessionGuid" datatype="string" direction="in"/>
  1064.                         </select>
  1065.                         <insert use="raw" connection="Iceland" name="BasketItem" type="table"/>
  1066.                         <update use="raw" connection="Iceland" name="BasketItem" type="table"/>
  1067.                         <delete use="raw" connection="Iceland" name="BasketItem" type="table"/>
  1068.                     </query>
  1069.                 </datasource>
  1070.                 <properties>
  1071.                     <property name="BasketItemID" alias="BasketItemID" datatype="long" nullable="false" pkey="true" identity="true"/>
  1072.                     <property name="CustomerID" alias="CustomerID" datatype="long" nullable="false"/>
  1073.                     <property name="ProductID" alias="ProductID" datatype="integer" nullable="false"/>
  1074.                     <property name="Quantity" alias="Quantity" datatype="integer" nullable="false"/>
  1075.                     <property name="UnitID" alias="UnitID" datatype="integer" nullable="false"/>
  1076.                     <property name="ItemNo" alias="ItemNo" datatype="integer" nullable="false"/>
  1077.                     <property name="Note" alias="Note" datatype="string" nullable="false"/>
  1078.                 </properties>
  1079.                 <relationships/>
  1080.             </object>
  1081.             <object name="Favourite">
  1082.                 <datasource>
  1083.                     <query id="CustomerFavourites">
  1084.                         <select name="SELECT
  1085.     Favourite.CustomerID,
  1086.     Favourite.ProductID,
  1087.     Favourite.TotalQtyBought,
  1088.     Favourite.NumberOfOrders,
  1089.     Favourite.LastPurchaseDate,
  1090.     Favourite.FirstPurchasedate,
  1091.     Favourite.IsVisible
  1092. FROM Favourite
  1093. INNER JOIN Customer
  1094.     ON Favourite.CustomerID = Customer.CustomerID
  1095. WHERE Customer.SessionGuid=@sessionGUID
  1096. " type="replace" connection="Iceland" use="raw">
  1097.                             <parameter name="SessionGuid" datatype="string" direction="in"/>
  1098.                         </select>
  1099.                         <insert use="raw" connection="Iceland" name="Favourite" type="table"/>
  1100.                         <update use="raw" connection="Iceland" name="Favourite" type="table"/>
  1101.                         <delete use="raw" connection="Iceland" name="Favourite" type="table"/>
  1102.                     </query>
  1103.                 </datasource>
  1104.                 <properties>
  1105.                     <property name="CustomerID" alias="CustomerID" datatype="integer" nullable="false" pkey="true"/>
  1106.                     <property name="ProductID" alias="ProductID" datatype="integer" nullable="false" pkey="true"/>
  1107.                     <property name="TotalQtyBought" alias="TotalQtyBought" datatype="float" nullable="true"/>
  1108.                     <property name="NumberOfOrders" alias="NumberOfOrders" datatype="integer" nullable="true"/>
  1109.                     <property name="LastPurchaseDate" alias="LastPurchaseDate" datatype="date" nullable="true"/>
  1110.                     <property name="FirstPurchaseDate" alias="FirstPurchaseDate" datatype="date" nullable="true"/>
  1111.                     <property name="IsVisible" alias="IsVisible" datatype="integer" nullable="true"/>
  1112.                 </properties>
  1113.                 <relationships/>
  1114.             </object>
  1115.             <object name="Address">
  1116.                 <datasource>
  1117.                     <query id="CustomerAddresses">
  1118.                         <select name="SELECT
  1119.     Address.AddressID,
  1120.     Address.CustomerID,
  1121.     Address.AddressTypeID,
  1122.     Address.HouseName,
  1123.     Address.Street,
  1124.     Address.Area,
  1125.     Address.Town,
  1126.     Address.County,
  1127.     Address.Postcode,
  1128.     Address.ShowTerms,
  1129.     Address.StoreID,
  1130.     Address.ZoneID
  1131. FROM
  1132.     Address
  1133.     INNER JOIN Customer
  1134.     ON Address.CustomerID = Customer.CustomerID
  1135. WHERE Customer.SessionGuid=@SessionGuid" type="replace" connection="Iceland" use="raw">
  1136.                             <parameter name="SessionGuid" datatype="string" direction="in"/>
  1137.                         </select>
  1138.                         <insert use="raw" connection="Iceland" name="Address" type="table"/>
  1139.                         <update use="raw" connection="Iceland" name="Address" type="table"/>
  1140.                         <delete use="raw" connection="Iceland" name="Address" type="table"/>
  1141.                     </query>
  1142.                 </datasource>
  1143.                 <properties>
  1144.                     <property name="AddressID" alias="AddressID" datatype="integer" nullable="false" pkey="true"/>
  1145.                     <property name="CustomerID" alias="CustomerID" datatype="integer" nullable="false" pkey="true"/>
  1146.                     <property name="AddressTypeID" alias="AddressTypeID" datatype="integer" nullable="false" pkey="true"/>
  1147.                     <property name="HouseName" alias="HouseName" datatype="string" nullable="false"/>
  1148.                     <property name="Street" alias="Street" datatype="string" nullable="false"/>
  1149.                     <property name="Area" alias="Area" datatype="string" nullable="true"/>
  1150.                     <property name="Town" alias="Town" datatype="string" nullable="false"/>
  1151.                     <property name="County" alias="County" datatype="string" nullable="true"/>
  1152.                     <property name="Postcode" alias="Postcode" datatype="string" nullable="false"/>
  1153.                     <property name="ShowTerms" alias="ShowTerms" datatype="boolean" nullable="false"/>
  1154.                     <property name="StoreID" alias="StoreID" datatype="integer" nullable="false"/>
  1155.                     <property name="ZoneID" alias="ZoneID" datatype="integer" nullable="false"/>
  1156.                 </properties>
  1157.                 <relationships/>
  1158.             </object>
  1159.             <object name="Zone">
  1160.                 <datasource>
  1161.                     <query default="true" id="CustomerZones">
  1162.                         <select name="SELECT Zone.ZoneID,Zone.Description,Zone.StoreID FROM Zone
  1163. INNER JOIN Address ON Zone.ZoneID=Address.ZoneID
  1164. INNER JOIN Customer ON Customer.CustomerID=Address.CustomerID
  1165. WHERE Customer.SessionGuid=@SessionGuid" connection="Iceland" use="raw" type="replace">
  1166.                             <parameter name="SessionGuid" datatype="string" direction="in"/>
  1167.                         </select>
  1168.                         <insert use="raw" connection="Iceland" name="Zone" type="table"/>
  1169.                         <update use="raw" connection="Iceland" name="Zone" type="table"/>
  1170.                         <delete use="raw" connection="Iceland" name="Zone" type="table"/>
  1171.                     </query>
  1172.                 </datasource>
  1173.                 <properties>
  1174.                     <property name="ZoneID" alias="ZoneID" datatype="integer" pkey="true"/>
  1175.                     <property name="Description" alias="Description" datatype="string"/>
  1176.                     <property name="StoreID" alias="StoreID" datatype="integer"/>
  1177.                 </properties>
  1178.                 <relationships/>
  1179.             </object>
  1180.             <object name="Delivery">
  1181.                 <datasource>
  1182.                     <query id="CustomerDeliveries">
  1183.                         <select name="SELECT 
  1184.     Delivery.DeliveryID,
  1185.     Delivery.StartDate,
  1186.     Delivery.EndDate,
  1187.     Delivery.Cost,
  1188.     Delivery.SlotCount,
  1189.     Delivery.ZoneID,
  1190.     Delivery.CutOffdate
  1191. FROM Delivery
  1192. INNER JOIN Address
  1193.     ON Delivery.ZoneID=Address.ZoneID
  1194. INNER JOIN Customer
  1195.     ON Address.CustomerID = Customer.CustomerID
  1196. WHERE Customer.SessionGuid = @SessionGuid" connection="Iceland" use="raw" type="replace">
  1197.                             <parameter name="SessionGuid" datatype="string" direction="in"/>
  1198.                         </select>
  1199.                         <insert use="raw" connection="Iceland" name="Delivery" type="table"/>
  1200.                         <update use="raw" connection="Iceland" name="Delivery" type="table"/>
  1201.                         <delete use="raw" connection="Iceland" name="Delivery" type="table"/>
  1202.                     </query>
  1203.                 </datasource>
  1204.                 <properties>
  1205.                     <property name="DeliveryID" alias="DeliveryID" datatype="integer" pkey="true"/>
  1206.                     <property name="StartDate" alias="StartDate" datatype="date"/>
  1207.                     <property name="EndDate" alias="EndDate" datatype="date"/>
  1208.                     <property name="Cost" alias="Cost" datatype="float"/>
  1209.                     <property name="SlotCount" alias="SlotCount" datatype="integer"/>
  1210.                     <property name="ZoneID" alias="ZoneID" datatype="integer"/>
  1211.                     <property name="CutOffDate" alias="CutOffDate" datatype="date"/>
  1212.                 </properties>
  1213.                 <relationships/>
  1214.             </object>
  1215.             <object name="CustomerPostcodeStore">
  1216.                 <datasource>
  1217.                     <query id="CustomerPostcodeStore" default="true">
  1218.                         <select use="raw" connection="IcelandMain" name="CustomerPostcodeStore" type="table"/>
  1219.                         <insert use="raw" connection="IcelandMain" name="CustomerPostcodeStore" type="table"/>
  1220.                         <update use="raw" connection="IcelandMain" name="CustomerPostcodeStore" type="table"/>
  1221.                         <delete use="raw" connection="IcelandMain" name="CustomerPostcodeStore" type="table"/>
  1222.                     </query>
  1223.                 </datasource>
  1224.                 <properties>
  1225.                     <property name="Postcode" alias="Postcode" datatype="string" nullable="false"/>
  1226.                     <property name="StoreID" alias="StoreID" datatype="integer" nullable="false"/>
  1227.                     <property name="ZoneID" alias="ZoneID" datatype="integer" nullable="false"/>
  1228.                     <property name="CustomerID" alias="CustomerID" datatype="integer" nullable="false"/>
  1229.                 </properties>
  1230.                 <relationships/>
  1231.             </object>
  1232.             <!-- Media Data set -->
  1233.             <object name="MediaWWWRoot">
  1234.                 <dcserver dc="IcelandRevisions" enable="true"/>
  1235.                 <datasource>
  1236.                     <query id="WWWRoot" default="true">
  1237.                         <select name="" connection="MediaWWWRoot" type="table" use="dcserver"/>
  1238.                         <select name="" connection="MediaWWWRoot" type="table" use="raw"/>
  1239.                         <update name="" connection="MediaWWWRoot" type="table" use="raw"/>
  1240.                         <insert name="" connection="MediaWWWRoot" type="table" use="raw"/>
  1241.                         <delete name="" connection="MediaWWWRoot" type="table" use="raw"/>
  1242.                     </query>
  1243.                 </datasource>
  1244.                 <properties>
  1245.                     <property name="Name" alias="Name" datatype="string" nullable="false" pkey="true"/>
  1246.                     <property name="Size" alias="Size" datatype="integer" nullable="false"/>
  1247.                     <property name="Data" alias="Data" datatype="string" nullable="true"/>
  1248.                     <property name="Revision" alias="" datatype="long" nullable="true"/>
  1249.                 </properties>
  1250.                 <relationships>
  1251.                     <relationship name="Revisions" object="MediaWWWRoot" keyprop="down" collection="true" query="WWWRoot"/>
  1252.                 </relationships>
  1253.             </object>
  1254.             <object name="MediaStoreContent">
  1255.                 <dcserver dc="IcelandRevisions" enable="true"/>
  1256.                 <datasource>
  1257.                     <query id="StoreContent" default="true">
  1258.                         <select name="" connection="MediaStoreContent" type="table" use="dcserver"/>
  1259.                         <select name="" connection="MediaStoreContent" type="table" use="raw"/>
  1260.                         <update name="" connection="MediaStoreContent" type="table" use="raw"/>
  1261.                         <insert name="" connection="MediaStoreContent" type="table" use="raw"/>
  1262.                         <delete name="" connection="MediaStoreContent" type="table" use="raw"/>
  1263.                     </query>
  1264.                 </datasource>
  1265.                 <properties>
  1266.                     <property name="Name" alias="Name" datatype="string" nullable="false" pkey="true"/>
  1267.                     <property name="Size" alias="Size" datatype="integer" nullable="false"/>
  1268.                     <property name="Data" alias="Data" datatype="string" nullable="true"/>
  1269.                     <property name="Revision" alias="" datatype="long" nullable="true"/>
  1270.                 </properties>
  1271.                 <relationships>
  1272.                     <relationship name="Revisions" object="MediaStoreContent" keyprop="down" collection="true" query="StoreContent"/>
  1273.                 </relationships>
  1274.             </object>
  1275.             <object name="MediaRepository">
  1276.                 <dcserver dc="IcelandRevisions" enable="true"/>
  1277.                 <datasource>
  1278.                     <query id="Repository" default="true">
  1279.                         <select name="" connection="MediaRepository" type="table" use="dcserver"/>
  1280.                         <select name="" connection="MediaRepository" type="table" use="raw"/>
  1281.                         <update name="" connection="MediaRepository" type="table" use="raw"/>
  1282.                         <insert name="" connection="MediaRepository" type="table" use="raw"/>
  1283.                         <delete name="" connection="MediaRepository" type="table" use="raw"/>
  1284.                     </query>
  1285.                 </datasource>
  1286.                 <properties>
  1287.                     <property name="Name" alias="Name" datatype="string" nullable="false" pkey="true"/>
  1288.                     <property name="Size" alias="Size" datatype="integer" nullable="false"/>
  1289.                     <property name="Data" alias="Data" datatype="string" nullable="true"/>
  1290.                     <property name="Revision" alias="" datatype="long" nullable="true"/>
  1291.                 </properties>
  1292.                 <relationships>
  1293.                     <relationship name="Revisions" object="MediaRepository" keyprop="down" collection="true" query="Repository"/>
  1294.                 </relationships>
  1295.             </object>
  1296.             <object name="MediaSoftware">
  1297.                 <dcserver dc="IcelandRevisions" enable="true"/>
  1298.                 <datasource>
  1299.                     <query id="Repository" default="true">
  1300.                         <select name="" connection="MediaSoftware" type="table" use="dcserver"/>
  1301.                         <select name="" connection="MediaSoftware" type="table" use="raw"/>
  1302.                         <update name="" connection="MediaSoftware" type="table" use="raw"/>
  1303.                         <insert name="" connection="MediaSoftware" type="table" use="raw"/>
  1304.                         <delete name="" connection="MediaSoftware" type="table" use="raw"/>
  1305.                     </query>
  1306.                 </datasource>
  1307.                 <properties>
  1308.                     <property name="Name" alias="Name" datatype="string" nullable="false" pkey="true"/>
  1309.                     <property name="Size" alias="Size" datatype="integer" nullable="false"/>
  1310.                     <property name="Data" alias="Data" datatype="string" nullable="true"/>
  1311.                     <property name="Revision" alias="" datatype="long" nullable="true"/>
  1312.                 </properties>
  1313.                 <relationships>
  1314.                     <relationship name="Revisions" object="MediaSoftware" keyprop="down" collection="true" query="Repository"/>
  1315.                 </relationships>
  1316.             </object>
  1317.         </objects>
  1318.     </model>
  1319. </models>
  1320.