XPath query schemas and templates
An XPath query can also be embedded into an XML template file, and the following code is a simple XML template file that contains an XPath query.
<northwind xmlns:sql=
"Urn:schemas-microsoft-com:
Xml-sql ">
<sql:xpath-query mapping-schema=
"File4.xdr" >
/customer[@CustomerID =
' ALFKI ']/order
</sql:xpath-query>
</Northwind>
This query uses a schema (schema) to return all orders for the user with the CustomerID number ALFKI, and if you want the XPath statement to run, you must
Maps different XML elements and attributes to the corresponding database tables and field names using an XDR schema file. This schema file is given below.
<?xml version= "1.0"? > >
<schema xmlns= "Urn:schemas-microsoft-com:xml-data"
xmlns:dt= "Urn:schemas-microsoft-com:datatypes"
Xmlns:sql= "Urn:schemas-microsoft-com:xml-sql" >
<elementtype name= "Customer" sql:relation= "Customers"
<attributetype name= "CustomerID" dt:type= "id"/>
<attributetype name= "CompanyName"/>
<attributetype name= "ContactName"/>
<attributetype name= "City"/>
<attributetype name= "Fax"/>
<attributetype name= "Orders" dt:type=
"Idrefs" sql:id-prefix= "ord"/"
<attribute type= "CustomerID"/>
<attribute type= "CompanyName"/>
<attribute type= "ContactName"/>
<attribute type= "City"/>
<attribute type= "Fax"/>
<attribute type= "Orders" sql:relation=
"Orders" sql:field= "OrderID"
<sql:relationship
key-relation= "Customers"
key= "CustomerID"
foreign-relation= "Orders"
foreign-key= "CustomerID"/>
</attribute>
<element type= "Order" >
<sql:relationship
key-relation= "Customers"
key= "CustomerID"
foreign-relation= "Orders"
