Syntax

IDbCommand GetUpsertCommand();

Remarks

Gets a command that allows you to add upsert (insert/update) operations to the direct download data operations. The command that is returned has the same number of parameters as columns in this table. The column values for the insert must be set and the statement executed with ExecuteNonQuery() for the insert/update to be included in the download. ExecuteNonQuery() on the command returns 0 if the insert/update operation was filtered and returns 1 if the insert/update was not filtered.

You cannot add or remove parameters to this command; you can only set their values.

Returns

A Command for inserts/updates for the download.

Example

See DownloadTableData interface.