Click or drag to resize
PreparedStatement Methods

The PreparedStatement type exposes the following members.

Methods
  NameDescription
Public methodCode exampleBind

Creates a new BoundStatement instance with the provided parameter values.

You can 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.

Note that while no more values than bound variables can be provided, it is allowed to provide less values that there is variables.

You can provide a comma-separated variable number of arguments to the Bind() method. When providing an array, the reference might be used by the driver making it not safe to modify its content.

Public methodSetConsistencyLevel
Sets a default consistency level for all BoundStatement created from this object.

If no consistency level is set through this method, the BoundStatement created from this object will use the default consistency level (One).

Changing the default consistency level is not retroactive, it only applies to BoundStatement created after the change.

Public methodSetIdempotence
Sets whether the prepared statement is idempotent.

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

Public methodSetOutgoingPayload
Sets a custom outgoing payload for this statement. Each time an statement generated using this prepared statement is executed, this payload will be included in the request. Once it is set using this method, the payload should not be modified.
Public methodSetRoutingKey
Set the routing key for this query.

The routing key is a hint for token aware load balancing policies but is never mandatory. This method allows you to manually provide a routing key for this query.

Use this method ONLY if the partition keys are the same for all query executions (hard-coded parameters).

If the partition key is composite, you should provide multiple routing key components.

Public methodSetRoutingNames
For named query markers, it sets the parameter names that are part of the routing key.

Use this method ONLY if the parameter names are different from the partition key names.

Top
See Also