Hi,

I have data in multiple databases. Does SF support transaction for multiple data source? How?



Thank you

You can try and setup this up, but I think that you are going to have to use a distributed transaction in order to cross multiple databases under a single transaction.

Hi,

I found that, we can use TransactionScope class to have distributed transaction without using DTC. However, I haven't go thru how to implement this in SF.



Please advice if you have any ideas.



Thank you

Hi,

I just spent some time to have a look how could I integrate transactionScope to SF. Too bad is that it is not so straight forward for multi-thread environment. As SF uses threading for DataLayer, therefore TransactionScope (which only support single thread) can not be used. Even though DependentTransaction does support multi thread, but it required code change at SF dataLayer.



Hope SF can implement this, or advice how could we accomplish this.



http://www.pluralsight.com/community/blogs/jimjohn/archive/2005/05/01/7923.aspx



Thank you