MDAC 2.5 SDK - OLE DB Providers
OLE DB Persistence Provider

Supported Properties of the Persistence Provider

The Persistence Provider does not introduce any new properties; it uses existing OLE DB properties and Cursor Service properties. These are saved with the rowset and reloaded when the rowset is loaded by the Persistence Provider.

Properties used by the Persistence Provider can do the following:

Define whether the rowset is updatable.
Determine whether the rowset, which is built from the stream, should support these interfaces.
Set the timeout duration of a command.
Define the maximum number of rows that can be returned.
Set the number of rows that the Cursor Service should include with query-based updates.
Determine how the Cursor Service should perform updates.
Identify the asynchronous behavior that the consumer should use to fetch the rows from the stream.

Property	Description
DBPROP_ADC_AUTORECALC	Determines when the Data Shaping Service recalculates aggregate and calculated columns within a generated hierarchical rowset by using a shape command.
DBPROP_ADC_BATCHSIZE	Property Set: DBPROPSET_ADC Default value: 15 Typical R/W: R Cursor Service–specific property that controls the number of rows that can be batched together when the rowset is being updated by the Cursor Service.
DBPROP_ADC_CUSTOMRESYNCH	Cursor Service–specific property that allows you to define the command to be used when resynchronizing a row or rows in a multitable join result set.
DBPROP_ADC_RESHAPENAME	Specific to rowsets created with the Data Shaping Service. Cursor Service–specific property that allows local references in the SHAPE command for reshaping.
DBPROP_ADC_UNIQUECATALOG	The Unique Catalog property should be used for rowsets created from a join query over multiple base tables. Cursor Service–specific property.
DBPROP_ADC_UNIQUESCHEMA	The Unique Schema property should be used for rowsets created from a join query over multiple base tables. Cursor Service–specific property.
DBPROP_ADC_UNIQUETABLE	The Unique Table property should be used for rowsets created from a join query over multiple base tables. Cursor Service–specific property.
DBPROP_ADC_UPDATECRITERIA	Property Set: DBPROPSET_ADC Default value: Typical R/W: Cursor Service–specific property that specifies the update criteria (primary keys, timestamps, modified columns, and so on) to be used for the OCC-style batch updating by the Cursor Service when updating the recordset.
DBPROP_ADC_UPDATERESYNC	Defines the behavior of the BatchUpdate method, controlling whether the batch update operation is followed by an implicit resync operation.
DBPROP_ASYNCHTHREADPRIORITY	Cursor Service–specific property used by the consumers of remoted recordsets for asynchronous operations.
DBPROP_ASYNCHFETCHSIZE	Cursor Service–specific property used by the consumers of remoted recordsets for asynchronous operations.
DBPROP_ASYNCHPREFETCHSIZE	Cursor Service–specific property used by the consumers of remoted recordsets for asynchronous operations.
DBPROP_COMMANDTIMEOUT	Property Set: DBPROPSET_ROWSET Default value: n/a Typical R/W: R/W Standard OLE DB property. Specifies the length of time after which the command should be timed out.
DBPROP_IRowsetChange	Property Set: DBPROPSET_ROWSET Default value: n/a Typical R/W: R/W with exceptions Standard OLE DB property. Specifies whether or not the rowset supports this interface. Specifically, it controls whether the remoted recordset should be updatable.
DBPROP_IRowsetUpdate	Property Set: DBPROPSET_ROWSET Default value: n/a Typical R/W: R/W with exceptions Standard OLE DB property. Specifies whether or not the rowset supports this interface. Specifically, it controls whether the remoted recordset should be batch-updatable.
DBPROP_MAXROWS	Property Set: DBPROPSET_ROWSET Default value: n/a Typical R/W: R/W Standard OLE DB property. Specifies the maximum number of rows that can be returned in a rowset.