CODEWITHSUNDEEP
asp.netwcf
Ulhas Tuscano
Ulhas Tuscano

Reputation: 5620

How to handle transaction in WCF Service with LINQ

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?

Upvotes: 0

Views: 165

Answers (1)

VJAI
VJAI

Reputation: 32758

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

Upvotes: 1

Related Questions