title: How to write a transaction to cover Moving a file and Inserting record in database?
body: <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>