title: How to implement single SQL transaction for multiple ObjectContexts in EF4
body: <p>I have a fairly big database with tables created for different business modules.</p>
  
  <p>We decided to create different edmx-files for different modules respectively.</p>
  
  <p>However, how can I prevent the usage of MSDTC when trying to implement a TransactionScope for a logical action that will incur writing to multiple tables in different edmx? Again, the underlying database is the same, I wouldn't want to use MSDTC for this scenario.</p>
  
  <p>Is there any way to pass in an opened SQL connection with active transaction?</p>
  
  <p>Thanks for help in advance.</p>
  
  <p>Regards,
  William</p>