O'Reilly logo

Programming Microsoft® ADO.NET 2.0 Core Reference, 2nd Edition by David Sceppa

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

SQL Bulk Copy

Batched updates are great, but SQL Server offers a much more efficient approach for submitting new rows to the database. SQL Server’s Bulk Copy Protocol features, commonly referred to as BCP, have been available since the early days of SQL Server, predating ODBC.

BCP is powerful and extremely fast because SQL Server allows you to insert rows via BCP that bypass many SQL Server operations, such as firing triggers or enforcing constraints. However, many developers have traditionally found BCP frustrating, a bit archaic, or both because it required placing the data to import in specially formatted files.

ADO.NET 2.0 introduces a new class, SqlBulkCopy, specifically designed to help developers access SQL Server’s BCP features. Rather than ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required