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 }
原标题:Dapper学习笔记(4)
关键词: