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

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

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

keyboard - Smiles and long press feature in Android -