ConflictOption Enumeration

 
System_CAPS_noteNote

The .NET API Reference documentation has a new home. Visit the .NET API Browser on docs.microsoft.com to see the new experience.

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: