IRetrievalQuery Properties

Gets or sets how long the resulset as a cached resultset should be placed in the cache.

Gets or sets a value indicating whether the resultset should be cached.

Gets or sets the tag the resultset should be cached under. By default this is the empty string (no tag)

The command used for this query.

The connection object to use with the Command

Only valid when RequiresClientSidePaging is set to true.

Only valid when RequiresClientSidePaging is set to true.

Gets a value indicating whether name overwriting has to take place (false) or not (true). Is true when this query was created from a proc call where name overwriting was already applied.

if set to true it will replace an existing cached set with the one specified.

Array list with the IParameterFieldRelation instances for the relations between IEntityFields and output parameters.

The list of parameters used in the Command.

Gets or sets the optional tag for the SQL query/queries to relate SQL strings in an RDBMS with an origin.

Flag to tell the object fetcher to use manual distinct filtering, as the DISTINCT command couldn't be applied. Used to tell paging wrappers to set RequiresClientSidePaging.

Gets / sets the flag which signals fetch code to use client side (i.e. in code) limitation logic and it should not rely on the amount of rows returned for row limitations. This flag is set by DQEs if DISTINCT can't be used but row limitations are required and TOP is thus not reliable. Default: false. If set, ManualRowsToTake is the amount to read.

Flag to tell the object fetcher to use manual paging. This is required when DISTINCT is required however due to DISTINCT violating types it can't be applied to the query. This then causes duplicates in the resultset, which shouldn't be there and thus causing pages with much lesser data. Only set by a DQE, normally false.

Gets or sets the resultset number to retrieve. This is a 1-based number (so first resultset is numbered '1', which is also the default). If set to 2 or higher, Execute will call NextResult() on the datareader till the required resultset is reached or NextResult returns false. If set to 0 or lower, the number is ignored.