[Firebird-net-provider] Dispose in OnRowUpdated

[Evgeny F. <uf...@pb...>]

Hello, firebird-net-provider.

When I use FbDataAdapter + FbCommandBuilder I must do this?:
<code>
     ...
     using(FbCommand command = new FbCommand(sql, connection, transaction))
     using(FbDataAdapter adapter = new FbDataAdapter(command))
     using(FbCommandBuilder builder = new FbCommandBuilder(adapter)) {
        countUpdated = 0;
        adapter.RowUpdated += new FbRowUpdatedEventHandler(OnRowUpdated);
        adapter.Update(dataTable);
     }
     ...
        protected void OnRowUpdated(object sender, FbRowUpdatedEventArgs e)
        {
            e.Command.Dispose();  // is this necessary? <---!!!!
            // it's for me ...
            if((++_countUpdated % 1000) == 0) {
                _transaction.CommitRetaining();
            }
        }
    ...
</code>
without Dispose - 20000 rows updated... firebird server eats > 600mb
(leaks of memory) of memory!!!

-- 
Ufff...
 Evgeny                          mailto:uf...@pb...