Working with Relations in a Dataset
An ADO.NET DataSet object is much like an in-memory database. This object can contain DataTable objects, where each of these is a representation of the data that was retrieved via a SELECT statement. (The source of data in the DataTable might include data from multiple tables, but that's not a concern once that data's stored in the DataTable object.) Datasets can also store schema information as well as constraints and relationships between multiple DataTable objects.
You may need to represent and work with relationships between DataTable objects in your DataSets. For example, you might want to examine both employees and their orders as well as be able to view orders for any employee on a page without having ...
Get ASP.NET Developer's JumpStart 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.
