Is it possible to use TransactionScope for a combination of Db and file creation work?
Private Sub MySub()
Using scope As TransactionScope = New TansactionScope(TransactionScopeOption.Required)
' 1)do some db work, Insert, update, delete
' 2) create a file
' 3) do some more db work
Db is 2005.
At the present moment TransactionScope works great for the Db side of things, but if, in above example, step 3) fails I'd like file creation to rollback not just the db stuff?