connectors/SingleStoreConnectorv1.2.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 using var connection = new SingleStoreConnection(builder.ConnectionString); await connection.OpenAsync(); // create a DB command and set the SQL statement with parameters 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 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 )