Re: [Firebird-net-provider] Dispose in OnRowUpdated

[Carlos G. A. <car...@te...>]

Hello:

> 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();
>             }
>         }

In first place can be needed i will try to do some test later today.




-- 
Best regards

Carlos Guzmán Álvarez
Vigo-Spain