How to handle transaction in WCF Service with LINQ

Question

I am using WCF Service which performs database transaction. I am finding a way to rollback when any operation fails.

  public void UpdateFirstTable()
            {
                //Linq query to update table1
            }

        public void UpdateSecondTable()
        {
            //Linq query to update table2
        }

if an exception occus while performing any operation in UpdateFirstTable() & UpdateSecondTable() changes made should be rolled back. How to achieve this?

LINQ2SQL and EF both support TransactionScopes - see here http://stackoverflow.com/questions/542525/transactionscope-vs-transaction-in-linq-to-sql — StuartLC, Jun 06 '11 at 10:15

score 1 · Accepted Answer · answered Jun 06 '11 at 11:02

1

http://msdn.microsoft.com/en-us/library/system.transactions.transactionscope.aspx#Y1900

answered Jun 06 '11 at 11:02

VJAI

32,167
23
102
164

How to handle transaction in WCF Service with LINQ

1 Answers1