none
Transaction Aborted When Executing Multiple DDL Operations within single service method in WCF RRS feed

  • Question

  • Hi,

    I developed the WPF based smart client with connected to WCF Services. 

    While performing DDL operations - 1 insert, 2 updates and 2 delete's and calling 2 external service with in the same service method/call in my WCF service. In this service method at top of that single transaction scope implemented, the reason behind is if suppose any one operation is failed then rollback all other operations too.

    Under single transaction scope ,i'have called all DDL operations. Some times my external service it took more time to respond, at this case i'm getting transaction aborted issue. 

    Is there any way to do multiple operation with in a single transaction scope? Please suggest.

    or

    Is there any possibilities to use multiple transaction within the main transaction scope? Please suggest and provide examples.

    All responses are greatly appreciated!

    Regards,

    Palanisamy

    Avanade, Accenture

     

    Tuesday, December 2, 2014 9:51 AM

Answers