RE: C# File + DB Transaction

[=?Utf-8?B?Q2lhcmFuIE8nJ0Rvbm5lbGw=?=]

Wrap the actions in a
using(System.Transactions.TransactionScope txScope = new TransactionScope()){
try{
ReadFile()
InsertToDb()
DeleteFile()
txScope.Complete();
}catch(AnyOldException ex){
LogError();
}
}
--
Ciaran O''Donnell
http://wannabedeveloper.spaces.live.com
"Chris Fink" wrote:

I have the following requirements and am looking to make this into a c#
transaction.

1. Read from a file into a memory stream
2. Insert the stream into a DB
3. Delete the file

Is it possible to perform a transaction on both a File action and a DB
insert?

A transaction will ensure that if an error occurs in step 3, the insert will
not commit, etc. All three steps must succeed, otherwise the transaction
should rollback and notify of an error.

Any assistance is appreciated.

Thanks