How to handle transaction in WCF Service with LINQ
I am using WCF Service which performs database transaction. I am findin开发者_Go百科g 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?
http://msdn.microsoft.com/en-us/library/system.transactions.transactionscope.aspx#Y1900
精彩评论