Important

Helios features are now enabled during weekly update windows and are no longer directly tied to SingleStore engine releases. Refer to the release notes to view the latest features available in your Helios cluster.

Connect with .NET and .NET Core

The SingleStore Connector for .NET and .NET Core (SingleStoreConnector) is an ADO.NET data provider for SingleStore. It implements the following classes: DbConnection, DbCommand, DbDataReader, and DbTransaction. Refer to the GitHub repository and SingleStoreConnector on NuGet for more information.

This library is licensed under the MIT license.

The SingleStoreConnector supports .NET 10.

Prerequisites

Download and install the latest stable version of .NET Core.

Install SingleStoreConnector

To install the SingleStoreConnector in a new project, run the following command:

dotnet add package SingleStoreConnector

You can also install the SingleStoreConnector using the NuGet Package Manager in Visual Studio. Refer to SingleStoreConnector on NuGet for more information.

Configure the Connection

You need a connection string to connect your SingleStore cluster to .NET. The connection string uses the following format:

host=<hostname_or_ip_address>;port=<port>;userid=<username>;password=<password>;database=<database_name>;

Here's a sample connection string:

host=svc-xxxx-ddl.aws-oregon-2.svc.singlestore.com;port=3306;userid=s2user;password=pass23key;database=s2_dbtest;

Refer to Connection String Options for more options.

Example

The following example creates a new project in Visual Studio Code and performs CRUD operations in SingleStore using C#.

Create a SingleStore cluster. For this example, we'll use the following connection string:

"Server=svc-xxxx-ddl.aws-oregon-2.svc.singlestore.com;port=3306;User ID=admin;Password=tK_,mh&Hq-EnN;Database=dbtest"

In Visual Studio Code, open the terminal, and create a project template:

dotnet new console -o dbTestNet
cd dbTestNet

Install the required dependencies, for example SingleStoreConnector:

dotnet add package SingleStoreConnector

Create Operation Example

Add the following code to the Program.cs file of your project:

using SingleStoreConnector;
var connStr = "Server=svc-xxxx-ddl.aws-oregon-2.svc.singlestore.com;port=3306;User ID=admin;Password=tK_,mh&Hq-EnN;Database=dbtest";
var connection = new SingleStoreConnection(connStr);
connection.Open();
using var command = new SingleStoreCommand("CREATE TABLE testID (ID INT PRIMARY KEY, Code VARCHAR(4));INSERT INTO testID values(1, 'SamK');INSERT INTO testID values(2, 'JoeR');INSERT INTO testID values(3, 'BriA');",connection);
using var reader = command.ExecuteReader();
connection.Close();

In the terminal, run the following command:

dotnet run

On the Cloud Portal command line, execute the following command to verify that the testID table is created:

DESC testID;
+-------+------------+------+------+---------+-------+
| Field | Type       | Null | Key  | Default | Extra |
+-------+------------+------+------+---------+-------+
| id    | int(11)    | NO   | UNI  | NULL    |       |
| code  | varchar(4) | YES  |      | NULL    |       |
+-------+------------+------+------+---------+-------+

Read Operation Example

Add the following code to the Program.cs file of your project:

using SingleStoreConnector;
var connStr = "Server=svc-xxxx-ddl.aws-oregon-2.svc.singlestore.com;port=3306;User ID=admin;Password=tK_,mh&Hq-EnN;Database=dbtest";
var connection = new SingleStoreConnection(connStr);
connection.Open();
using var command = new SingleStoreCommand("SELECT * FROM testID",connection);
using var reader = command.ExecuteReader();
while (reader.Read())
{
Console.Write(reader.GetInt32(0));
Console.Write(" ");
Console.WriteLine(reader.GetString(1));
}
connection.Close();

In the terminal, run the following command:

dotnet run
1 SamK
2 JoeR
3 BriA

Update Operation Example

Add the following code to the Program.cs file of your project:

using SingleStoreConnector;
var connStr = "Server=svc-xxxx-ddl.aws-oregon-2.svc.singlestore.com;port=3306;User ID=admin;Password=tK_,mh&Hq-EnN;Database=dbtest";
var connection = new SingleStoreConnection(connStr);
connection.Open();
using var command = new SingleStoreCommand("UPDATE testID SET Code = 'BenW' WHERE ID =3;SELECT * FROM testID",connection);
using var reader = command.ExecuteReader();
while (reader.Read())
{
Console.Write(reader.GetInt32(0));
Console.Write(" ");
Console.WriteLine(reader.GetString(1));
}
connection.Close();

In the terminal, run the following command:

dotnet run
1 SamK
2 JoeR
3 BenW

Delete Operation Example

Add the following code to the Program.cs file of your project:

using SingleStoreConnector;
var connStr = "Server=svc-xxxx-ddl.aws-oregon-2.svc.singlestore.com;port=3306;User ID=admin;Password=tK_,mh&Hq-EnN;Database=dbtest";
var connection = new SingleStoreConnection(connStr);
connection.Open();
using var command = new SingleStoreCommand("DELETE FROM testID WHERE ID = 3;SELECT * FROM testID;",connection);
using var reader = command.ExecuteReader();
while (reader.Read())
{
Console.Write(reader.GetInt32(0));
Console.Write(" ");
Console.WriteLine(reader.GetString(1));
}
connection.Close();

In the terminal, run the following command:

dotnet run
1 SamK
2 JoeR

In this section

Last modified:

Was this article helpful?