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.11.0.0 (5.11.23.1114)

Syntax

Copy

[SerializableAttribute]
public class SequenceRetrievalQuery : ISequenceRetrievalQuery, 
	IDisposable

<SerializableAttribute>
Public Class SequenceRetrievalQuery
	Implements ISequenceRetrievalQuery, IDisposable

The SequenceRetrievalQuery type exposes the following members.

Constructors

	Name	Description
	SequenceRetrievalQuery	Initializes a new instance of the SequenceRetrievalQuery class.
	SequenceRetrievalQuery(DbCommand, Boolean)	Initializes a new instance of the Object class.
	SequenceRetrievalQuery(DbCommand, Boolean, ListDbParameter)	Initializes a new instance of the Object class.
	SequenceRetrievalQuery(DbCommand, Boolean, Boolean, ListDbParameter)	Initializes a new instance of the Object class.

Top

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	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;

Top

Methods

	Name	Description
	AddSequenceParameter	Adds the sequence parameter.
	Dispose	Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources.
	Dispose(Boolean)	Performs the dispose action.
	Equals	Determines whether the specified object is equal to the current object. (Inherited from Object.)
	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.
	Finalize	Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.)
	GetHashCode	Serves as the default hash function. (Inherited from Object.)
	GetType	Gets the Type of the current instance. (Inherited from Object.)
	MemberwiseClone	Creates a shallow copy of the current Object. (Inherited from Object.)
	ToString	ToString representation of Sequence query, used in Trace logs. (Overrides ObjectToString.)
	ToString(Boolean)	Returns a String that represents this instance.

Top

Reference

SD.LLBLGen.Pro.ORMSupportClasses Namespace