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
