Click or drag to resize

PreparedStatement Methods

The PreparedStatement type exposes the following members.

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 methodEquals
Determines whether the specified object is equal to the current object.
(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.)
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.

Public methodToString
Returns a string that represents the current object.
(Inherited from Object.)
See Also