title: Transaction manager
body: <p>If I use .Net System.Transactions.TransactionScope class for a transaction across multiple tables in Oracle database, which one will be used LTM[Lightweight transaction manager] or MSDTC[Microsoft distributed transaction coordinator]?</p>
  
  <p>Is there any rule or strategy beind the scenes for deciding which one to use and when?
  Please advise.
  Also, wanted to know when is 2-phase commit used?Is it used only incase of distributed transactions across multiple databases?</p>
  
  <p>Thanks.</p>