DapperTricks

BulkInsert (transaction)

var insert = @"
INSERT INTO table (value1, value2)
VALUES (@value1, @value1);
";
using (var scope = new System.Transactions.TransactionScope())
{
    _dbConnection.Open();
    _dbConnection.Execute(insert, listOfStuff);
    scope.Complete();
}