United States (English)

Home Library Learn Samples Downloads Support Community Forums

MSDN Library

.NET Development

.NET Framework 4.5

.NET Framework Class Library

System.Data Namespaces

System.Data

AcceptRejectRule Enumeration

CommandBehavior Enumeration

CommandType Enumeration

ConflictOption Enumeration

ConnectionState Enumeration

Constraint Class

ConstraintCollection Class

ConstraintException Class

DataColumn Class

DataColumnChangeEventArgs Class

DataColumnChangeEventHandler Delegate

DataColumnCollection Class

DataException Class

DataRelation Class

DataRelationCollection Class

DataRow Class

DataRowAction Enumeration

DataRowBuilder Class

DataRowChangeEventArgs Class

DataRowChangeEventHandler Delegate

DataRowCollection Class

DataRowComparer Class

DataRowComparer(TRow) Class

DataRowExtensions Class

DataRowState Enumeration

DataRowVersion Enumeration

DataRowView Class

DataSet Class

DataSetDateTime Enumeration

DataSetSchemaImporterExtension Class

DataSysDescriptionAttribute Class

DataTable Class

DataTableClearEventArgs Class

DataTableClearEventHandler Delegate

DataTableCollection Class

DataTableExtensions Class

DataTableNewRowEventArgs Class

DataTableNewRowEventHandler Delegate

DataTableReader Class

DataViewManager Class

DataViewRowState Enumeration

DataViewSetting Class

DataViewSettingCollection Class

DBConcurrencyException Class

DbType Enumeration

DeletedRowInaccessibleException Class

DuplicateNameException Class

EntityCommandCompilationException Class

EntityCommandExecutionException Class

EntityException Class

EntityKey Class

EntityKeyMember Class

EntitySqlException Class

EntityState Enumeration

EnumerableRowCollection Class

EnumerableRowCollection(TRow) Class

EnumerableRowCollectionExtensions Class

EvaluateException Class

FillErrorEventArgs Class

FillErrorEventHandler Delegate

ForeignKeyConstraint Class

IColumnMapping Interface

IColumnMappingCollection Interface

IDataAdapter Interface

IDataParameter Interface

IDataParameterCollection Interface

IDataReader Interface

IDataRecord Interface

IDbCommand Interface

IDbConnection Interface

IDbDataAdapter Interface

IDbDataParameter Interface

IDbTransaction Interface

IExtendedDataRecord Interface

InRowChangingEventException Class

InternalDataCollectionBase Class

InvalidCommandTreeException Class

InvalidConstraintException Class

InvalidExpressionException Class

IsolationLevel Enumeration

ITableMapping Interface

ITableMappingCollection Interface

KeyRestrictionBehavior Enumeration

LoadOption Enumeration

MappingException Class

MappingType Enumeration

MergeFailedEventArgs Class

MergeFailedEventHandler Delegate

MetadataException Class

MissingMappingAction Enumeration

MissingPrimaryKeyException Class

MissingSchemaAction Enumeration

NoNullAllowedException Class

ObjectNotFoundException Class

OperationAbortedException Class

OptimisticConcurrencyException Class

OrderedEnumerableRowCollection(TRow) Class

ParameterDirection Enumeration

PropertyAttributes Enumeration

PropertyCollection Class

PropertyConstraintException Class

ProviderIncompatibleException Class

ReadOnlyException Class

RowNotInTableException Class

Rule Enumeration

SchemaSerializationMode Enumeration

SchemaType Enumeration

SerializationFormat Enumeration

SqlDbType Enumeration

StateChangeEventArgs Class

StateChangeEventHandler Delegate

StatementCompletedEventArgs Class

StatementCompletedEventHandler Delegate

StatementType Enumeration

StrongTypingException Class

SyntaxErrorException Class

TypedDataSetGenerator Class

TypedDataSetGeneratorException Class

TypedTableBase(T) Class

TypedTableBaseExtensions Class

UniqueConstraint Class

UpdateException Class

UpdateRowSource Enumeration

UpdateStatus Enumeration

VersionNotFoundException Class

XmlReadMode Enumeration

XmlWriteMode Enumeration

Minimize

0 out of 1 rated this helpful - Rate this topic

ConflictOption Enumeration

.NET Framework 4.5

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 name	Description
	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.

Version Information

.NET Framework

Supported in: 4.5, 4, 3.5, 3.0, 2.0

.NET Framework Client Profile

Supported in: 4, 3.5 SP1

Windows 8, Windows Server 2012, Windows 7, Windows Vista SP2, Windows Server 2008 (Server Core Role not supported), Windows Server 2008 R2 (Server Core Role supported with SP1 or later; Itanium not supported)

The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.

Reference

System.Data Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

© 2013 Microsoft. All rights reserved.