Export (0) Print
Expand All

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

Show:
© 2014 Microsoft