Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Enforcing transaction when invoking multiple CRM requests RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

     

    Hi,

     

    Is it possible for us to enforce transaction, such as placing begin-Transaction and end-Transaction code block, when executing a series of CRM requests (such as insert and update) so that we won't have data integrity issue ?

     

    Can we apply this in our web applications as well as in the plugin / workflow ?

     

    As far as i know, we cannot participate in the transaction for the plugin for CRM 4.0, but i cannot find a clue in how to participate in the transaction for web application for invoking a series of web services.

     

    Thanks very much for all your help.

     

    Regards,

     

    hadi teo.

    Tuesday, December 2, 2008 2:46 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    There's no way to apply transactions across multiple CRM requests, whether from a plugin, web application or any other type of application. The fundamental reason is that no locks can be held across web service calls, hence you could not ensure that the data is not modified by someone else between the requests

    Tuesday, December 2, 2008 10:17 AM
    Moderator

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    There's no way to apply transactions across multiple CRM requests, whether from a plugin, web application or any other type of application. The fundamental reason is that no locks can be held across web service calls, hence you could not ensure that the data is not modified by someone else between the requests

    Tuesday, December 2, 2008 10:17 AM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote
    Hi David,

    Thanks for the reply. I was expecting the same answer as i also cannot find the correct codes to apply transactions without a series of web service calls.

    There is another alternative by invoking stored procedures so that we can insert them under a transaction, but using stored procedures to perform insertion and update to the MS CRM database is considered unsupported means.

    Regards

    hadi teo.
    Tuesday, December 2, 2008 2:10 PM