Dapper.NET Transactions Using a Transaction
Example
This example uses SqlConnection, but any IDbConnection is supported.
Also any IDbTransaction is supported from the related IDbConnection.
public void UpdateWidgetQuantity(int widgetId, int quantity)
{
using(var conn = new SqlConnection("{connection string}")) {
conn.Open();
// create the transaction
// You could use `var` instead of `SqlTransaction`
using(SqlTransaction tran = conn.BeginTransaction()) {
try
{
var sql = "update Widget set Quantity = @quantity where WidgetId = @id";
var parameters = new { id = widgetId, quantity };
// pass the transaction along to the Query, Execute, or the related Async methods.
conn.Execute(sql, parameters, tran);
// if it was successful, commit the transaction
tran.Commit();
}
catch(Exception ex)
{
// roll the transaction back
tran.Rollback();
// handle the error however you need to.
throw;
}
}
}
}
