title: SqlCommand scopes
body: <p>I want to insert data into two tables</p>
  <p>query:</p>
  <pre><code>insert into test.products values (123,123,123,123)
  insert into test.prices values (456,567,456,SCOPE_IDENTITY())
  </code></pre>
  <p>I am using this methods:</p>
  <pre><code>using (SqlConnection conn = new SqlConnection(ConnectionString))
  {
      conn.Open();
      var cmd = new SqlCommand(query, conn);
      cmd.ExecuteNonQuery();
  }
  </code></pre>
  <p>I wonder if I use this piece of code multiple times at once does the SCOPE_IDENTITY() return identity from single one command or last identity from another running sqlcommands.
  I wonder if each started sqlCommand is new SCOPE?</p>