<?xml version="1.0" ?> <!DOCTYPE XMLToDBMS SYSTEM "xmldbms.dtd" > <XMLToDBMS Version="1.0"> <Options> </Options> <Maps> <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> <OrderColumn Name="Description" Generate="Yes"/> </PropertyMap> <PropertyMap> <ElementType Name="Price"/> <ToColumn> <Column Name="Price"/> </ToColumn> <OrderColumn Name="Price" Generate="Yes"/> </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> <OrderColumn Name="Quantity" Generate="Yes"/> </PropertyMap> <RelatedClass KeyInParentTable="Candidate"> <ElementType Name="Part"/> <CandidateKey Generate="Yes"> <Column Name="PartNumber"/> </CandidateKey> <ForeignKey> <Column Name="PartNumber"/> </ForeignKey> <OrderColumn Name="PartNumber" Generate="Yes"/> </RelatedClass> </ClassMap> <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="Street"/> <ToColumn> <Column Name="Street"/> </ToColumn> </PropertyMap> <PropertyMap> <ElementType Name="PostCode"/> <ToColumn> <Column Name="PostalCode"/> </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"/> <ToRootTable> <Table Name="Sales"/> </ToRootTable> <PropertyMap> <Attribute Name="SONumber"/> <ToColumn> <Column Name="SalesOrderID"/> </ToColumn> </PropertyMap> <PropertyMap> <ElementType Name="Date"/> <ToColumn> <Column Name="OrderDate"/> </ToColumn> <OrderColumn Name="OrderDate" Generate="Yes"/> </PropertyMap> <RelatedClass KeyInParentTable="Candidate"> <ElementType Name="Line"/> <CandidateKey Generate="Yes"> <Column Name="SalesOrderID"/> </CandidateKey> <ForeignKey> <Column Name="SalesOrderID"/> </ForeignKey> <OrderColumn Name="LineNumber" Generate="Yes"/> </RelatedClass> <RelatedClass KeyInParentTable="Candidate"> <ElementType Name="Customer"/> <CandidateKey Generate="Yes"> <Column Name="CustomerID"/> </CandidateKey> <ForeignKey> <Column Name="CustomerID"/> </ForeignKey> <OrderColumn Name="CustomerID" Generate="Yes"/> </RelatedClass> </ClassMap> </Maps> </XMLToDBMS>