Well a couple things come to mind. One is to model the batch insert functionality after the way it works in iBatis for Java. If that doesnt work because of the ADO.NET restrictions then perhaps we could instead pass a collection of domain objects as a parameter to an insert query? Then ibatis would then iterate over the collectino and generate a single query?
The Stored procedure option sounds promising... On Mon, Jun 30, 2008 at 12:43 PM, Gilles Bayon <[EMAIL PROTECTED]> wrote: > In ADO.NET <http://ado.net/> there is no simple way to do batch statement > in a db provider independent manner as in JBDC. > > For now, I haven't think of a good solution to implement batch support in > iBATIS.NET. > Perhaps other people have some ideas ? > > If you use SQL Server you do that with a store procedure and an XML in > parameter. > > -- > Cheers, > Gilles > -- Ben Monro Software Developer
