connectors/SingleStoreConnectorv1.1.2
.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 an ADO.NET data provider 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");
// ...
}
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 . Bug reports and contributions are welcome at .