Why does Dapper's .Execute(...) return an int?

Question

Anyone know why Dapper returns an int from .Execute(...) ?

I can't find this documented anywhere.

Answer 1

The integer represents the number of rows that were affected by your query.

It returns an integer so you know if your query has worked. If zero is returned and you expected something to have changed then you know there is a problem.