In this chapter, you learned about using XML data in the .NET Framework. We covered the following topics:
An introduction to the basics of XML data formats
An introduction to the basics of the XML Schema Definition (XSD) language
How an ADO.NET DataSet object can read and write XML data
How to control XML formats with the ColumnMapping property when writing XML data from a DataSet
How to create DiffGram XML output that shows the user changes that have been made to DataSet data along with the original values
Classes in the System.Xml namespace of the .NET Framework
How to use XmlReader and its derived classes XmlTextReader, XmlNodeReader, and XmlValidatingReader to process a forward-only, read-only stream of XML data
How to use the XmlTextWriter to create XML output
How to have complete programmatic access to an XML data file by using the XML Document Object Model (DOM)
The base classes of the DOM: XmlNode, XmlNodeList, and XmlNamedNodeMap, and the derived classes such as XmlDocument, XmlElement, XmlAttribute, and XmlText
How XPath expressions use a common format to select matching nodes that can be used with DOM programming, XSLT stylesheets, and other XML technologies
How to use classes in the System.Xml.XPath namespace, such as XPathNavigator and XPathDocument, to optimize performance when using XPath expressions and doing XSLT transformations
How to use an XmlValidatingReader to validate an XML data file against a specific schema
How to handle XmlSchemaExceptions
How to use classes in the System.Xml.Xsl namespace to perform XSLT transformations on XML data to create different formats of output from your XML data
How to use the XmlDataDocument to access both relational and hierarchical views of the same data
How to use special SQL syntax, the FOR XML clause, and the SqlCommand object’s ExecuteXmlReader method to retrieve XML data directly from a SQL Server 2000 database
How to use special SQL syntax, the OPENXML clause, and SQL Server 2000 system stored procedures to read data from an XML data file and store it into SQL Server tables