O'Reilly logo

Essential ADO.NET by Bob Beauchemin

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

5.2. DataAdapter Classes

The DataAdapter class contains four Command instances as member variables. It uses SelectCommand to move data from the database to DataSet and uses InsertCommand, UpdateCommand, and DeleteCommand to flush updates made to the DataSet back to the database. Figure 5-1 shows the classes that participate in DataSet interactions when you use the SqlClient data provider.

Figure 5-1. DataAdapter Model for SqlClient

Both the SqlClient provider and the OleDb provider implement DataAdapters derived from a common base class, DbDataAdapter. Most custom providers, such as the ODBC data provider, also use this base class. System.Data.Common ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required