I have a procedure that inserts N records and then updates N records. ExecuteNonQuery on that procedure returns 2N. Is there a way to return only number of records updated, i.e. affected in the statement run last? 

Thanks.