Bulk Loading, Batch Execution, and Paging

Bulk Loading, Batch Execution, and Paging

As we discussed in Chapter 1, there are many changes, updates, and improved features in ADO.NET version 2.0. In this chapter we'll look in detail at some of these, including:

• New classes that enable managed code to perform bulk copying of data, achieving the same kind of effects as the command-line BCP utility

• The ability to send update commands in batches using a DataAdapter

• Built-in support for data paging using the new ExecutePageReader method of the Command class

• Retrieving from a connection the statistics that describe the processes it is handling

This isn't a comprehensive list of the new features, however. You'll see more in the following chapters as well. But we start here with a look at the new bulk data copy features in ADO.NET 2.0.