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.6.0.0 (5.6.19.0117)
SyntaxThe ISequenceRetrievalQuery type exposes the following members.
Properties| Name | Description | |
|---|---|---|
 | ExecuteSequenceCommandFirst |
Flag to signal if SequenceRetrievalCommand has to be executed before (true) or after (false) the
actual query in this ActionQuery object.
|
| SequenceParameters |
Array list with the parameter objects in the actual query which need the value returned by the execution of the command
|
| SequenceRetrievalCommand |
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.
|
| SetParametersAsOutputParameters |
Used to make SequenceParameters 'output' parameters. Required for Access. Default: false;
|
Methods| Name | Description | |
|---|---|---|
 | AddSequenceParameter |
Adds the sequence parameter.
|
| Dispose | Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources. (Inherited from IDisposable.) |
| Execute |
Executes the scalar query contained in this object. (Executed with ExecuteScalar())
Expects that the command can be executed without problems.
|
| ExecuteAsync |
Async variant of Execute.
Executes the scalar query contained in this object. (Executed with ExecuteScalar())
Expects that the command can be executed without problems.
|
See Also