|TABLE 1: Some Dedicated ADO.NET Objects|
||The DataAdapter object provides a bridge between the database and a DataSet. The key advantage of DataAdapter is that it can work with any data source. The data source might be a database or it might be an XML document.
||The DataReader object provides an efficient way to retrieve records on the server side. DataReader is a connected, read-only, and forward-only data-access mode. This object is useful for Web applications, which use DataReader to display records on Web pages.
||The DataSet object provides disconnected copies of records from a database. The DataSet object stores records from a table (or multiple tables) in memory without holding a connection to the server. When in memory, DataSet is a binary object. When the DataSet is remoted, transferred, or serialized, it's represented as a DiffGraman XML format. Because XML is plaintext, records can be exchanged easily over the Web, bypassing firewall restrictions. DataSet also contains various objectssuch as constraints, relationships, and viewsthat let you manipulate tables on the client side instead of working through one Recordset in ADO.