title: SqlCommand not executing
body: <p>I don't understand why my code doesn't execute the <code>SqlCommand</code> properly, even when I don't get any errors. </p>
  
  <p>Here is my code: </p>
  
  <pre><code>_connection.Connection.OpenAsync();
  _connection.SqlCommand.Connection = _connection.Connection;
  _connection.SqlCommand.CommandText = "insert into test (id, name) values ('dq1we3','d2qwe3')";
  _connection.SqlCommand.ExecuteNonQueryAsync();
  _connection.Dispose();
  </code></pre>
  
  <p>And here I initialize <code>SqlConnection</code> and <code>SqlCommand</code>: </p>
  
  <pre><code>private readonly string _conString = Settings.Default.RssConnectionString;
  
  public SqlConnection Connection;
  public SqlCommand SqlCommand;
  
  public TestConnection()
  {
      Connection = new SqlConnection(_conString);
      SqlCommand = new SqlCommand();
  }
  
  public void Dispose()
  {
      Connection.Close();
  }
  </code></pre>