title: SQL: SELECT data from an INSERT done within a SQL Transaction that is not yet committed
body: <p>I have a old application written in C# which </p>
  
  <ol>
  <li>Initiates a SQL transaction  </li>
  <li>Does an <code>INSERT</code> using petapoco. Key for the inserted recorded in generated via custom logic (no identity insert)  </li>
  <li>Then does a <code>SELECT</code> of the inserted record using the generated keys using petapoco - <code>first&lt;dynamic&gt;</code> (SQL)  </li>
  <li>Pushes the record via an API  </li>
  <li>Commits the transaction.  </li>
  </ol>
  
  <p>Issue is the <code>SELECT</code> statement in Step 3 that reads the inserted record; it is working fine in one SQL Server, but not the other.</p>
  
  <p>I ran SQL Server Profiler trace and was not able to find any discrepancy. Isolation level is <code>READ COMMITTED</code> without snapshot.</p>
  
  <p>Can you suggest possible areas where I can investigate further?</p>