Support

Connect to Cassandra with C#

In this article, we will introduce how to connect to Cassandra by using C#. Firstly we will walk through installing and configuring a C# development environment and then provide simple examples for connecting, with and without TLS to the remote Cassandra server.

Please refer to our support documentation here for general information on connecting to your Cassandra Cluster first.

Download and install Visual Studio

Go to visualstudio to download and install Visual Studio.

Once installed create a new Console C# project.

Install Cassandra C# driver

Install Cassandra C# Driver using your choice of package manager, here is an example using NuGet.

In the search bar, search for and select NuGet package manager

Search for and install CassandraCSharpDriver in the NuGet Package manager window.

If you unfold the Packages folder in the sidebar, you should now see CassandraCSharpDriver in the list of packages installed.

Connecting without TLS

Replace Program.cs with the following example.

Replace Public IP’s, Data Centre, username and password with your required configuration.

Run the code by clicking on the green arrow in the toolbar.

Write Sample Code

using System;
using Cassandra;

namespace Instaclustr.Cassandra.ConnectionSample
{
    class CassandraConnectSample
    {
        public static void Main(string[] args)
        {
            Console.WriteLine("Hello Cassandra!");

            var cluster = Cluster.Builder()
.AddContactPoints(<PUBLIC IP1>, <PUBLIC IP2>, <PUBLIC IP3>,..)
                                 .WithPort(9042)
                                 .WithLoadBalancingPolicy(new DCAwareRoundRobinPolicy("<Data Centre (e.g AWS_VPC_US_EAST_1)>"))
                                 .WithAuthProvider(new PlainTextAuthProvider(<Username>, <Password>))
                                 .Build();
var session = cluster.Connect();
            Console.WriteLine("Connected to cluster: " + cluster.Metadata.ClusterName);

            var keyspaceNames = session
                .Execute("SELECT * FROM system_schema.keyspaces")
                .Select(row => row.GetValue<string>("keyspace_name"));

            Console.WriteLine("Found keyspaces:");
            foreach (var name in keyspaceNames)
            {
                Console.WriteLine("- {0}", name);
            }
        }
    }
}

using System;

using Cassandra;

namespace Instaclustr.Cassandra.ConnectionSample

{

class CassandraConnectSample

{

public static void Main(string[] args)

{

Console.WriteLine("Hello Cassandra!");

var cluster = Cluster.Builder()

.AddContactPoints(<PUBLIC IP1>, <PUBLIC IP2>, <PUBLIC IP3>,..)

.WithPort(9042)

.WithLoadBalancingPolicy(new DCAwareRoundRobinPolicy("<Data Centre (e.g AWS_VPC_US_EAST_1)>"))

.WithAuthProvider(new PlainTextAuthProvider(<Username>, <Password>))

.Build();

var session = cluster.Connect();

Console.WriteLine("Connected to cluster: " + cluster.Metadata.ClusterName);

var keyspaceNames = session

.Execute("SELECT * FROM system_schema.keyspaces")

.Select(row => row.GetValue<string>("keyspace_name"));

Console.WriteLine("Found keyspaces:");

foreach (var name in keyspaceNames)

{

Console.WriteLine("- {0}", name);

}

The output should not have any errors and look something like this.

Connected to cluster: SampleCassandraCluster
Found keyspaces:
- system_auth
- system_schema
- system_distributed
- system
- instaclustr
- system_traces

Press any key to close this window . . .

Connected to cluster: SampleCassandraCluster

Found keyspaces:

- system_auth

- system_schema

- system_distributed

- system

- instaclustr

- system_traces

Press any key to close this window . . .

Connecting with TLS via windows

In order to connect to your TLS enabled cluster with C# please first contact our support with a request here.

After the connection has been enabled by us, TLS needs to configured on your client machine to connect to the cluster.

The CA certificates can be downloaded from your clusters Connection Info page.

Write Sample Code

Replace Program.cs with the following example.

Replace the public IP’s, username, password and path to your cluster-ca-certificate.der with your required configuration.

Run the code by clicking on the green arrow in the toolbar.

using System;
using System.Linq;
using System.Security.Authentication;
using System.Security.Cryptography.X509Certificates;
using Cassandra;

namespace Instaclustr
{
    public class CassandraConnectSample
    {
        private static readonly string[] ContactPoints = { "<Public IP1>", "<Public IP2>", "<Public IP3>" };

        private const string RootCertificatePath = @"path\to\cluster-ca-certificate.der";
        private const string Username = "<Cluster Username>";
        private const string Password = "<Cluster Password>";

        public static void Main()
        {
            var serverCertificateValidator = new CustomTrustStoreCertificateValidator(new X509Certificate2(RootCertificatePath));
            
            var sslOptions = new SSLOptions(
                // TLSv1.2 is required as of October 9, 2019.
                // See: https://www.instaclustr.com/removing-support-for-outdated-encryption-mechanisms/
                SslProtocols.Tls12,

                // Disable revocation checking (the default validation result and therefore this parameter is not used).
                false,

                // Custom validator avoids need to trust the CA system-wide.
                (sender, certificate, chain, errors) => serverCertificateValidator.Validate(certificate)
            );

            var cluster = Cluster.Builder()
                .AddContactPoints(ContactPoints)
                .WithSSL(sslOptions)
                .WithAuthProvider(new PlainTextAuthProvider(Username, Password))
                .Build();

            var session = cluster.Connect();

            Console.WriteLine("Connected to cluster: " + cluster.Metadata.ClusterName);

            var keyspaceNames = session
                .Execute("SELECT * FROM system_schema.keyspaces")
                .Select(row => row.GetValue<string>("keyspace_name"));

            Console.WriteLine("Found keyspaces:");
            foreach (var name in keyspaceNames)
            {
                Console.WriteLine("- {0}", name);
            }
        }

        private class CustomTrustStoreCertificateValidator
        {
            private readonly X509Certificate2 rootCertificate;
            public CustomTrustStoreCertificateValidator(X509Certificate2 rootCertificate)
            { 
                this.rootCertificate = rootCertificate;
            }

            public bool Validate(X509Certificate serverCertificate)
            {
                Console.WriteLine(serverCertificate.ToString());

                var chain = new X509Chain();
                
                // .NET v3
                // chain.ChainPolicy = new X509ChainPolicy()
                // {
                //     RevocationMode = X509RevocationMode.NoCheck,
                //     VerificationFlags = X509VerificationFlags.AllowUnknownCertificateAuthority,
                //     ExtraStore = { rootCertificate }
                // };

                // .NET v5
                chain.ChainPolicy = new X509ChainPolicy()
                {
                    RevocationMode = X509RevocationMode.NoCheck,
                    TrustMode = X509ChainTrustMode.CustomRootTrust,
                    CustomTrustStore = { rootCertificate }
                };
                var isValidChain = chain.Build(new X509Certificate2(serverCertificate));

                if (!isValidChain)
                {
                    foreach (var chainStatus in chain.ChainStatus)
                    {
                        Console.Error.WriteLine("Chain failed validation: {0} ({1})", chainStatus.Status, chainStatus.StatusInformation);
                    }
                    return false;
                }

                // Chain is ordered from [0]:leaf -> intermediate -> [^1]:root.

                var chainRootCertificate = chain.ChainElements[chain.ChainElements.Count - 1].Certificate;
                var isExpectedRoot = chainRootCertificate.RawData.SequenceEqual(rootCertificate.RawData);

                // For .NET v3, the AllowUnknownCertificateAuthority flag permits both PartialChain and UntrustedRoot errors for a successful result.
                // We must manually check the root certificate to ensure it is the one we expect.
                // This is no longer required in .NET v5 with CustomRootTrust support.

                if (!isExpectedRoot)
                {
                    Console.Error.WriteLine("Partial chain passed validation, but the expected root certificate was not in the chain.");
                    return false;
                }
                return true;
            }
        }
    }
}

100

101

102

103

104

105

106

107

108

109

110

111

112

using System;

using System.Linq;

using System.Security.Authentication;

using System.Security.Cryptography.X509Certificates;

using Cassandra;

namespace Instaclustr

{

public class CassandraConnectSample

{

private static readonly string[] ContactPoints = { "<Public IP1>", "<Public IP2>", "<Public IP3>" };

private const string RootCertificatePath = @"path\to\cluster-ca-certificate.der";

private const string Username = "<Cluster Username>";

private const string Password = "<Cluster Password>";

public static void Main()

{

var serverCertificateValidator = new CustomTrustStoreCertificateValidator(new X509Certificate2(RootCertificatePath));

var sslOptions = new SSLOptions(

// TLSv1.2 is required as of October 9, 2019.

// See: https://www.instaclustr.com/removing-support-for-outdated-encryption-mechanisms/

SslProtocols.Tls12,

// Disable revocation checking (the default validation result and therefore this parameter is not used).

false,

// Custom validator avoids need to trust the CA system-wide.

(sender, certificate, chain, errors) => serverCertificateValidator.Validate(certificate)

);

var cluster = Cluster.Builder()

.AddContactPoints(ContactPoints)

.WithSSL(sslOptions)

.WithAuthProvider(new PlainTextAuthProvider(Username, Password))

.Build();

var session = cluster.Connect();

Console.WriteLine("Connected to cluster: " + cluster.Metadata.ClusterName);

var keyspaceNames = session

.Execute("SELECT * FROM system_schema.keyspaces")

.Select(row => row.GetValue<string>("keyspace_name"));

Console.WriteLine("Found keyspaces:");

foreach (var name in keyspaceNames)

{

Console.WriteLine("- {0}", name);

}

private class CustomTrustStoreCertificateValidator

{

private readonly X509Certificate2 rootCertificate;

public CustomTrustStoreCertificateValidator(X509Certificate2 rootCertificate)

{

this.rootCertificate = rootCertificate;

}

public bool Validate(X509Certificate serverCertificate)

{

Console.WriteLine(serverCertificate.ToString());

var chain = new X509Chain();

// .NET v3

// chain.ChainPolicy = new X509ChainPolicy()

// {

// RevocationMode = X509RevocationMode.NoCheck,

// VerificationFlags = X509VerificationFlags.AllowUnknownCertificateAuthority,

// ExtraStore = { rootCertificate }

// };

// .NET v5

chain.ChainPolicy = new X509ChainPolicy()

{

RevocationMode = X509RevocationMode.NoCheck,

TrustMode = X509ChainTrustMode.CustomRootTrust,

CustomTrustStore = { rootCertificate }

};

var isValidChain = chain.Build(new X509Certificate2(serverCertificate));

if (!isValidChain)

{

foreach (var chainStatus in chain.ChainStatus)

{

Console.Error.WriteLine("Chain failed validation: {0} ({1})", chainStatus.Status, chainStatus.StatusInformation);

}

return false;

}

// Chain is ordered from [0]:leaf -> intermediate -> [^1]:root.

var chainRootCertificate = chain.ChainElements[chain.ChainElements.Count - 1].Certificate;

var isExpectedRoot = chainRootCertificate.RawData.SequenceEqual(rootCertificate.RawData);

// For .NET v3, the AllowUnknownCertificateAuthority flag permits both PartialChain and UntrustedRoot errors for a successful result.

// We must manually check the root certificate to ensure it is the one we expect.

// This is no longer required in .NET v5 with CustomRootTrust support.

if (!isExpectedRoot)

{

Console.Error.WriteLine("Partial chain passed validation, but the expected root certificate was not in the chain.");

return false;

}

return true;

}

By Instaclustr Support

3 Comments

Virendra says:
May 26, 2020 at 3:55 pm
Hello I tried connecting AWS keyspace but getting error
‘All hosts tried for query failed (tried 3.83.170.153:9142: OperationTimedOutException ‘The host 3.83.170.153:9142 did not reply before timeout 5000ms
Reply
1. Ben Slater says:
  May 26, 2020 at 4:01 pm
  Hi Virendra, While AWS Keyspace is largely Cassandra-compatible there are some significant differences and Keyspace is not our area of expertise so we can’t help there sorry. You might have more luck trying one of our Apache Cassandra clusters on a free trial!
  Reply
Raj Patil says:
May 29, 2020 at 5:44 pm
How do we add and send SSL certificate over here
Reply

Support

Connect to Cassandra with C#

Download and install Visual Studio

Install Cassandra C# driver

Connecting without TLS

Write Sample Code

Connecting with TLS via windows

Write Sample Code

3 Comments

Submit Comment

Cancel reply

Connect to Cassandra with C#

Download and install Visual Studio

Install Cassandra C# driver

Connecting without TLS

Write Sample Code​

Connecting with TLS via windows

Write Sample Code

3 Comments

Submit Comment

Cancel reply

Write Sample Code