SQLProvider

OnConflict Type

Namespace: FSharp.Data.Sql.Common
Assembly: FSharp.Data.SqlProvider.Common.dll
Base Type: ValueType
All Interfaces: IEquatable<OnConflict> , IStructuralEquatable , IComparable<OnConflict> , IComparable , IStructuralComparable
Kind: Struct

Specifies how to handle conflicts when inserting records with duplicate primary keys. Currently supported only on databases that have UPSERT capabilities.

Union cases

Union case	Description
`DoNothing` Full Usage: `DoNothing`	If the primary key already exists, leaves the existing row unchanged. Currently supported only on PostgreSQL 9.5+
`Throw` Full Usage: `Throw`	Throws an exception if the primary key already exists (default behaviour).
`Update` Full Usage: `Update`	If the primary key already exists, updates the existing row's columns to match the new entity. Currently supported only on PostgreSQL 9.5+

Instance members

Instance member	Description
`this.IsDoNothing` Full Usage: `this.IsDoNothing` Returns: `bool`	Returns: `bool`
`this.IsThrow` Full Usage: `this.IsThrow` Returns: `bool`	Returns: `bool`
`this.IsUpdate` Full Usage: `this.IsUpdate` Returns: `bool`	Returns: `bool`