How to get records affected by an update stored procedure in LINQ to SQL

Question

I'm executing an update stored procedure from LINQ to SQL and I need to know the records affected after the update is called.

I'm using dbml designer to generate the LINQ code.

Answer 1

I've not tried any of the answers and I don't know which is the correct answer. I returned @@rowcount as result set.