public JsonResult Delete(string id) { MyJsonResult mjr = new MyJsonResult(); using (DbAccessor dba = DbAccessor.Create()) { try { dba.BeginTran(); _menuService.DeleteRecursive(id, dba); dba.CommitTran(); mjr.Success = true; } catch (Exception ex) { dba.RollbackTran(); mjr.Success = false; mjr.Message = ex.Message; } } return(Json(mjr)); }
public void BeginTran() { using (DbAccessor dba = DbAccessor.Create()) { dba.BeginTran(); dba.ExecuteNonQuery("update sys_product set ProductName='abc' where ProductId=#ProductId#", new { ProductId = 1 }); dba.RollbackTran(); } }