How to write a transaction to cover Moving a file and Inserting record in database?
<p>I want to have a transaction for copying a file and then inserting a record in database.
something like below statement, but transaction doesn't cover copying file.
What's the solution?</p>

<pre><code>using (TransactionScope scope1 = new TransactionScope())
{
    // Copy a file
    fileMgr.Move(srcFileName, destFileName);

    // Insert a database record
    dbMgr.ExecuteNonQuery(insertSql);

    scope1.Complete();
}
</code></pre>
