I have a WCF service that needs to participate in a distributed transaction involving 3 separate systems, also using WCF Services across both MS  Sql Server and Oracle .  Other than marking up my service interface with "RequiresTransaction" etc., is there any other considerations from an ES point of view that I need to be concerned with?  Anyone done this yet?

Ah, just saw the reference to setting the connection using "DataProviderEnterprise".

Right, that will ensure than down in the provider we always use the Microsoft TransactionScope() class. However, since the regular "DataProvider" model uses ADO.NET connections they should enlist in any ongoing distributed transactions, so you could probably use it. However, for the record "DataProviderEnterprise" uses the Microsoft TransactionScope class.

---

EntitySpaces | Twitter | BLOG | Please honor our Software License