The ADO.NET model supports hierarchical data or those ORDBMS that use concepts such as embedded tables and homogeneous object graphs. The support takes three major forms:
Hierarchies can be factored into multiple relational tables and can be used with the DataSet's concept of relationships.
DataReader lets you read true hierarchical data through the IData-Record.GetData method.
Hierarchical data can be used with XML Infoset providers.
The data provider and DataSet object models and semantics were designed with relational data stores in mind and are a continuation of the relational-centric property of common database APIs. Data providers can support nonrelational semantics, however, and ...