title: C# - TSQL Parallel transactions on same connection instance
body: <p>I am developing a C# ORM with php's Laravel-like Syntax.
  When the ORM starts, it connects to the database and performs any query (it also supports two different connections for reading and writing), and reconnect to the db only if connection is losen or missing.</p>
  
  <p><strong>As this is a Web Framework ORM, how can I handle concurrent transactions on the same connection? Are they supported?</strong></p>
  
  <p>I saw I can manually assign the transaction object to the sqlcommand, but can I create parallel sqltransactions?</p>
  
  <p><em>Example:</em></p>
  
  <p>There is an URL of a REST action that will cause a transaction to be opened, some actions performed, and then transaction committed (e.g. perform an order on a shopping cart). What if, multiple users (so different WebOperationContext) call that URL? Is it possible to open and work with multiple "parallel" transactions and then commit them?</p>
  
  <p>How do other ORM's handle this case? Did they use multiple connections?</p>
  
  <p>Thanks for any support!</p>
  
  <p>Mattia</p>