Performing Batch Operations Using DataAdapters
Important This document may not represent best practices for current development, links to downloads and other resources may no longer be valid. Current recommended version can be found here. ArchiveDisclaimer

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

In This Section

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.

See Also

© 2015 Microsoft