if you are using Microsoft SQL Server as your database and intend not to
change it for a long time, then you can use "SqlBulkCopy Class". This class
helps in batch uploading of data into a database table.

The SqlBulkCopy class can be used to write data only to SQL Server tables.
However, the data source is not limited to SQL Server; any data source can
be used, as long as the data can be loaded to a DataTable.

Refer the following links:

http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlbulkcopy.aspx
http://www.codeproject.com/KB/database/SqlBulkCopy.aspx

If you come across a solution to this in iBatis.Net, please post a comment
on it.



=========================================================

Ben Monro wrote:
> 
> Does anyone know if there is a way to do batch inserts with iBatis for
> .NET?
> 
> -- 
> Ben Monro
> Software Developer
> 
> 

-- 
View this message in context: 
http://www.nabble.com/batch-inserts-tp18124219p18645611.html
Sent from the iBATIS - User - Cs mailing list archive at Nabble.com.

Reply via email to