ConflictOption Enumeration
Collapse the table of content
Expand the table of content

ConflictOption Enumeration


Specifies how conflicting changes to the data source will be detected and resolved.

Namespace:   System.Data
Assembly:  System.Data (in System.Data.dll)

Public Enumeration ConflictOption

Member nameDescription

Update and delete statements will include all searchable columns from the table in the WHERE clause. This is equivalent to specifying CompareAllValuesUpdate | CompareAllValuesDelete.


If any Timestamp columns exist in the table, they are used in the WHERE clause for all generated update statements. This is equivalent to specifying CompareRowVersionUpdate | CompareRowVersionDelete.


All update and delete statements include only PrimaryKey columns in the WHERE clause. If no PrimaryKey is defined, all searchable columns are included in the WHERE clause. This is equivalent to OverwriteChangesUpdate | OverwriteChangesDelete.

.NET Framework
Available since 2.0
Return to top
© 2015 Microsoft