rows-affected

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

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. ...

What can cause 'rows affected' to be incorrect?

Using Microsoft SQL Server Management Studio 2008. I have done a simple transaction: BEGIN TRAN SELECT ko.ID, os.ID AS ID2 FROM table_a AS ko JOIN table_b AS os ON os.ID=ko.ID WHERE (ko.the_date IS NOT NULL AND os.the_date IS NULL); UPDATE table_b SET the_date=ko.the_date FROM table_a AS ko JOIN table_b AS os ON os.ID=ko.ID WHERE (ko....