c# - Creating atomic database and file system operation -


i working on asp.net mvc 3 application using c# 4.0 , sql server 2008 r2. have scenario where:

  1. several database rows inserted sql server database.
  2. an xml file built content of 1 of these rows written file system.

currently database operations wrapped in transactionscope , file system write last operation before call transactionscope.complete().

i trying combine file system write database inserts single atomic operation.

after reading similar post have tried using transactional ntfs (txf) , seems work ok. within team work there reluctance use due lack of evidence , experience txf.

what other decent approaches/patterns can used make combined db , file system change atomic?

you using sql server 2008. can use filestream storage. wrapped in transaction along database changes.


Comments

Popular posts from this blog

Why does Ruby on Rails generate add a blank line to the end of a file? -

keyboard - Smiles and long press feature in Android -

node.js - Bad Request - node js ajax post -