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()},t"; Console.Write(rowResult); } Console.WriteLine(); } } }
原文链接: https://www.cnblogs.com/Fred1987/p/13948700.html
欢迎关注
微信关注下方公众号,第一时间获取干货硬货;公众号内回复【pdf】免费获取数百本计算机经典书籍;
也有高质量的技术群,里面有嵌入式、搜广推等BAT大佬
原创文章受到原创版权保护。转载请注明出处:https://www.ccppcoding.com/archives/401901
非原创文章文中已经注明原地址,如有侵权,联系删除
关注公众号【高性能架构探索】,第一时间获取最新文章
转载文章受原作者版权保护。转载请注明原作者出处!