Bulk insert?

[Guest]

I've read that ado.net 2.0 have som build in feature to performe multiple
inserts on a table? Does anyone know of a tutorial/example? Is it best
practice to use?

Thanks

 

[William \(Bill\) Vaughn]

There are two features that might be confusing at first:
1) ADO.NET 2.0 (like ADO classic) now supports the ability to "batch"
several (N) operations in a single round trip. This called "batch
processing"
2) ADO.NET 2.0 (unlike ADO classic) SqlClient provider now supports the
ability to create a SqlBulkCopy instance that can import data to SQL Server
far faster than any INSERT scheme you can come up with.

hth

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________