title: How to set isolation level on SqlCommand/SqlConnection initialized with no transaction
body: <p>The following method is supposed to peroform a dirty read on an open connection. There are no transactions. Where do I set IsolationLevel?</p>
  
  <pre><code>public string DoDirtyRead(string storedProcName, SqlConnection connection)
  {
      using (SqlCommand command = new SqlCommand(storedProcName, connection))
      {
          command.CommandType = CommandType.StoredProcedure;
          // HOW TO SET IsolationLevel to READ_UNCOMMITTED here?
          command.ExecuteNonQuery();
      }
  }
  </code></pre>