Summary
The comparison chart in Table 9.4 summarizes the improvements in ADO.NET over ADO.
| Feature | ADO | ADO.NET |
|---|---|---|
| In-memory data representation (where data is cached in memory) | Uses a RecordSet object that represents a single table. | Uses a DataSet object that can contain one or more tables represented by the DataTable object. The ADO RecordSet object has been eliminated. |
| Relationships between tables | Requires a SQL JOIN query to pull together data from multiple tables into a single table. | Uses a DataRelation object to associate rows in one DataTable to rows in another DataTable. |
| Data access | Uses the MoveFirst and MoveNext commands to iterate through a RecordSet. | Uses a DataReader object to sequence ... |
Get Special Edition Using® Microsoft® ASP.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.
