tags:

views:

15

answers:

0
Q: 

Distributed transactions with WCF service and multiple databases

Basic architecture: Application consumes 2 databases one SQL Server 2005 and another third party SQL Server 2008. The 2008 database is accessible only via a WCF service behind a network load balancer.

So, in the data access layer of my app I need some method of distributed transactions to access both databases. What are my options? The WCF service has BasicHttpBinding Will Transaction Scope work for calling the 2005 database and WCF service?

related questions

Fire event when client connects to WCF-hosted endpoint
WCF: Net.TCP multiple bindings, same port, different IP Addresses
WCF and gSOAP - interoperable code?
WCF Contract Name 'IMyService' could not be found?
Guaranteeing that a .NET WCF Service can be consumed by a Java client
WCF Service reference intermittently breaking.
What's the best way to test WCF services?
Problem with WCF-Service between Silverlight and Azure Cloud WebRole.
WCF Server without config file
Can I create a WCF service without using attributes?
Stop/start WCF MEX service at runtime
Using JScript.NET to create WCF services?
How do I set up a secure WCF service behind a firewall?
In WCF, can data contract classes inherit from one another?
WCF Self-hosted service, client clean-up on service stop
Test a web service(RESTful WCF) methods with certificate based authentication
Access App_Data in WCF service
Host files or stream data on a self-hosted WCF (non-IIS) service that uses HTTP?
REST Service exposed on WCF not populating parameter values
netTcpBinding - Pending Security Sessions
How do you configure a WCF service for clients running on networked machines?
Moving ASP.net webservices to WCF
Can't re-add Service Reference Properly
Silverlight WCF Service Error
Silverlight Async Timeout Error