| PreparedStatement Class |
A prepared statement can be executed once concrete values has been provided for the bound variables. The pair of a prepared statement and values for its bound variables is a BoundStatement and can be executed (by Session#Execute).
Inheritance HierarchyCassandraPreparedStatement
Namespace: Cassandra
Assembly: Cassandra (in Cassandra.dll) Version: 3.7.0
Syntaxpublic class PreparedStatement
The PreparedStatement type exposes the following members.
Constructors| Name | Description | |
|---|---|---|
 | PreparedStatement |
Initializes a new instance of the Cassandra.PreparedStatement class
|
Methods| Name | Description | |
|---|---|---|
 | Bind | 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. |
| SetConsistencyLevel |
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. |
| SetIdempotence |
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. |
| SetOutgoingPayload |
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.
|
| SetRoutingKey |
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. |
| SetRoutingNames |
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. |
Properties| Name | Description | |
|---|---|---|
 | ConsistencyLevel |
Gets the default consistency level for all executions using this instance
|
| IncomingPayload |
Gets the the incoming payload, that is, the payload that the server
sent back with its prepared response, or null if the server did not include any custom payload.
|
| IsIdempotent |
Determines if the query is idempotent, i.e. whether it can be applied multiple times without
changing the result beyond the initial application.
Idempotence of the prepared statement plays a role in ISpeculativeExecutionPolicy. If a query is not idempotent, the driver will not schedule speculative executions for it. When the property is null, the driver will use the default value from the GetDefaultIdempotence. |
| OutgoingPayload |
Gets custom payload for that will be included when executing an Statement.
|
| RoutingIndexes |
Gets or sets the parameter indexes that are part of the partition key
|
| RoutingKey |
Gets the routing key for the prepared statement.
|
| Variables |
Gets metadata on the bounded variables of this prepared statement.
|
See Also