you do the transaction yourself outside of the DAL
create a new connection object, attach it to a transaction, open the connection, pass that connection into the DAL for all the things you want to do in your transaction. along the way if you get an error, rollback that transaction, if you get through all of them without error, then commit the transaction.
HTH |