linq to sql and sp insert

[Badgers]

Hi,

I have written some linq to sql which uses a stored procedure to do an insert.

I can't figure out how to get the linq code to return the rows affected, or the idenity column. I'd use this to detect whether the insert operation has been successfull or
not.

Thanks in advance

Tim