OracleDataAdapter Members

OracleDataAdapter members are listed in the following tables.

OracleDataAdapter Constructors

OracleDataAdapter constructors are listed in Table 7-65.

Table 7-65 OracleDataAdapter Constructors

Constructor Description

OracleDataAdapter Constructors

Instantiates a new instance of OracleDataAdapter class (Overloaded)

OracleDataAdapter Static Methods

The OracleDataAdapter static method is listed in Table 7-66.

Table 7-66 OracleDataAdapter Static Method

Method Description

Equals

Inherited from System.Object (Overloaded)

OracleDataAdapter Properties

OracleDataAdapter properties are listed in Table 7-67.

Table 7-67 OracleDataAdapter Properties

Property Description

AcceptChangesDuringFill

Inherited from System.Data.Common.DataAdapter

Container

Inherited from System.ComponentModel.Component

ContinueUpdateOnError

Inherited from System.Data.Common.DataAdapter

DeleteCommand

A SQL statement or stored procedure to delete rows from an Oracle database

IdentityInsert

Determines whether or not to insert identity column values in the DataSet into the database when the Update method is invoked.

Not Available in the ODP.NET, Managed Driver and ODP.NET Core

IdentityUpdate

Determines whether or not to update identity column values in the DataSet into the database when the Update method is invoked.

Not Available in the ODP.NET, Managed Driver and ODP.NET Core

InsertCommand

A SQL statement or stored procedure to insert new rows into an Oracle database

MissingMappingAction

Inherited from System.Data.Common.DataAdapter

MissingSchemaAction

Inherited from System.Data.Common.DataAdapter

Requery

Determines whether or not the SelectCommand is reexecuted on the next call to Fill

ReturnProviderSpecificTypes

Determines if the Fill method returns ODP.NET-specific values or .NET common language specification values

SafeMapping

Creates a mapping between column names in the result set to .NET types, to preserve the data

Not Available in the ODP.NET, Managed Driver and ODP.NET Core

SelectCommand

A SQL statement or stored procedure that returns a single or multiple result set

Site

Inherited from System.ComponentModel.Component

SuppressGetDecimalInvalidCastException

Specifies whether to suppress the InvalidCastException and return a rounded-off 28 or 29 precision Oracle NUMBER value that can be represented as a .NET decimal.

TableMappings

Inherited from System.Data.Common.DataAdapter

UpdateBatchSize

Specifies a value that enables or disables batch processing support, and specifies the number of SQL statements that can be executed in a single round-trip to the database

UpdateCommand

A SQL statement or stored procedure to update rows from the DataSet to an Oracle database

OracleDataAdapter Public Methods

OracleDataAdapter public methods are listed in Table 7-68.

Table 7-68 OracleDataAdapter Public Methods

Public Method Description

CreateObjRef

Inherited from System.MarshalByRefObject

Dispose

Inherited from System.ComponentModel.Component

Equals

Inherited from System.Object (Overloaded)

Fill

Adds or refreshes rows in the DataSet to match the data in the Oracle database (Overloaded)

FillSchema

Inherited from System.Data.Common.DbDataAdapter

GetFillParameters

Inherited from System.Data.Common.DbDataAdapter

GetHashCode

Inherited from System.Object

GetLifetimeService

Inherited from System.MarshalByRefObject

GetType

Inherited from System.Object

InitializeLifetimeService

Inherited from System.MarshalByRefObject

ToString

Inherited from System.Object

Update

Inherited from System.Data.Common.DbDataAdapter

OracleDataAdapter Events

OracleDataAdapter events are listed in Table 7-69.

Table 7-69 OracleDataAdapter Events

Event Name Description

Disposed

Inherited from System.ComponentModel.Component

FillError

Inherited from System.Data.Common.DbDataAdapter

RowUpdated

This event is raised when row(s) have been updated by the Update() method

RowUpdating

This event is raised when row data are about to be updated to the database