ITableOperationsPrimaryKeyCache Property

DataTable? PrimaryKeyCache { get; set; }

Property PrimaryKeyCache As DataTable
	Get
	Set

property DataTable^ PrimaryKeyCache {
	DataTable^ get ();
	void set (DataTable^ value);
}

function get_PrimaryKeyCache();
function set_PrimaryKeyCache(value);

Property Value

The QueryRecords(String, Boolean, Int32, Int32, IRecordFilter) overloads that include paging parameters cache the sorted and filtered primary keys of queried records between calls so that paging is fast and efficient. Since the primary keys are cached, an instance of the TableOperationsT should exist per user session when using query functions that support pagination. In web based implementations, the primary cache should be stored with user session state data and then restored between instances of the TableOperationsT that are created along with a connection that is opened per page.

The function ClearPrimaryKeyCache should be called to manually clear cache when table contents are known to have changed. Note that calls to any DeleteRecord(Object) overload will automatically clear any existing primary key cache.

Primary keys values are stored in data table without interpretation, i.e., in their raw form as queried from the database. Primary key data in cache will be encrypted for models with primary key fields that are marked with the EncryptDataAttribute

Reference