<?xml version="1.0" ?> <!DOCTYPE XMLToDBMS SYSTEM "../xmldbms.dtd"> <XMLToDBMS Version="1.0"> <Options> <Parameter Name="PartNumber"/> <DateTimeFormats> <Patterns Timestamp="MM.DD.YY"/> </DateTimeFormats> </Options> <Maps> <IgnoreRoot> <ElementType Name="Orders"/> <PseudoRoot> <ElementType Name="SalesOrder"/> <CandidateKey Generate="No"> <Column Name="SalesOrderID"/> </CandidateKey> <OrderColumn Name="SalesOrderID" Generate="No"/> <Filter Value="SalesOrderID = '123'"/> </PseudoRoot> </IgnoreRoot> <ClassMap> <ElementType Level="CustomerInfo" 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="LineNumber" 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 Level=".." 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> <PropertyMap> <ElementType Name="PartDescription"/> <ToPropertyTable KeyInParentTable="Foreign"> <Table Name='Parts'/> <CandidateKey Generate="No"> <Column Name="PartNumber"/> </CandidateKey> <ForeignKey> <Column Name="PartNumber"/> </ForeignKey> <Column Name="Description"/> <Filter Value="PartNumber='$PartNumber'"/> </ToPropertyTable> </PropertyMap> </ClassMap> </Maps> </XMLToDBMS>