title: Inserting/Updating rows cause return from debug mode
body: <p>can you help me with inserting rows into Oracle database in C#..</p>
  
  <p>I have foreach and in it I just make sql query.. Then when I try to insert into database (with support of debbuging), first row insert in couple of miliseconds but the second insert/update is about 5 minutes.. All the magic is at line where is cmd.ExecuteNonQuery();
  With the second row inserted/updated the debbuger return focus to the application and then after cca 5 minutes return back to debbuger.. But it's simple update so there is no so much time needed.. </p>
  
  <pre><code>        using (var connection = new OracleConnection(_connectionTNS)) 
          {
              connection.Open();
              var transaction = connection.BeginTransaction(IsolationLevel.ReadCommitted);
  
              int rowsInserted = 0;
  
  
              foreach (var item in _tableNameAndColumnsList)
              {
                  if (item.Replace)
                  {
                      using (OracleCommand cmd = new OracleCommand())
                      {
                          cmd.Connection = connection;
                          cmd.Transaction = transaction;
                          cmd.CommandText = "UPDATE TABLE TEST WHERE id_test = "+id_test+" ";
                          rowsInserted += cmd.ExecuteNonQuery();
                      }
                  }
              }
  
              transaction.Commit();
              MessageBox.Show("Changed " + rowsInserted + " database rows...");
  </code></pre>
  
  <p>Do you have same problem someone? 
  Thanks Lukas</p>