OracleDataAdapter Properties

OracleDataAdapter properties are listed in Table 6-73.

Table 73 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 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

See Also: