Bulk insert?

G

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
 
W

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.
__________________________________
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Bulk insert into DB using ADO.net 1.1 1
SQLBulkCopy performance problem 2
does Ado.Net 2.0 have bulk insert functionality? 6
Bulk insert to sql server 2
Insert Performance 4
Bulk Insert 1
Bulk Insert Data? Data in Millions 12
Transactions in ADO.NET or SQL SP 1

Top