Appendix C: 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 updateable.

  • 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 updateable.

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-updateable.

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.

This topic is a part of:

Show: