Performing Batch Operations Using DataAdapters
Batch support in ADO.NET allows a DataAdapter to group INSERT, UPDATE, and DELETE operations from a DataSet or DataTable to the server, instead of sending one operation at a time. The reduction in the number of round trips to the server typically results in significant performance gains. Batch updates are supported for the .NET data providers for SQL Server (System.Data.SqlClient) and Oracle (System.Data.OracleClient).
- Performing Batch Updates with a DataAdapter
Describes how to enable batch processing support when updating a data source with changes from a DataSet.
- Handling Batch Update-Related Events and Errors
Describes how to use a new set of events that are introduced for batch updates.