public static Task OpenAsync(this MySqlConnection conn) { var tcs = new TaskCompletionSource <int>(); conn.InternalOpen(() => tcs.SetResult(0)); return(tcs.Task); }
public static void Test1_Select() { ConnectionConfig config = new ConnectionConfig("root", "root"); config.database = "test"; MySqlConnection sqlConn = new MySqlConnection(config.host, config.user, config.password, config.database); sqlConn.UseConnectionPool = true; sqlConn.InternalOpen(); string sql = "select * from ??t1 where ??c1 > ?n1 and ??c1 < ?n2"; int testN1 = 4510; int testN2 = 4520; MySqlCommand command = new MySqlCommand(sql, sqlConn); command.Parameters.SetSqlPart("??t1", "saveimage"); command.Parameters.SetSqlPart("??c1", "idsaveImage"); command.Parameters.AddWithValue("?n1", testN1); command.Parameters.AddWithValue("?n2", testN2); var reader = command.ExecuteReader(); int count = 0; while (reader.Read()) { Console.WriteLine("Id : " + reader.GetInt32(0)); Console.WriteLine("Buffer size : " + reader.GetBuffer(1).Length); ++count; if (count >= 3) { break; } } reader.Close(); }
public static void Test1_Delete() { ConnectionConfig config = new ConnectionConfig("root", "root"); config.database = "test"; MySqlConnection sqlConn = new MySqlConnection(config.host, config.user, config.password, config.database); sqlConn.UseConnectionPool = true; sqlConn.InternalOpen(); string sql = "select * from ??t1 where ??c1 > ?n1 and ??c1 < ?n2"; int testN1 = 4510; int testN2 = 4520; MySqlCommand command = new MySqlCommand(sql, sqlConn); command.Parameters.SetSqlPart("??t1", "saveimage"); command.Parameters.SetSqlPart("??c1", "idsaveImage"); command.Parameters.AddWithValue("?n1", testN1); command.Parameters.AddWithValue("?n2", testN2); }
public static void Test1_Insert() { //string filename = "TestMe.png";//216,362 bytes byte[] buffer = new byte[] { 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 }; ConnectionConfig config = new ConnectionConfig("localhost", "root", "root"); config.database = "test"; MySqlConnection sqlConn = new MySqlConnection(config.host, config.user, config.password, config.database); sqlConn.UseConnectionPool = true; sqlConn.InternalOpen(); string sql = "INSERT INTO ??t1 SET ??c2 = ?buffer1"; MySqlCommand command = new MySqlCommand(sql, sqlConn); command.Parameters.SetSqlPart("??t1", "saveimage"); command.Parameters.SetSqlPart("??c2", "saveImagecol"); command.Parameters.AddWithValue("?buffer1", buffer); command.ExecuteNonQuery(); sqlConn.InternalClose(); }
public static void Test1_Insert() { string filename = "TestMe.png";//216,362 bytes //filename = "Colorful.jpg";//885,264 bytes //filename = "TestJpg.jpg";//2,066 bytes byte[] buffer = File.ReadAllBytes("D:\\[]Photo\\" + filename); ConnectionConfig config = new ConnectionConfig("root", "root"); config.database = "test"; MySqlConnection sqlConn = new MySqlConnection(config.host, config.user, config.password, config.database); sqlConn.UseConnectionPool = true; sqlConn.InternalOpen(); string sql = "INSERT INTO ??t1 SET ??c2 = ?buffer1"; MySqlCommand command = new MySqlCommand(sql, sqlConn); command.Parameters.SetSqlPart("??t1", "saveimage"); command.Parameters.SetSqlPart("??c2", "saveImagecol"); command.Parameters.AddWithValue("?buffer1", buffer); command.ExecuteNonQuery(); }
public static void Test1_Delete() { ConnectionConfig config = new ConnectionConfig("root", "root"); config.database = "test"; MySqlConnection sqlConn = new MySqlConnection(config.host, config.user, config.password, config.database); sqlConn.UseConnectionPool = true; sqlConn.InternalOpen(); string sql = "select * from ??t1 where ??c1 > ?n1 and ??c1 < ?n2"; int testN1 = 4510; int testN2 = 4520; MySqlCommand command = new MySqlCommand(sql, sqlConn); command.Parameters.SetSqlPart("??t1", "saveimage"); command.Parameters.SetSqlPart("??c1", "idsaveImage"); command.Parameters.AddWithValue("?n1", testN1); command.Parameters.AddWithValue("?n2", testN2); }
public static void Test1_Insert() { string filename = "TestMe.png";//216,362 bytes //filename = "Colorful.jpg";//885,264 bytes //filename = "TestJpg.jpg";//2,066 bytes byte[] buffer = File.ReadAllBytes("D:\\[]Photo\\" + filename); ConnectionConfig config = new ConnectionConfig("root", "root"); config.database = "test"; MySqlConnection sqlConn = new MySqlConnection(config.host, config.user, config.password, config.database); sqlConn.UseConnectionPool = true; sqlConn.InternalOpen(); string sql = "INSERT INTO ??t1 SET ??c2 = ?buffer1"; MySqlCommand command = new MySqlCommand(sql, sqlConn); command.Parameters.SetSqlPart("??t1", "saveimage"); command.Parameters.SetSqlPart("??c2", "saveImagecol"); command.Parameters.AddWithValue("?buffer1", buffer); command.ExecuteNonQuery(); }
public static void Test1_Select() { ConnectionConfig config = new ConnectionConfig("root", "root"); config.database = "test"; MySqlConnection sqlConn = new MySqlConnection(config.host, config.user, config.password, config.database); sqlConn.UseConnectionPool = true; sqlConn.InternalOpen(); string sql = "select * from ??t1 where ??c1 > ?n1 and ??c1 < ?n2"; int testN1 = 4510; int testN2 = 4520; MySqlCommand command = new MySqlCommand(sql, sqlConn); command.Parameters.SetSqlPart("??t1", "saveimage"); command.Parameters.SetSqlPart("??c1", "idsaveImage"); command.Parameters.AddWithValue("?n1", testN1); command.Parameters.AddWithValue("?n2", testN2); var reader = command.ExecuteReader(); int count = 0; while (reader.Read()) { Console.WriteLine("Id : " + reader.GetInt32(0)); Console.WriteLine("Buffer size : " + reader.GetBuffer(1).Length); ++count; if (count >= 3) { break; } } reader.Close(); }