locked
Transaction Support for Multiple Web Service Calls RRS feed

  • Question

  • Hi I need to update CRM data that is stored across multiple entities (system and custom)  via a sequence of web service calls (insert, update and create relationships). If any web service call fails (for any reason), I would like all rolled back. I can't find any support for transactions in Dynamics CRM 4. What are my options for ensuring data integrity? Is there perhaps another options instead of using Web service calls from an external  application eg is it possible to achieve within a plugin? Thanks
    Thursday, January 22, 2009 9:16 AM

Answers

  • There is no supported way to get transactional support in CRM 4 (the only excpetion is the CompoundCreate message, which only works on a few entities).

     

    Your options are to either write your own compensation code using web services to undo the changes (though you can never be absolutely certain this will work, as you cannot lock the updated entities to ensure consistency, or to go the unsupported (and dangerous) route of making direct SQL modifications

     

    Thursday, January 22, 2009 10:10 AM
    Moderator