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