安装

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"

代码

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 == )  
        {  
            return JsonConvert.DeserializeObject<T\[\]>(JsonConvert.SerializeObject(dataset.Tables\[\]));  
        }  
        return new T\[\];  
    }

测试代码

class MyClass
{
public int Id { get; set; }
public string Name { get; set; }
}

var aa = QueryTable(cmdText, null);