if a query has two update statements what will ExecuteNonQuery() return?

Question

if a query has two update statements what executenonquery will return? Will it club the row count affected in both the update statements OR will return the count updated in last statement?

I think it is easy to check. – Hamlet Hakobyan Feb 10 '16 at 06:32 — Hamlet Hakobyan, Feb 10 '16 at 06:32

score 1 · Answer 1 · answered Feb 10 '16 at 06:46

1

It return summary of total row affected of all statement. For example, if first statement result is 3 row affected and second statement is 12 row affected, then the return value would be 15

answered Feb 10 '16 at 06:46

Dfirmansyah

398
2
10

if a query has two update statements what will ExecuteNonQuery() return?

1 Answers1