dapper mysql 事务_关于dapper的事务处理

usingDapper;usingModel.DB;usingMySql.Data.MySqlClient;usingSystem;usingSystem.Collections.Generic;usingSystem.Data;usingSystem.Data.Common;namespaceTools.DB

{public classDapperHelper

{private staticDapperHelper dapperHelper;private static readonly object lockObj = new object();public static string connStr = string.Empty;privateDapperHelper()

{//数据库连接字符串

connStr =Conn.CreateInstance().ConnStr;

}public staticDapperHelper CreateDapperHelper()

{if (dapperHelper == null)

{lock(lockObj)

{if (dapperHelper == null)

{

dapperHelper= newDapperHelper();

}

}

}returndapperHelper;

}///

///增删改///

/// 数据类型 content可以是一个对象也可以是一个集合

///

///

///

public int ExecuteNonQuery(stringsql, T obj)

{int result = 0;try{using (var conn = newMySql