Essential ADO.NET

C.5. Elements with Child Elements

Elements that have child elements will result in inferred tables. For example, consider the following XML:

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

The inference process will produce a table named “Element1.”

DataSet: DocumentElement

Table: Element1

ChildElement1

Text1

The document, or root, element will result in an inferred table if it has attributes or child elements that will be inferred as columns. If the document element has no attributes and no child elements that would be inferred as columns, the element will be inferred as a DataSet. For example, consider the following XML:

 <DocumentElement> <Element1>Text1</Element1> <Element2>Text2</Element2> ...