👁 Image
SingleStoreConnector 1.4.0

About

SingleStoreConnector is a C# ADO.NET driver for SingleStore.

How to Use

// set these values correctly for your database server
var builder = new SingleStoreConnectionStringBuilder
{
	Server = "your-server",
	UserID = "database-user",
	Password = "P@ssw0rd!",
	Database = "database-name",
};

// open a connection asynchronously
await using var connection = new SingleStoreConnection(builder.ConnectionString);
await connection.OpenAsync();

// create a DB command and set the SQL statement with parameters
await using var command = connection.CreateCommand();
command.CommandText = @"SELECT * FROM orders WHERE order_id = @OrderId;";
command.Parameters.AddWithValue("@OrderId", orderId);

// execute the command and read the results
await using var reader = await command.ExecuteReaderAsync();
while (reader.Read())
{
	var id = reader.GetInt32("order_id");
	var date = reader.GetDateTime("order_date");
	// ...
}

ASP.NET

For ASP.NET, use the SingleStoreConnector.DependencyInjection package to integrate with dependency injection and logging.

var builder = WebApplication.CreateBuilder(args);

// use AddSingleStoreDataSource to configure SingleStoreConnector
builder.Services.AddSingleStoreDataSource(builder.Configuration.GetConnectionString("Default"));

var app = builder.Build();

// use dependency injection to get a SingleStoreConnection in minimal APIs or in controllers
app.MapGet("/", async (SingleStoreConnection connection) =>
{
 // open and use the connection here
 await connection.OpenAsync();
 await using var command = connection.CreateCommand();
 command.CommandText = "SELECT name FROM users LIMIT 1";
 return "Hello World: " + await command.ExecuteScalarAsync();
});

app.Run();

Key Features

• Full support for async I/O
• High performance
• Supports .NET Framework, .NET Core, and .NET 5.0+

Main Types

The main types provided by this library are:

• SingleStoreConnection (implementation of DbConnection)
• SingleStoreCommand (implementation of DbCommand)
• SingleStoreDataReader (implementation of DbDataReader)
• SingleStoreBulkCopy
• SingleStoreBulkLoader
• SingleStoreConnectionStringBuilder
• SingleStoreConnectorFactory
• SingleStoreDataAdapter
• SingleStoreException
• SingleStoreTransaction (implementation of DbTransaction)

Feedback

SingleStoreConnector is released as open source under the MIT license. Bug reports and contributions are welcome at the GitHub repository.