title: ExecuteNonQueryAsync and commit in a SQL Transaction
body: <p>I am after some help with a piece of code I have created, I am attempting to make an Async SQL call from c# within a transaction, for example I might be updating or deleting rows from a table.</p>
  
  <p>This is what I have so far, but I cannot seem to find much information on doing this in a transaction, from what I have here and what I understand so far, I believe it may attempt to commit the transaction before the command has fully completed if the command is time-consuming.  If you could advise / point me to an example I would really appreciate it.</p>
  
  <pre><code>var sqlQuery = "delete from table";
          using (var connection = new SqlConnection(ConnectionString))
          {
              await connection.OpenAsync();
              using (var tran = connection.BeginTransaction())
              {
                  using (var command = new SqlCommand(sqlQuery, connection, tran))
                  {
                      await command.ExecuteNonQueryAsync();
                      tran.Commit();
                  }
              }
          }
  </code></pre>
  
  <p>Thanks,</p>