none
Difference between WCF Transactions Vs MSSQL Transaction RRS feed

  • Question

  • Hi,

    I want to know that

    is there any difference between WCF Transaction vs MSSQL Transaction?

    Thanks

    Christopher f



    Christopher

    Tuesday, September 24, 2013 9:30 AM

Answers

  • Hi,

    WCF depends on the built-in .NET System.Transactions capability for transaction management. This MSDN article provides a good overview of the WCF transaction capabilities.

    The System.Transactions namespace supports transactions initiated by many platforms including SQL Server and others.....

    Windows Communication Foundation utilizes the many available objects of this namespace to provide all the necessary transaction capabilities you will need when building your WCF services and client applications.

    If the WCF service fails before committing a distributed transaction then all the changes that are part of that transaction will be rolled back by the distrubuted transaction coordinator. This could be not just the database but other service calls that are enrolled in the same transaction.

    For more information, please try to refer to the following articles:

    #WCF Transactions:
    http://www.codeproject.com/Articles/183708/WCF-Transactions-Brief-Introduction .

    #SQL Server Transactions:
    http://www.codeproject.com/Articles/4451/SQL-Server-Transactions-and-Error-Handling .

    Best Regards,
    Amy Peng


    <THE CONTENT IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND, WHETHER EXPRESS OR IMPLIED>
    Thanks
    MSDN Community Support

    Please remember to "Mark as Answer" the responses that resolved your issue. It is a common way to recognize those who have helped you, and makes it easier for other visitors to find the resolution later.


    Wednesday, September 25, 2013 2:37 AM
    Moderator