DataStax C# driver

Use the unified DataStax C# driver to connect to your DataStax Astra DB database and begin building your own application.

DataStax recommends using the unified DataStax C# driver. If you have an existing Apache Cassandra or DataStax Enterprise (DSE) C# driver, migrate the driver to a version that is capable of connecting to Astra DB databases.

Prerequisites

Procedure

  1. Create a new C# project and configure it to connect to your Cassandra database.

mkdir csharpproject
cd csharpproject
dotnet new console
  1. Add the dependencies for the C# driver to your project.

dotnet add package CassandraCSharpDriver -v 3.15.0
  1. Replace the code in Program.cs with the following code to connect to your Astra DB database.

Include the absolute path to the secure connect bundle for your Astra DB database (secure-connect-database_name.zip) in the WithCloudSecureConnectionBundle method call, and your credentials in the WithCredentials method call, as shown in the following examples.

using System;
using System.Linq;
using Cassandra;

namespace csharpproject
{
    class Program
    {
        static void Main(string[] args)
        {
            var session =
                Cluster.Builder()
                       .WithCloudSecureConnectionBundle(@"C:\path\to\secure-connect-database_name.zip")
                       .WithCredentials("clientId", "clientSecret")
                       .Build()
                       .Connect();
        }
    }
}
  1. After the connection code, add the following code to the Main method in Program.cs. This code runs a CQL query, and prints the output to the console.

var rowSet = session.Execute("select * from system.local");
Console.WriteLine(rowSet.First().GetValue<string>("cluster_name"));
  1. Run your C# project with the dotnet runtime.

dotnet restore
dotnet build
dotnet run --no-build