using MySql.Data.MySqlClient; using Dapper; static void MySqlDapperDemo() { string connString = "Server=localhost;Port=3306;Database=firstSchema;Uid=UserName;Pwd=UserPwd;"; using (MySqlConnection conn = new MySqlConnection(connString)) { conn.Open(); string querySQL = "select * from firstSchema.MyTB order by age;"; var queryResult = conn.Query<dynamic>(querySQL).ToList(); int queryCount = queryResult.Count(); foreach(var query in queryResult) { var tempResult=query as IDictionary<string,object>; var keys = tempResult.Keys.ToList(); var values = tempResult.Values.ToList(); for(int i=0;i<keys.Count;i++) { string rowResult = $"{keys[i]}:{values[i].ToString()}, "; Console.Write(rowResult); } Console.WriteLine(); } } }