I'm using UpdateMulti on table that has an AFTER trigger updating another column, and hence UpdateMulti returns affected records x 2.

Is there a way to have affected records not include trigger updates?

Not that I know of. The workaround is to divide the result by 2.

Walaa wrote:

Not that I know of. The workaround is to divide the result by 2.

thanks! that's what I'm doing. Not so pretty

morten71 wrote:

Walaa wrote:

Not that I know of. The workaround is to divide the result by 2.

thanks! that's what I'm doing. Not so pretty

Not so pretty, but this value is retrieved directly from the provider. Quote from MSDN:

MSDN wrote:

For UPDATE, INSERT, and DELETE statements, the return value is the number of rows affected by the command. When a trigger exists on a table being inserted or updated, the return value includes the number of rows affected by both the insert or update operation and the number of rows affected by the trigger or triggers. For all other types of statements, the return value is -1. If a rollback occurs, the return value is also -1.