How is ADO.NET any different from ADO?
• In ADO, the in-memory representation of data is the Recordset. In ADO.NET, it is the DataSet. A Recordset works as a single table. In contrast, a DataSet is a collection of one or more tables. In this way, a dataset can mimic the structure of the underlying database. Because the DataSet can hold multiple, separate tables and maintain information about relationships between them, it can hold much richer data structures than a recordset, including self-relating tables and tables with many relationships • Transmitting an ADO.NET DataSet between applications is much easier than transmitting an ADO disconnected Recordset. To transmit an ADO disconnected Recordset from one component to another, you use COM marshaling. To transmit data in ADO.NET, you use a DataSet, which can transmit an XML stream. • In ADO, you scan sequentially through the rows of the recordset using the ADO MoveNext method. In ADO.NET, rows are represented as collections, so you can loop through a table as you would thr
