You won’t immediately gain anything by switching your existing code to use TransactionScope
. You should use it for future development because of the flexibility it provides. It will make it easier in the future to include things other than ADO.NET calls into a transaction.
BTW, in your posted example, the SqlCommand
instances should be in using
blocks.