title: Isolation level in C# or SQL - which one will be used?
body: <p>I have set isolation level in C# code as readcommitted, and I am calling a stored procedure which is timing out due to some reason. The stored procedure does not have any <code>set isolation level</code> statement.</p>
  
  <p>In SQL Server, database level isolation level is read committed snapshot.</p>
  
  <p>So which isolation level will be used? The one defined in SQL Server, or the one set from C#?</p>