<?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>