Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - Programming » SQL Anywhere .NET 2.0 API Reference

RemoveAt method Next Page

SABulkCopyOptions enumeration

A bitwise flag that specifies one or more options to use with an instance of SABulkCopy.


Visual Basic

Public Enum SABulkCopyOptions


public enum SABulkCopyOptions


The SABulkCopyOptions enumeration is used when you construct an SABulkCopy object to specify how the WriteToServer methods will behave.

Restrictions: The SABulkCopyOptions class is not available in the .NET Compact Framework 2.0.

The CheckConstraints and KeepNulls options are not supported.

Member nameDescriptionValue
Default Specifying only this value causes the default behavior to be used. By default, triggers are enabled. 0
DoNotFireTriggers When specified, triggers are not fired. Disabling triggers requires DBA permission. Triggers are disabled for the connection at the start of WriteToServer and the value is restored at the end of the method. 1
KeepIdentity When specified, the source values to be copied into an identity column are preserved. By default, new identity values are generated in the destination table. 2
TableLock When specified the table is locked using the command LOCK TABLE table_name WITH HOLD IN SHARE MODE. This lock is in place until the connection is closed. 4
UseInternalTransaction When specified, each batch of the bulk-copy operation is executed within a transaction. When not specified, transaction aren't used. If you indicate this option and also provide an SATransaction object to the constructor, a System.ArgumentException occurs. 8
See also