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 ADO.NET

ADO.NET¶

Implementation of the ADO.NET interfaces and common abstract classes present in the System.Data namespace of the .NET Framework: IDbConnection, IDbCommand, and IDbDataAdapter.

It allows users to interact with a cluster using a common .NET data access pattern.

ADO.NET design limits how you can interact with the cluster (sync only, open / close pattern), for that reason it is recommended that you use the other components of the driver instead.

Example¶

var connection  = new CqlConnection(connectionString);
connection.Open();
try
{
   var command = connection.CreateCommand();
   command.CommandText = "UPDATE tbl SET val = 'z' WHERE id = 1";
   command.ExecuteNonQuery();
}
finally
{
   connection.Close();
}

Was this page helpful?

PREVIOUS
Driver components
NEXT
Core component
  • Create an issue
  • Edit this page

On this page

  • ADO.NET
    • Example
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