How to retrive the last inserted item ID in LINQ

Question

Hi,

                from the table i need to get the last inserted item id in LINQ. I am new to this...

        I have a table with columns like ID, NAME,DESCRIPTION, SEQUENCE ID,CREATEDBY,CREATED ON. When ever i insert a record i update the SEQUENCE ID with the existing SEQUENCE ID+1. After some time i need to retrive that last inserted SEQUENCE ID. That too using LINQ.

Thanks,
Vijay.