TransactionScope Troubleshooting[通俗易懂]

LinqSampleDataContext context = new LinqSampleDataContext();<br />System.Data.Common.DbTransaction trans = null;<br />try<br />{<br />   context.Connection.Open();<br />   trans = context.Connection.BeginTransaction();<br />   context.Transaction = trans;</p>
<p>   context.Employees.InsertOnSubmit(emp);<br />                context.SubmitChanges();</p>
<p>   trans.Commit();<br />}<br />catch (Exception ex)<br />{<br />   if (trans != null)<br />   {<br />       trans.Rollback();<br />   }<br />}

using (TransactionScope scope = new TransactionScope(TransactionScopeOption.RequiresNew))<br />        {<br />            try<br />            {</p>
<p>                for (int i = 0; i < nominees.Count; ++i)<br />                {<br />                    Backup newBackup = nominees[i];<br />                    Ticket ticket = tickets[i];</p>
<p>                    //update the information of ticket<br />                    //mainly add the information of employee;<br />                    ticket.EmployeeID = newBackup.EmployeeID;<br />                    ticket.HaveNominated = true;<br />                    ticket.IsConfirmedByManager = true;<br />                    ticket.Status = TicketStatus.Enroll.ToString();</p>
<p>                    ticketAccessor.Update(ticket);<br />                }</p>
<p>                //update the IsSubmit of backup;<br />                ChangeSubmitStatue(backup);</p>
<p>                //remove the record of nominee in backup table<br />                Delete(nominees);<br />            }<br />            catch (Exception ex)<br />            {<br />                ThrowHelper.ThrowBackupException(“Finalizing occurs an error. The transcation will be rollback.”);<br />                return false;<br />            }</p>
<p>            scope.Complete();<br />        }