Essential ADO.NET

C.12. Limits

The process of inferring a DataSet schema from XML is not deterministic, in that different instances of XML documents having the same intended schema can result in different schemas depending on the XML elements in each document. For example, consider the following XML documents:

Document1:

<DocumentElement>
  <Element1>Text1</Element1>
  <Element1>Text2</Element1>
</DocumentElement>

Document2:

<DocumentElement>
  <Element1>Text1</Element1>
</DocumentElement>

For “Document1,” the inference process will produce a DataSet named “DocumentElement” and a table named “Element1,” because “Element1” is a repeating element.

DataSet: DocumentElement

Table: Element1

Element1_Text
Text1
Text2

However, for “Document2,” the inference process will ...