[Mono-list] Batch inserts with ADO.NET

[Carlos Guzmán Álvarez]

Hello:

>PreparedStatement statement = connection.prepareStatement("INSERT
>INTO....");
>                        
>            for (int i = 0; i < 1000; i++)
>            {
>                    statement.setInt(1,rand.nextInt());
>                    statement.addBatch();
>            }
>            statement.executeBatch();
>
Maybe you can use parametrized querys and the
XxCommand.Prepare method ??




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain