This generates a
DELETE statement against a table using a key or list of keys.
…ByKeyvariants accept a single keys.
…ByKeyListvariants accept a list of keys.
Keys must be scalar values (string, int guid, etc.)
newValues object is used to generate the
SET clause of the
UDPATE statement in the same manner as the normal
Update command builder.
Rows are returned in a non-deterministic order.
This feature only works on tables that have a scalar primary key.
This will generate a WHERE clause in the form of
PrimaryKey = @Param or
PrimaryKey in (@Param1, @Param2, ...).
Possible enhancement: use tuples to support compound primary keys. This would require an upgrade to the metadata provider, as we would need to know the exact order for the primary key.