PayPal api, database inserts/updated and atomicity
Posted on 2013-01-05
I am designing a subscription-based website and am using the PayflowNETAPI API for PayPal, c#(dot.net). Here is my issue, there are several times when I have to perform database inserts and updates after I create or update a recurring billing profile. I know that I can run database inserts and updates within a transaction scope and rollbacks will be performed provided TransactionScope.Complete is never reached. The problem is how do I rollback the PayPal transaction so everything either completes or fails including the PayPal transaction? I am using the service layer and repository patterns. Any help would be greatly appreciated.