With the introduction of the DataSet and XmlDataDocument classes in .NET and the XML features in SQL Server 2000, the task of converting relational data into XML has been greatly simplified and made much more efficient. However, what if you would like to leverage SQL Server 2000 XML features directly from within a .NET application using managed classes?
The provided sample code demonstrates how to use the SQLXML .NET managed classes to generate custom XML documents using XPath queries and XML templates. This includes demonstrating how to map relational tables to XML documents through using annotated XSD schemas. You will also see how to automatically transform SQL XML data into other formats using XSLT. The managed classes used in the code can be found in the SQLXML web release 3.