Click or drag to resize
CqlCommand Methods

The CqlCommand type exposes the following members.

Methods
  NameDescription
Public methodBeginExecute
Starts executing the statement async
Public methodBind Obsolete.
Sets the parameter values for the query.

The same amount of values must be provided as parameter markers in the query.

Specify the parameter values by the position of the markers in the query or by name, using a single instance of an anonymous type, with property names as parameter names.

(Inherited from SimpleStatement.)
Public methodBindObjects Obsolete. (Inherited from SimpleStatement.)
Public methodDisableTracing
Disable tracing for the statement.
(Inherited from Statement.)
Public methodEnableTracing
Enables tracing for the statement
(Inherited from Statement.)
Public methodEndExecute
Starts the async executing of the statement
Public methodEquals
Determines whether the specified object is equal to the current object.
(Inherited from Object.)
Public methodExecute
Executes the command using the ISession.
Public methodExecuteAsync
Evaluates the Linq command and executes asynchronously the cql statement.
Public methodExecutingAs
Allows this statement to be executed as a different user/role than the one currently authenticated (a.k.a. proxy execution).
(Inherited from Statement.)
Public methodGetHashCode
Serves as the default hash function.
(Inherited from Object.)
Public methodGetTable
Public methodGetType
Gets the Type of the current instance.
(Inherited from Object.)
Public methodSetAutoPage
Sets the paging behavior. When set to true (default), the RowSet returned when executing this IStatement will automatically fetch the following result pages. When false, the RowSet returned will only contain the rows contained in the result page and will not fetch additional pages.
(Inherited from Statement.)
Public methodSetConsistencyLevel
Public methodSetHost
Sets the Host that should handle this query.

In the general case, use of this method is heavily discouraged and should only be used in the following cases:

  • Querying node-local tables, such as tables in the system and system_views keyspaces.
  • Applying a series of schema changes, where it may be advantageous to execute schema changes in sequence on the same node.

Configuring a specific host causes the configured ILoadBalancingPolicy to be completely bypassed. However, if the load balancing policy dictates that the host is at distance Ignored or there is no active connectivity to the host, the request will fail with a NoHostAvailableException.

(Inherited from Statement.)
Public methodSetIdempotence
Sets whether this statement is idempotent.

Idempotence of the statement plays a role in ISpeculativeExecutionPolicy. If a statement is not idempotent, the driver will not schedule speculative executions for it.

(Inherited from Statement.)
Public methodSetKeyspace
Sets the keyspace this Statement operates on. The keyspace should only be set when the IStatement applies to a different keyspace to the logged keyspace of the ISession.
(Inherited from SimpleStatement.)
Public methodSetOutgoingPayload
Sets a custom outgoing payload for this statement. Each time this statement is executed, this payload will be included in the request. Once it is set using this method, the payload should not be modified.
(Inherited from Statement.)
Public methodSetPageSize
Sets the page size for this query. The page size controls how much resulting rows will be retrieved simultaneously (the goal being to avoid loading too much results in memory for queries yielding large results). Please note that while value as low as 1 can be used, it is highly discouraged to use such a low value in practice as it will yield very poor performance. If in doubt, leaving the default is probably a good idea.

Also note that only SELECT queries ever make use of that setting.

the page size to use. If set to 0 or less, the default value will be used. To disable paging of the result set, use int.MaxValue

Return Value

Type: 
this Query object.
(Inherited from Statement.)
Public methodSetPagingState
Sets the paging state, a token representing the current page state of query used to continue paging by retrieving the following result page. Setting the paging state will disable automatic paging.
(Inherited from Statement.)
Public methodSetQueryString (Inherited from SimpleStatement.)
Public methodSetQueryTrace
Public methodSetReadTimeoutMillis
Overrides the default per-host read timeout ReadTimeoutMillis for this statement.
(Inherited from Statement.)
Public methodSetRetryPolicy
Sets the retry policy to use for this query.

Calling this method is only required when you want to override the default RetryPolicy set in the cluster configuration for this request.

Use a IExtendedRetryPolicy implementation to cover all error scenarios.

(Inherited from Statement.)
Public methodSetRoutingKey
Set the routing key for this query.

This method allows to manually provide a routing key for this query. It is thus optional since the routing key is only an hint for token aware load balancing policy but is never mandatory.

If the partition key for the query is composite, use the #setRoutingKey(ByteBuffer...) method instead to build the routing key.

(Inherited from SimpleStatement.)
Public methodSetRoutingValues
Sets the partition key values in order to route the query to the correct replicas.

For simple partition keys, set the partition key value.

For composite partition keys, set the multiple the partition key values in correct order.

(Inherited from SimpleStatement.)
Public methodSetSerialConsistencyLevel
Public methodSetTimestamp
Sets the timestamp associated with this statement execution.
Public methodSetTTL
Sets the time for data in a column to expire (TTL) for INSERT and UPDATE commands .
Public methodToString (Inherited from RegularStatement.)
Top
See Also