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
