<?xml version="1.0" ?>
<!DOCTYPE XMLToDBMS SYSTEM "../xmldbms.dtd">
<XMLToDBMS Version="1.0">
   <Options>
      <DateTimeFormats>
         <Patterns Timestamp="MM.DD.YY"/>
      </DateTimeFormats>
   </Options>
   <Maps>
      <IgnoreRoot>
         <ElementType Name="Orders"/>
         <PseudoRoot>
            <ElementType Name="SalesOrder"/>
            <CandidateKey Generate="No">
               <Column Name="SalesOrderID"/>
            </CandidateKey>
         </PseudoRoot>
      </IgnoreRoot>
      <ClassMap>
         <ElementType Name="Customer"/>
         <ToClassTable>
            <Table Name="Customers"/>
         </ToClassTable>
         <PropertyMap>
            <Attribute Name="CustNumber"/>
            <ToColumn>
               <Column Name="CustomerID"/>
            </ToColumn>
         </PropertyMap>
         <PropertyMap>
            <ElementType Name="CustName"/>
            <ToColumn>
               <Column Name="Name"/>
            </ToColumn>
         </PropertyMap>
         <PropertyMap>
            <ElementType Name="PostCode"/>
            <ToColumn>
               <Column Name="PostalCode"/>
            </ToColumn>
         </PropertyMap>
         <PropertyMap>
            <ElementType Name="Street"/>
            <ToColumn>
               <Column Name="Street"/>
            </ToColumn>
         </PropertyMap>
         <PropertyMap>
            <ElementType Name="City"/>
            <ToColumn>
               <Column Name="City"/>
            </ToColumn>
         </PropertyMap>
         <PropertyMap>
            <ElementType Name="State"/>
            <ToColumn>
               <Column Name="State"/>
            </ToColumn>
         </PropertyMap>
      </ClassMap>
      <ClassMap>
         <ElementType Name="SalesOrder"/>
         <ToClassTable>
            <Table Name="Sales"/>
         </ToClassTable>
         <PropertyMap>
            <Attribute Name="SONumber"/>
            <ToColumn>
               <Column Name="SalesOrderID"/>
            </ToColumn>
         </PropertyMap>
         <PropertyMap>
            <ElementType Name="Date"/>
            <ToColumn>
               <Column Name="OrderDate"/>
            </ToColumn>
         </PropertyMap>
         <RelatedClass KeyInParentTable="Candidate">
            <ElementType Name="Line"/>
            <CandidateKey Generate="No">
               <Column Name="SalesOrderID"/>
            </CandidateKey>
            <ForeignKey>
               <Column Name="SalesOrderID"/>
            </ForeignKey>
            <OrderColumn Name="SalesOrderID" Generate="No"/>
         </RelatedClass>
         <RelatedClass KeyInParentTable="Foreign">
            <ElementType Name="Customer"/>
            <CandidateKey Generate="No">
               <Column Name="CustomerID"/>
            </CandidateKey>
            <ForeignKey>
               <Column Name="CustomerID"/>
            </ForeignKey>
         </RelatedClass>
      </ClassMap>
      <ClassMap>
         <ElementType Name="Part"/>
         <ToClassTable>
            <Table Name="Parts"/>
         </ToClassTable>
         <PropertyMap>
            <Attribute Name="PartNumber"/>
            <ToColumn>
               <Column Name="PartNumber"/>
            </ToColumn>
         </PropertyMap>
         <PropertyMap>
            <ElementType Name="Description"/>
            <ToColumn>
               <Column Name="Description"/>
            </ToColumn>
         </PropertyMap>
         <PropertyMap>
            <ElementType Name="Price"/>
            <ToColumn>
               <Column Name="Price"/>
            </ToColumn>
         </PropertyMap>
      </ClassMap>
      <ClassMap>
         <ElementType Name="Line"/>
         <ToClassTable>
            <Table Name="Lines"/>
         </ToClassTable>
         <PropertyMap>
            <Attribute Name="LineNumber"/>
            <ToColumn>
               <Column Name="LineNumber"/>
            </ToColumn>
         </PropertyMap>
         <PropertyMap>
            <ElementType Name="Quantity"/>
            <ToColumn>
               <Column Name="Quantity"/>
            </ToColumn>
         </PropertyMap>
         <RelatedClass KeyInParentTable="Foreign">
            <ElementType Name="Part"/>
            <CandidateKey Generate="No">
               <Column Name="PartNumber"/>
            </CandidateKey>
            <ForeignKey>
               <Column Name="PartNumber"/>
            </ForeignKey>
         </RelatedClass>
      </ClassMap>
   </Maps>
</XMLToDBMS>