private void UserHandlTest(IApplicationBuilder app) { app.Run(async ctx => { using (var connection = new MySqlConnector.MySqlConnection("server=192.168.3.125;database=go_testdb;uid=root;pwd=123456;charset='utf8';SslMode=None")) { await connection.OpenAsync(); using var command = connection.CreateCommand(); command.CommandText = "select id,name,age,birthday from users where id = 1"; command.Connection = connection; command.CommandTimeout = 1; var reader = await command.ExecuteReaderAsync(); //_ = await connection.QueryFirstAsync<User>("select id,name,age,birthday from users"); } }); }
public void GlobalSetup() { using (var connection = new MySqlConnector.MySqlConnection(s_connectionString)) { connection.Open(); using (var cmd = connection.CreateCommand()) { cmd.CommandText = @" create schema if not exists benchmark; drop table if exists benchmark.integers; create table benchmark.integers (value int not null primary key); insert into benchmark.integers(value) values (0),(1),(2),(3),(4),(5),(6),(7),(8),(9); drop table if exists benchmark.blobs; create table benchmark.blobs( rowid integer not null primary key auto_increment, `Blob` longblob null ); insert into benchmark.blobs(`Blob`) values(null), (@Blob1), (@Blob2);"; // larger blobs make the tests run much slower AddBlobParameter(cmd, "@Blob1", 75000); AddBlobParameter(cmd, "@Blob2", 150000); cmd.ExecuteNonQuery(); } } s_connectionString += ";database=benchmark"; var mySqlData = new MySql.Data.MySqlClient.MySqlConnection(s_connectionString); mySqlData.Open(); m_connections.Add("MySql.Data", mySqlData); var mySqlConnector = new MySqlConnector.MySqlConnection(s_connectionString); mySqlConnector.Open(); m_connections.Add("MySqlConnector", mySqlConnector); Connection = m_connections[Library]; }