One of the most important design goals for ADO+ was powerful XML support. Microsoft designed ADO+ hand in hand with the .NET XML framework. Both are components of a single architecture. The unification of ADO+ with the XML framework happens in the dataset.
For beginners datasets has methods that can read and write XML. For reading XML, the XML framework parser is used, either explicitly or implicitly. For writing XML out, the XML framework XmlWriter is utilized.
In spite of where the data originated, the dataset can save out its contents, both schema and data as XML. The schema is encoded as an internal W3C schema section, generally known as XSD, and the data is encoded as XML that be conventional to that schema. Because the dataset's native serialization format is XML, it is an tremendous medium for moving data between tiers in a disconnected fashion just like the disconnected recordset.
Indeed, .NET Web services make intense use of datasets to transport data in the context of a schema between tiers of an application. Just like populating the dataset via its object model or through managed providers, loading the dataset with XML is a two stage process.
1) The schema is created, and then the data is loaded. If the XML document comes with a schema, that schema is used to create the relational structure of the dataset. If not, the dataset can infer schema from the containment relationships within the document. In general speaking, elements that are not scalar valued are mapped to tables, whereas attributes and scalar valued elements are mapped to columns.
2) The process of inferring schema is useful when constructing an application that has to consume XML that comes with no schema. But for production applications, it is highly desirable to take the inferred schema, modify it as appropriate, and load that schema in before the actual data is loaded. That way, the process of loading the document is deterministic, so you don't have to worry about what a slight change in the incoming document will do to the inference heuristics.
