I've just started using Dapper and I was wondering which pattern for transactions would be better.
When I write SQL I prefer to use the transaction already in the script with:
BEGIN TRAN
-- insert, update etc.
COMMIT
because it's easier to test it but there is also the question transaction with dapper dot net where .net transactions are used so now I'm not sure which one I should actually use.
Does either method have any dis/advantages over the other?