This chapter has covered a range of different topics and features that are new in ADO.NET version 2.0. These features are designed both to make application construction easier and to improve the usability and reach of ADO.NET.
The ability to bulk-load a database table with data has been added to ADO.NET version 2.0, using entirely managed code through several new .NET classes. This chapter demonstrated how it's done and how it can be adapted to match a range of different data management and administrative requirements.
A new "batch execution" feature has been added to ADO.NET 2.0. This feature is implemented in the DataAdapter class in order to reduce the number of round-trips made to the database when updating changes from a DataSet.
This chapter also demonstrates how the ExecutePageReader method of the Command class allows pages of data to be fetched from a data source so that an application can easily present a rowset of data broken down into separate pages.
In version 2.0 of ADO.NET, you can now easily monitor the processes that are in progress across a connection to a data store by retrieving the execution statistics from the database once the process is complete. We showed a simple example, connecting to a SQL Server database and using a SqlConnection (this is the only namespace that supports this feature at the moment).
In the next chapter, we'll look at some more new features of ADO.NET 2.0, including MARS, asynchronous connection and commands, and a brief overview of the new ObjectSpaces technology