Essential ADO.NET

8.8. Implementing the DataAdapter Class

Because there is a canned implementation of a DataAdapter in System.Data.Common, it's relatively straightforward to implement your custom DataAdapter as a specialization of the base. In our case, the fact that the data provider is read-only makes implementation trivial.

8.8.1. Specification

The DataAdapter class is one of the few data provider classes that are implemented through a common base. Provider-specific DataAdapters inherit from DbDataAdapter, which inherits from DataAdapter. These classes implement IDataAdapter—which defines Fill and Update methods that interact with DataSet—and IDbDataAdapter. The latter exposes a set of four Commands—SelectCommand, UpdateCommand, InsertCommand, and DeleteCommand ...