dapper mysql 拓展_【C#】Dapper使用Mysql实例，Dapper使用Mysql简单范例，DapperHelper

using MySql.Data.MySqlClient; //自行网上下载引用MySql.Data.dll

using System.Configuration;

using System.Data;

using Dapper;                //自行网上下载引用Dapper.dll

using System.Collections.Generic;

namespace DapperTest

{

public class DapperHelper

{

//Web.config配置链接：

///

/// 连接MySQL数据库

///

///

public static MySqlConnection MySqlCon()

{

string mysqlConnectionStr = ConfigurationManager.ConnectionStrings["testDB"].ToString();

var connection = new MySqlConnection(mysqlConnectionStr);

connection.Open();

return connection;

}

///

/// 执行insert与update脚本

///

public int ExcuteSqlString(string sqlStr)

{

using (IDbConnection conn = DapperHelper.MySqlCon())

{

return conn.Execute(sqlStr);

}

}

///

/// 执行查询脚本

///

public List QuerySqlString(string sqlStr)

{

using (IDbConnection conn = DapperHelper.MySqlCon())

{

return conn.Query(sqlStr) as List;

}

}

//调用测试

public void Test()

{

DapperHelper dh = new DapperHelper();

//查询测试

List list = dh.QuerySqlString("select * from TestTable limit 10;");

//执行测试

int result = dh.ExcuteSqlString("update TestTable set name='test' where id=1");

return;

}

}

}