Oracle® Data Provider for .NET Developer's Guide 10g Release 1 (10.1) Part Number B10117-01 |
|
|
View PDF |
The OracleDataAdapter
Requery
property controls whether queries are reexecuted for OracleDataAdapter
Fill
calls after the initial Fill
call.
The OracleDataAdapter
Fill
method allows appending or refreshing data in the DataSet
. When appending the DataSet
using the same query with subsequent Fill
calls, it may be desired not to reexecute the query.
When the Requery
property is set to true
, each subsequent Fill
call reexecutes the query and fills the DataSet
. It is an expensive operation and if the reexecution is not required, set Requery
to false
. If any of the SelectCommand
properties or associated parameters needs to be changed, Requery
must be true
.
When the Requery
property is set to false
, the DataSet
has the entire data as a snapshot at a particular time. The query is executed only for the first Fill
call, subsequent Fill
calls fetch the data from a cursor opened with the first execution of the query. This feature is only supported for forward-only fetches. Fill
calls that try to fetch rows before the last fetched row raise an exception. The connection used for the first Fill
call must be available for subsequent Fill
calls.
When filling a DataSet
with a OracleRefCursor
, the Requery
property can be used in a similar manner. When the Requery
property is set to false
, both the connection used for the first Fill
and the OracleRefCursor
must be available for the subsequent Fill
calls.