connectors/SingleStoreConnectorv1.3.0
.NET FW4.6.2.NET FW4.7.1.NET FW4.8.NET 6.0
A truly async SingleStore ADO.NET provider.
Get Started
$ dotnet add package SingleStoreConnectorReadme
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 ofDbConnection)SingleStoreCommand(implementation ofDbCommand)SingleStoreDataReader(implementation ofDbDataReader)SingleStoreBulkCopySingleStoreBulkLoaderSingleStoreConnectionStringBuilderSingleStoreConnectorFactorySingleStoreDataAdapterSingleStoreExceptionSingleStoreTransaction(implementation ofDbTransaction)
Feedback
SingleStoreConnector is released as open source under the MIT license. Bug reports and contributions are welcome at the GitHub repository.