Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
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.

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

Community Additions

© 2015 Microsoft