Connect the C# driver to your database

The C# driver supports the vector data type. These instructions are for users connecting to Hyper-Converged Database (HCD).

This example creates a new C# project and configures it to connect to your HCD database. It adds dependencies, connection code, and code to run a CQL query and print the output to the console.

Prerequisite

Connect to your database

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

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

    dotnet add package CassandraCSharpDriver -v <version>
  3. Replace the code in Program.cs with the following code to connect to your HCD database.

    Include 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()
                           .WithCredentials("username", "password")
                           .Build()
                           .Connect();
            }
        }
    }
  4. 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"));
  5. Run your C# project with the dotnet runtime.

    dotnet restore
    dotnet build
    dotnet run --no-build

Installation and data migration instructions are located in the C# driver quickstart.

Was this helpful?

Give Feedback

How can we improve the documentation?

© 2024 DataStax | Privacy policy | Terms of use

Apache, Apache Cassandra, Cassandra, Apache Tomcat, Tomcat, Apache Lucene, Apache Solr, Apache Hadoop, Hadoop, Apache Pulsar, Pulsar, Apache Spark, Spark, Apache TinkerPop, TinkerPop, Apache Kafka and Kafka are either registered trademarks or trademarks of the Apache Software Foundation or its subsidiaries in Canada, the United States and/or other countries. Kubernetes is the registered trademark of the Linux Foundation.

General Inquiries: +1 (650) 389-6000, info@datastax.com