Atomic transaction for both file system and DB operations

Question

I have a problem of implementing an atomic transaction that involves:

File system operations like add, edit, move, copy and delete files.
Linq operations (Entity Framework) like add object and save changes.

These two types of operations should be committed\Rolled back together.

I looked around for a solution and found out that (Transactional NTFS & The .NET TransactionScope class) is my best choice, now my question is does TransactionScope class supports EF linq operations? if you can provide me with simple examples I'm a bit lost here.

Possible duplicate of [How to write a transaction to cover Moving a file and Inserting record in database?](https://stackoverflow.com/questions/7939339/how-to-write-a-transaction-to-cover-moving-a-file-and-inserting-record-in-databa) — Ozkan, Mar 19 '19 at 11:20

score 1 · Accepted Answer · answered Mar 03 '13 at 08:33

1

Yes Linq to Sql supports .Net Transactions.SaveChanges applies Transaction with Isolation level ReadCommitted. If you do have to apply More than one SaveChanges within one Transaction then you explicitly apply Transactions. EF SaveChanges first checks whether there is already transaction it continues with it if not then It applies its own Transaction.If there is only one SaveChanges per transaction then there is no need to apply Transaction .

answered Mar 03 '13 at 08:33

yo chauhan

12,079
4
39
58

So when I start my scope with using transactionScope, EF saveChanges will continue with it and wont apply its own transaction, right? – Lisa Mar 03 '13 at 08:47
and that also goes for AddObject? – Lisa Mar 03 '13 at 08:47
1

Yes when you will apply your own transaction EF will goes with it. – yo chauhan Mar 03 '13 at 08:50

Atomic transaction for both file system and DB operations

1 Answers1