从MySQL获取数据
安装
PM> install-package newtonsoft.json
PM> install-package mysql.data
string connectionString = "Server=192.168.97.111;Database=testdb;Uid=root;Pwd=Passw0d;Port=3306"
代码
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif)
string connectionString = "Server=127.0.0.1;Database=testdb;Uid=root;Pwd=123456;Port=3306"; string cmdText = "SELECT Id,Name FROM abcTable"; public static T[] QueryTable<T>(string commandText, params MySqlParameter[] commandParameters) { var dataset = MySql.Data.MySqlClient.MySqlHelper.ExecuteDataset(connectionString, commandText, commandParameters); if (dataset.Tables.Count == 1) { return JsonConvert.DeserializeObject<T[]>(JsonConvert.SerializeObject(dataset.Tables[0])); } return new T[0]; }
测试代码
![](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif)
class MyClass { public int Id { get; set; } public string Name { get; set; } } var aa = QueryTable<MyClass>(cmdText, null);