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

Other Resources

Modifying Data in ADO.NET