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:
- several database rows inserted sql server database.
- 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
Post a Comment