Using XQuery 1.0
This guide explains how to use XQuery 1.0 with XmlPrime.
This topic contains the following sections.
Loading the Input Document
In this example we will be using the bstore1.example.com/bib.xml document as described in XML Query Use Cases. The document is as follows:
<bib> <book year="1994"> <title>TCP/IP Illustrated</title> <author><last>Stevens</last><first>W.</first></author> <publisher>Addison-Wesley</publisher> <price>65.95</price> </book> <book year="1992"> <title>Advanced Programming in the Unix environment</title> <author><last>Stevens</last><first>W.</first></author> <publisher>Addison-Wesley</publisher> <price>65.95</price> </book> <book year="2000"> <title>Data on the Web</title> <author><last>Abiteboul</last><first>Serge</first></author> <author><last>Buneman</last><first>Peter</first></author> <author><last>Suciu</last><first>Dan</first></author> <publisher>Morgan Kaufmann Publishers</publisher> <price>39.95</price> </book> <book year="1999"> <title>The Economics of Technology and Content for Digital TV</title> <editor> <last>Gerbarg</last><first>Darcy</first> <affiliation>CITI</affiliation> </editor> <publisher>Kluwer Academic Publishers</publisher> <price>129.95</price> </book> </bib>
This document is assumed to be in the file bib.xml.
To query the document, we load it into an XdmDocumentXdmDocumentXdmDocument. For more information about document representations, see Document Representations.
XdmDocument document = new XdmDocument("bib.xml", XmlSpace.Preserve);
Compiling a Query
We will run the following query over our document, which returns the books in ascending order of price.
for $book in /bib/book order by xs:decimal($book/price) return $book
The next stage is to compile the query. To describe how the
query should be compiled we need set up an
XQuerySettingsXQuerySettingsXQuerySettings
object. This describes all the settings used for compilation. In
particular, we will set the context item type, which by default
is set to none
, and so
the context item cannot be set unless we override the type here.
We can then compile the query using the
XQuery.CompileXQuery.CompileXQuery::Compile
method. This returns us an
XQueryXQueryXQuery object
encapsulating the query.
XQuerySettings querySettings = new XQuerySettings(); querySettings.ContextItemType = XdmType.Node; string program = "for $book in /bib/book" + "order by xs:decimal($book/price)" + "return $book"; XQuery query = XQuery.Compile(program, querySettings);
An XQueryX query can be compiled by passing an IXPathNavigableIXPathNavigableIXPathNavigable instance over the XQueryX document to the XQuery.Compile (IXPathNavigable, XQuerySettings)XQuery.Compile (IXPathNavigable, XQuerySettings)XQuery::Compile (IXPathNavigable^, XQuerySettings^) method.
Executing the Query
Now we have our query object, we now just need to evaluate it. We use the DynamicContextSettingsDynamicContextSettingsDynamicContextSettings class which describes the parameters used to evaluate the query. In particular we will set the context item to be the document that we loaded earlier. We then pass these settings to the XQuery.Evaluate (DynamicContextSettings)XQuery.Evaluate (DynamicContextSettings)XQuery::Evaluate (DynamicContextSettings^) method to evaluate the query.
XPathNavigator contextItem = document.CreateNavigator(); DynamicContextSettings settings = new DynamicContextSettings(); settings.ContextItem = contextItem; IEnumerable<XPathItem> result = query.Evaluate(settings);
doc
and
collection
functions always raise an error.
This behaviour is changed by setting the
DocumentSetDocumentSetDocumentSet
property on the DynamicContextSettingsDynamicContextSettingsDynamicContextSettings.
See Loading External Resources for more information.
The result is an enumerable collection of XPathItemXPathItemXPathItem instances. Each item returned from the query is either an instance of XPathNavigatorXPathNavigatorXPathNavigator (if the item is a node), XPathAtomicValueXPathAtomicValueXPathAtomicValue (if the item is an atomic value), or XPathFunctionItemXPathFunctionItemXPathFunctionItem (if the item is a function item). .
Serializing the Results of a Query
To save result
to a file we can use the
Serialize (IEnumerable<XPathItem>, string, XdmWriterSettings)Serialize (IEnumerable(Of XPathItem), String, XdmWriterSettings)Serialize (IEnumerable<XPathItem^>^, String^, XdmWriterSettings^)
method specifying a file to which the results should be written and the
XdmWriterSettingsXdmWriterSettingsXdmWriterSettings
from the
SerializationSettingsSerializationSettingsSerializationSettings
property of our compiled query
.
XdmWriter.Serialize(result, "output.xml", query.SerializationSettings);
Directly Serializing the Results of a Query
Instead of evaluating the results of a query then serializing the results, it can often be more efficient to serialize the results directly. This is possible using the SerializeSerializeSerialize method.
XPathNavigator contextItem = document.CreateNavigator(); DynamicContextSettings settings = new DynamicContextSettings(); settings.ContextItem = contextItem; query.Serialize("output.xml", settings);
For more details on serialization see Serialization