Re: [Firebird-net-provider] Batch execution of commands

2011-11-30 Thread Paulo Gomes
Hi Luigi, You could always build the string script and run it with the FbScript. I don't think thats the best aproach to your problem. I would use a transaction which would commit each 50-100 calls, and the fbcommand should have a fbcommand.Prepare() to avoid the parser to analyse ea

[Firebird-net-provider] Batch execution of commands

2011-11-30 Thread Luigi Piccinni
Hi everyone, Do you know if it is possible, using the Firebird .NET Provider, to batch a number of commands in one single excution? I searched in the code but I only was able to find FbBatchExecution that executes plain statements or a script of statements. Since I need to execute a single store