Click or drag to resize

SequenceRetrievalQuery Class

Class 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.
Inheritance Hierarchy
SystemObject
  SD.LLBLGen.Pro.ORMSupportClassesSequenceRetrievalQuery

Namespace:  SD.LLBLGen.Pro.ORMSupportClasses
Assembly:  SD.LLBLGen.Pro.ORMSupportClasses (in SD.LLBLGen.Pro.ORMSupportClasses.dll) Version: 5.8.0.0 (5.8.21.0111)
Syntax
[SerializableAttribute]
public class SequenceRetrievalQuery : ISequenceRetrievalQuery, 
	IDisposable

The SequenceRetrievalQuery type exposes the following members.

Constructors
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
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.
Protected methodDispose(Boolean)
Performs the dispose action.
Public methodEquals
Determines whether the specified object is equal to the current object.
(Inherited from Object.)
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.
Protected methodFinalize
Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.
(Inherited from Object.)
Public methodGetHashCode
Serves as the default hash function.
(Inherited from Object.)
Public methodGetType
Gets the Type of the current instance.
(Inherited from Object.)
Protected methodMemberwiseClone
Creates a shallow copy of the current Object.
(Inherited from Object.)
Public methodToString
ToString representation of Sequence query, used in Trace logs.
(Overrides ObjectToString.)
Public methodToString(Boolean)
Returns a String that represents this instance.
Top
See Also