10.3. ADO.NET with Homogeneous Hierarchical Data and ORDBMS

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 ...

Get Essential ADO.NET now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.