ScyllaDB University Live | Free Virtual Training Event
Learn more
ScyllaDB Documentation Logo Documentation
  • Server
  • Cloud
  • Tools
    • ScyllaDB Manager
    • ScyllaDB Monitoring Stack
    • ScyllaDB Operator
  • Drivers
    • CQL Drivers
    • DynamoDB Drivers
  • Resources
    • ScyllaDB University
    • Community Forum
    • Tutorials
Download
ScyllaDB Docs ScyllaDB C# driver Features Driver components Core component Statements

Statements¶

Quick overview¶

Statements are what you pass to Session.Execute() and Session.ExecuteAsync().

There are three types:

  • SimpleStatement: a simple implementation built directly from a character string. Typically used for queries that are executed only once or a few times.

  • BoundStatement (from PreparedStatement): obtained by binding values to a prepared query. Typically used for queries that are executed often, with different values.

  • BatchStatement: a statement that groups multiple statements to be executed as a batch.

All statement types share a common set of execution attributes, that can be set through setters:

  • execution profile name.

  • idempotent flag.

  • tracing flag.

  • query timestamp.

  • page size and paging state.

  • per-query keyspace (Cassandra 4 or above).

  • token-aware routing information (keyspace and key/token).

  • normal and serial consistency level.

  • read timeout.

  • custom payload to send arbitrary key/value pairs with the request (you should only need this if you have a custom query handler on the server).

Note that some attributes can either be set programmatically, or inherit a default value defined in the Builder. We recommended setting these values in the Builder whenever possible (you can create execution profiles to capture common combinations of those options).

Was this page helpful?

PREVIOUS
Core component
NEXT
Batch statements
  • Create an issue
  • Edit this page

On this page

  • Statements
    • Quick overview
ScyllaDB C# driver
  • master
    • master
  • Features
    • Address resolution
    • Authentication and Authorization
    • Automatic failover
    • Column Encryption
    • Driver components
      • ADO.NET
      • Core component
        • Statements
          • Batch statements
          • Per-query keyspace
          • Prepared statements
          • Simple statements
      • Linq component
        • Batch statements with LINQ
      • Mapper component
        • Batch statements with the Mapper
    • Connection heartbeat
    • Connection pooling
    • CQL data types to C# types
      • Date and time representation
      • Nulls and unset
    • Execution Profiles
    • Graph support
    • Cluster and schema metadata
    • Metrics
      • App.Metrics Provider
      • List of metrics
    • Native protocol
    • OpenTelemetry
    • Result paging
    • Parameterized queries
    • Query timestamps
    • Query warnings
    • Request Tracker
    • Routing queries
    • Speculative query execution
    • TLS/SSL
    • Tuning policies
    • User-defined functions and aggregates
    • User-defined types
    • Vector support
  • FAQ
  • Upgrade Guide
  • Examples
  • API Reference
Docs Tutorials University Contact Us About Us
© 2025 ScyllaDB | Terms of Service | Privacy Policy | ScyllaDB, and ScyllaDB Cloud, are registered trademarks of ScyllaDB, Inc.
Last updated on 01 Aug 2025.
Powered by Sphinx 7.4.7 & ScyllaDB Theme 1.8.7
Ask AI