0 Replies Latest reply: Dec 10, 2012 12:07 PM by 961763 RSS

    TransactionScope Support without Distributed Transactions?

    961763
      0 down vote favorite
           

      I have an .NET 4.0 Web Forms app that uses EF4.1 against an Oracle 11g DB, so I am using the Oracle Data Provider for .NET (ODP.NET) that supports EF4.1 (not the newest one.)

      I am deploying the app and the ODP.NET libraries to a Win2K8 server using a process very similar to this SO post:
      http://stackoverflow.com/a/4947316/920506

      There are three Oracle libraries (oramtsus.dll, oramts.dll, oramts11.dll) that I want to remove from my deployment (if possible), as I don't want distributed transactions. However, I do want to continue to use TransactionScope in my app code.

      Here are my questions about this:

      1) I did read that oramts.dll might still be necessary to support TransactionScope in my code, but are all three of these Oracle DLLs necessary for that?

      2) If I set Enlist=False in my connection string and follow this advice, is that enough to prevent my data transactions from being promoted to distributed transactions?

      3) If #2 is true, then do I need any of the three Oracle DLLs listed above?

      I checked the Oracle MTS docs for answers, but I could not find details about these specific libraries. Thanks very much for your help!