RDA_BATCHOPTION
The RDA_BATCHOPTION enumeration specifies whether the rows associated with the push should be batched together in a single transaction.
Members
The following table describes the enumerators of the RDA_BATCHOPTION enumeration and their corresponding values.
| Member name | Value | Description |
|---|---|---|
BATCHINGOFF |
0 |
SQL Server 2005 Compact Edition (SQL Server Compact Edition) does not batch rows pushed to SQL Server. The server processes each row. This is the default setting. |
BATCHINGON |
1 |
SQL Server Compact Edition batches the rows pushed to SQL Server into a single transaction. |
Remarks
The default setting is BATCHINGOFF, where insert, update, and delete changes are applied to the SQL Server table as individual transactions. No transaction depends on another to succeed. BATCHINGON specifies that all changes be sent as a single transaction. In this case, all changes must succeed for the transaction to be successful. If one change fails, the complete transaction fails, and no changes are applied to the SQL Server table.
Both BATCHINGON and BATCHINGOFF return all errors to the error table, not just the first error that occurs. For example, if BATCHINGON is specified and three out of five changes fail, no changes are applied and all three failures are stored in the error table. If BATCHINGOFF is specified, the same three failures are stored in the error table and the other two changes are applied to the SQL Server table. For more information about handling batch errors, see RDA Conflict Detection and Reporting.
See Also
Other Resources
SQL Server Compact Edition Remote Data Access Programming