System.Data.Common Namespace

---

Aids implementation of the IDbDataAdapter interface. Inheritors of DbDataAdapter implement a set of functions to provide strong typing, but inherit most of the functionality needed to fully implement a DataAdapter.

DbDataAdapter Class Members

Show Inherited Members

Fields Visibility Name Type public static const DefaultSourceTableName String   Properties Visibility Name Value Type Accessibility public DeleteCommand DbCommand [ Get , Set ] public InsertCommand DbCommand [ Get , Set ] public SelectCommand DbCommand [ Get , Set ] public UpdateBatchSize Int32 [ Get , Set ] public UpdateCommand DbCommand [ Get , Set ]   Methods Visibility Name Parameters Return Type protected AddToBatch ( IDbCommand command ) Int32 protected ClearBatch ( ) Void protected CreateRowUpdatedEvent ( DataRow dataRow , IDbCommand command , StatementType statementType , DataTableMapping tableMapping ) RowUpdatedEventArgs protected CreateRowUpdatingEvent ( DataRow dataRow , IDbCommand command , StatementType statementType , DataTableMapping tableMapping ) RowUpdatingEventArgs protected Dispose ( Boolean disposing ) Void protected ExecuteBatch ( ) Int32 public Fill ( DataTable dataTable ) Int32 protected Fill ( DataSet dataSet , Int32 startRecord , Int32 maxRecords , String srcTable , IDbCommand command , CommandBehavior behavior ) Int32 public Fill ( DataSet dataSet , Int32 startRecord , Int32 maxRecords , String srcTable ) Int32 protected Fill ( DataTable dataTables , Int32 startRecord , Int32 maxRecords , IDbCommand command , CommandBehavior behavior ) Int32 protected Fill ( DataTable dataTable , IDbCommand command , CommandBehavior behavior ) Int32 public Fill ( Int32 startRecord , Int32 maxRecords , DataTable dataTables ) Int32 public Fill ( DataSet dataSet , String srcTable ) Int32 public Fill ( DataSet dataSet ) Int32 public FillSchema ( DataSet dataSet , SchemaType schemaType ) DataTable public FillSchema ( DataTable dataTable , SchemaType schemaType ) DataTable public FillSchema ( DataSet dataSet , SchemaType schemaType , String srcTable ) DataTable protected FillSchema ( DataTable dataTable , SchemaType schemaType , IDbCommand command , CommandBehavior behavior ) DataTable protected FillSchema ( DataSet dataSet , SchemaType schemaType , IDbCommand command , String srcTable , CommandBehavior behavior ) DataTable protected GetBatchedParameter ( Int32 commandIdentifier , Int32 parameterIndex ) IDataParameter protected GetBatchedRecordsAffected ( Int32 commandIdentifier , Int32& recordsAffected , Exception& error ) Boolean public GetFillParameters ( ) IDataParameter protected InitializeBatching ( ) Void protected OnRowUpdated ( RowUpdatedEventArgs value ) Void protected OnRowUpdating ( RowUpdatingEventArgs value ) Void protected TerminateBatching ( ) Void public Update ( DataSet dataSet , String srcTable ) Int32 protected Update ( DataRow dataRows , DataTableMapping tableMapping ) Int32 public Update ( DataTable dataTable ) Int32 public Update ( DataSet dataSet ) Int32 public Update ( DataRow dataRows ) Int32

The DbDataAdapter class inherits from the DataAdapter class and helps a class implement a DataAdapter designed for use with a relational database.

An application does not create an instance of the DbDataAdapter interface directly, but initializes an instance of a class that inherits IDbDataAdapter and DbDataAdapter.

Classes that inherit DbDataAdapter must implement the inherited members, and typically define additional members to add provider-specific functionality. For example, the DbDataAdapter class defines the SelectCommand property, and the DbDataAdapter interface defines eight overloads of the Fill method. In turn, the OleDbDataAdapter class inherits the Fill method, and also defines two additional overloads of Fill that take an ADO Recordset object as a parameter.

Notes to Inheritors: When you inherit from the DbDataAdapter class, it is recommended that you implement the following constructors:

Item	Description
PrvDataAdapter ( )	Initializes a new instance of the PrvDataAdapter class.
PrvDataAdapter ( SqlCommand selectCommand )	Initializes a new instance of the PrvDataAdapter class with the specified SQL SELECT statement.
PrvDataAdapter ( string selectCommandText, string selectConnectionString )	Initializes a new instance of the PrvDataAdapter class with an SQL SELECT statement and a connection string.
PrvDataAdapter ( string selectCommandText, SqlConnection selectConnection )	Initializes a new instance of the PrvDataAdapter class with an SQL SELECT statement and a PrvConnection object.

To promote consistency among .NET data providers, you should name the inheriting class in the form Prv DataAdapter where Prv is the uniform prefix given to all classes in a specific .NET data provider namespace. For example, Sql is the prefix of the SqlDataAdapter class in the System.Data.SqlClient namespace.

DataAdapter   IDbCommand   IDbConnection

Suggested Reading