Click or drag to resize

ISequenceRetrievalQuery Interface

Interface for sequence retrieval queries. Sequence retrieval queries are scalar queries (returning a value) which are used to retrieve the actual / to use sequence value in systems which do not support batched queries. Normally every DQE will batch the sequence retrieval query into the INSERT query as a batched query, however some systems do not support this and the only solution is the SequenceRetrievalQuery. Used for Access, Firebird and other systems. SequenceRetrievalQueries can be added to IActionQuery instances and will use the IActionQuery object's connection object.

Namespace:  SD.LLBLGen.Pro.ORMSupportClasses
Assembly:  SD.LLBLGen.Pro.ORMSupportClasses (in SD.LLBLGen.Pro.ORMSupportClasses.dll) Version: 5.5.0.0 (5.5.18.1019)
Syntax
public interface ISequenceRetrievalQuery : IDisposable

The ISequenceRetrievalQuery type exposes the following members.

Properties
  NameDescription
Public propertyExecuteSequenceCommandFirst
Flag to signal if SequenceRetrievalCommand has to be executed before (true) or after (false) the actual query in this ActionQuery object.
Public propertySequenceParameters
Array list with the parameter objects in the actual query which need the value returned by the execution of the command
Public propertySequenceRetrievalCommand
The Scalar command used to retrieve the used/to use sequence value. This command will be executed as a scalar query and depending on ExecuteSequenceCommandFirst it will be executed before or after the actual query.
Public propertySetParametersAsOutputParameters
Used to make SequenceParameters 'output' parameters. Required for Access. Default: false;
Top
Methods
  NameDescription
Public methodAddSequenceParameter
Adds the sequence parameter.
Public methodDispose
Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources.
(Inherited from IDisposable.)
Public methodExecute
Executes the scalar query contained in this object. (Executed with ExecuteScalar()) Expects that the command can be executed without problems.
Public methodExecuteAsync
Async variant of Execute. Executes the scalar query contained in this object. (Executed with ExecuteScalar()) Expects that the command can be executed without problems.
Top
See Also