Windows apps
Collapse the table of content
Expand the table of content
Information
Switch
Switch
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

ConflictOption Enumeration

.NET Framework (current version)
 

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

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

C#
C++
F#
VB
Copy 
public enum class 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:
© 2017 Microsoft