public static void Main(string[] args) { if (args.Length < 2) { Console.WriteLine("<database> <tablename>"); return; } var loop = Loop.Default; MySqlClient client = new MySqlClient(loop); client.IPEndPoint = new IPEndPoint(IPAddress.Parse("127.0.0.1"), 3306); client.Username = "******"; client.Password = ""; client.Connect() .OnError((error) => { Console.WriteLine(error.Message); client.Disconnect(); }); client.Query(string.Format("use {0}", args[0])); Query(client, args[0], args[1]); loop.Run(); }
public static void Main(string[] args) { if (args.Length < 2) { Console.WriteLine("<database> <tablename>"); return; } var loop = Loop.Default; MySqlClient client = new MySqlClient(loop); client.IPEndPoint = new IPEndPoint(IPAddress.Parse("127.0.0.1"), 3306); client.Username = "******"; client.Password = ""; client.Connect() .OnError((error) => { Console.WriteLine(error.Message); client.Disconnect(); }); client.Query(string.Format("use {0}", args[0])); Query(client, args[0], args[1]); loop.Run(); }
public static void Query(MySqlClient client, string database, string table) { client.Query(string.Format("SELECT * FROM {0}", table)) .On(fields: (fields) => { foreach (var field in fields) { Console.Write("{0}({1})\t", field.Type, field.Length); } Console.WriteLine(); }) .On(row: (data) => { for (int i = 0; i < data.Length; i++) { Console.Write(data.GetRawValue(i)); Console.Write("\t"); } Console.WriteLine(); }).On(end: () => { client.Disconnect(); }).On(error: (error) => { Console.WriteLine("Error: {0}", error.Message); client.Disconnect(); }); }
public static void Query(MySqlClient client, string database, string table) { client.Query(string.Format("SELECT * FROM {0}", table)) .On(fields: (fields) => { foreach (var field in fields) { Console.Write("{0}({1})\t", field.Type, field.Length); } Console.WriteLine(); }) .On(row: (data) => { for (int i = 0; i < data.Length; i++) { Console.Write(data.GetRawValue(i)); Console.Write("\t"); } Console.WriteLine(); }).On(end: () => { client.Disconnect(); }).On(error: (error) => { Console.WriteLine("Error: {0}", error.Message); client.Disconnect(); }); }