ConflictOption Enumeration
TOC
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 enum ConflictOption

Member nameDescription
CompareAllSearchableValues

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

CompareRowVersion

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.

OverwriteChanges

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
Show:
© 2016 Microsoft