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 each command.

     Hope this helps.

Paulo Gomes

Em 30-11-2011 12:00, Luigi Piccinni escreveu:
> 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 procedure many times changing its
> parameters, I prefer to batch the commands and execute the batch once every
> 50-100 calls.
>
> For example something like this:
>
> While(haveValuesToInsert)
> {
>       fbCommand.Parameters[0].Value = someValue;
>       fbCommand.Parameters[1].Value = someOtherValue;
>       Batch.Add(fbCommand);
> }
> Batch.ExecuteBatch();
>
>
> Thanks for the anwers.
>
>    Luigi.
>
>
> __________ Information from ESET NOD32 Antivirus, version of virus signature
> database 6671 (20111130) __________
>
> The message was checked by ESET NOD32 Antivirus.
>
> http://www.eset.com
>
>
>
> ------------------------------------------------------------------------------
> All the data continuously generated in your IT infrastructure
> contains a definitive record of customers, application performance,
> security threats, fraudulent activity, and more. Splunk takes this
> data and makes sense of it. IT sense. And common sense.
> http://p.sf.net/sfu/splunk-novd2d
> _______________________________________________
> Firebird-net-provider mailing list
> Firebird-net-provider@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure 
contains a definitive record of customers, application performance, 
security threats, fraudulent activity, and more. Splunk takes this 
data and makes sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-novd2d
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Reply via email to