|
| | | Advanced StrataFrame User
 
Group: Forum Members
Last Login: 03/14/2009 10:31:01 PM
Posts: 533, Visits: 2,020 |
| Hi,
I have data in multiple databases. Does SF support transaction for multiple data source? How?
Thank you |
| |
| | | 
StrataFrame Developer
Group: StrataFrame Developers
Last Login: Yesterday @ 3:35:11 PM
Posts: 5,565, Visits: 5,547 |
| | 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. |
| |
| | | Advanced StrataFrame User
Group: Forum Members
Last Login: 03/14/2009 10:31:01 PM
Posts: 533, Visits: 2,020 |
| 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 |
| |
| | | StrataFrame Novice
Group: StrataFrame Users
Last Login: 06/28/2009 11:09:26 PM
Posts: 92, Visits: 510 |
| 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 |
| |
|
|