RdaBatchOption Enumeration
Specifies whether or not the rows associated with the Push should be batched together in a single transaction.
Namespace: System.Data.SqlServerCe
Assembly: System.Data.SqlServerCe (in system.data.sqlserverce.dll)
Syntax
'Declaration
Public Enumeration RdaBatchOption
'Usage
Dim instance As RdaBatchOption
public enum RdaBatchOption
public enum class RdaBatchOption
public enum RdaBatchOption
public enum RdaBatchOption
Members
| Member name | Description | |
|---|---|---|
.gif) |
BatchingOff | Indicates that SQL Server Compact Edition does not batch rows pushed to SQL Server. The server processes each row separately. This is the default setting. |
|
BatchingOn | Indicates that SQL Server Compact Edition batches the rows pushed to SQL Server into a single transaction. |
Remarks
This property specifies whether Microsoft SQL Server 2005 Compact Edition should batch the changes being sent to the SQL Server table. The default setting, BatchingOff, specifies that insert, update, and delete changes are applied to the SQL Server table as individual transactions. In this case, each transaction is not dependent 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 entire 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 "Remote Data Access (RDA) Conflict Detection and Reporting" in the SQL Server Compact Edition Books Online.
Platforms
Windows CE, Windows Mobile for Pocket PC, Windows Mobile for Smartphone, Windows XP Professional x64 Edition, Windows XP SP2
The Microsoft .NET Framework 3.0 is supported on Windows Vista, Microsoft Windows XP SP2, and Windows Server 2003 SP1.
Version Information
.NET Framework
Supported in: 3.0
.NET Compact Framework
Supported in: 2.0, 1.0