SqlHelper.ExecuteUpsert method

Executes an UPSERT (insert or update) query on the connection and returns the number of affected rows. The key fields are used to determine whether an existing record is updated or a new record is inserted.

public static int ExecuteUpsert(this SqlInsert query, IDbConnection connection, 
    IEnumerable<string> keyFields, ExpectedRows expectedRows = ExpectedRows.Ignore, 
    ILogger logger = null)

parameter	description
query	The insert query.
connection	The connection.
keyFields	List of key fields (e.g. primary key columns) used to match an existing record.
expectedRows	The expected rows. Used to validate the expected number of affected rows.
logger	The logger.

Return Value

The number of affected rows.

See Also

• class SqlInsert
• enum ExpectedRows
• class SqlHelper