Click or drag to resize

IActionQuery Interface

Interface for action queries. These queries do not return a resultset. Action queries execute Insert, Delete and Update statements. Generic

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
public interface IActionQuery : IQuery, 
	IDisposable

The IActionQuery type exposes the following members.

Properties
  NameDescription
Public propertyCanBePacked
Gets a value signalling whether this query can be packed in a packed query (true) or not (false). A query can be packed if it's not a batchquery and there are no parameter-parameter relations pending or parameter-field relations with self.
Public propertyCommand
The command used for this query.
(Inherited from IQuery.)
Public propertyConnection
The connection object to use with the Command
(Inherited from IQuery.)
Public propertyExecuteThroughDbDataReader
If true (Default false) it will execute the command through ExecuteReader instead of ExecuteNonQuery and will assume output parameters are part of one or more resultsets. Output parameters are expected to be added through AddOutputParameterForReader(DbParameter), and are set through ordinal (so first parameter is set with value at ordinal 0).
Public propertyForcedReturnValue
Gets or sets the forced return value. If smaller than 0, the value returned by the command is used, otherwise this value. Set by DQEs which know up front the query won't return a valid return value, because batching is used.
Public propertyOutputParametersForReader
Gets the set of parameters set for the dbdatareader fill procedure. these parameters are added through AddOutputParameterForReader(DbParameter) and aren't part of the command.
Public propertyParameterFieldRelations
Array list with the IParameterFieldRelation instances for the relations between IEntityFields and output parameters.
(Inherited from IQuery.)
Public propertyParameterParameterRelations
Gets the parameter parameter relations for this IActionQuery. These definitions are used for insert queries in multi-target entity inserts.
Public propertyParameters
The list of parameters used in the Command.
(Inherited from IQuery.)
Public propertyReturnValueParameter
If set, it will be used for the value returned in ExecuteNonQuery and will override the value ExecuteNonQuery returns or which is set in ForcedReturnValue.
Public propertySequenceRetrievalQueries
Array list of ISequenceRetrievalQuery objects which are used to produce sequence values for input/output parameters in this query. Normally this collection is empty, as it is only used when the target database provider doesn't support batched queries (firebird/access/sqlce and others). Execute will wire the transaction if present.
Top
Methods
  NameDescription
Public methodAddOutputParameterForReader
Adds the specified parameter to the set of output parameters for a dbreader exectured query. These parameters aren't part of the dbcommand, and are filled with resultsets. All parameters are expected in each resultsets returned by the dbdatareader returned when this query is executed.
Public methodAddOutputParameterValueForSync
Adds the output parameter value for synchronization with the enclosed DbParameter, after the query has been executed.
(Inherited from IQuery.)
Public methodAddParameter
Adds the parameter to the query's command.
(Inherited from IQuery.)
Public methodAddParameterFieldRelation(IEntityFieldCore, DbParameter, TypeConverter)
Adds a new IParameterFieldRelation to the collection of ParameterFieldRelations. An output parameter can be stored once in the collection.
(Inherited from IQuery.)
Public methodAddParameterFieldRelation(IEntityFieldCore, DbParameter, TypeConverter, Boolean)
Adds a new IParameterFieldRelation to the collection of ParameterFieldRelations. An output parameter can be stored once in the collection.
(Inherited from IQuery.)
Public methodAddParameters
Adds the parameters to the query's command.
(Inherited from IQuery.)
Public methodAddSequenceRetrievalQuery(DbCommand, Boolean)
Adds a new sequence retrieval query to this query
Public methodAddSequenceRetrievalQuery(DbCommand, Boolean, Boolean)
Adds a new sequence retrieval query to this query
Public methodAddSequenceRetrievalQuery(DbCommand, Boolean, ListDbParameter)
Adds a new sequence retrieval query to this query
Public methodAddSequenceRetrievalQuery(DbCommand, Boolean, Boolean, ListDbParameter)
Adds a new sequence retrieval query to this query
Public methodDispose
Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources.
(Inherited from IDisposable.)
Public methodExecute
Executes the query contained by the IQuery instance.
Public methodExecuteAsync
Async variant of Execute. Executes the query contained by the IQuery instance.
Public methodMergeInto
Merges all data of query into this query's QueryToExecute. It moves parameters and other elements. Query is after this not usable anymore.
Public methodReflectOutputValuesInParameterValues
Reflects the output values of output parameters in parameter values, if any.
(Inherited from IQuery.)
Public methodReflectOutputValuesInRelatedFields
Will walk all IParameterFieldRelation instances of this query and reflect the parameter values in the related fields. Only output parameters are taken into account.
(Inherited from IQuery.)
Public methodSetCommandText
Sets the command text to the text specified
(Inherited from IQuery.)
Public methodSetCommandTimeout
Sets the command timeout.
(Inherited from IQuery.)
Public methodWireTransaction
Wires the command of this query with the transaction passed in.
(Inherited from IQuery.)
Top
See Also