Executing code block in transaction

See more:

C#

file

transaction

, +

I have a scenario where we need to do multiple operations but all of those should be atomic which includes first writing rows in a table and after that using the Id for those rows writing a file for each of those on a network path and followed by writing to another table rows.

What i need here is all of this should be atomic operation, i.e. all steps should complete successfully, if any one of the process fails for some reason i want the changes done in that context to be rolled back.

I am aware of the TransactionScope class we use in ADO.Net and Entity Framework. But i need some mechanism to do these I/O operations and db action in one transaction.

What I have tried:

I have tried using TransactionScope but cannot figure out how to use that for both operations. It normally works for DB operation but not sure how it will behave for Disk I/O operation like creating a file.