StrataFrame Forum

Cross database transaction

http://forum.strataframe.net/Topic21165.aspx

By Chan - 12/12/2008

Hi,

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



Thank you
By Trent L. Taylor - 12/16/2008

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.
By Chan - 12/16/2008

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
By ChanKK - 5/4/2009

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