Dapper中对事务的处理也非常简单，如下代码所示：
1 private void DapperTransaction()
2 {
3 using (IDbConnection con = OpenConnection())
4 {
5 IDbTransaction tran = con.BeginTransaction();
6 try
7 {
8 string query = "update T_Role set RoleName='开发主管' where RoleId=4";//更新一条记录
9 con.Execute(query, null, tran, null, null);
10 //throw new Exception();
11 query = "delete from T_Role where RoleId=8";//删除一条记录
12 con.Execute(query, null, tran, null, null);
13 tran.Commit();
14 }
15 catch (Exception ex)
16 {
17 tran.Rollback();
18 }
19 }
20 }