public async Task <IActionResult> Transaction() { Repo1.BeginTransaction(); var result = await Repo1.QueryFirstOrDefaultAsync("select * from COMPANY where id=1;"); if (result != null) { await Repo1.ExecuteAsync("update COMPANY set name=@name where id=1;", new { name = Guid.NewGuid().ToString() }); Repo1.CommitTransaction(); } return(Ok()); }