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 NAMEDESCRIPTION SEQUENCE IDCREATEDBYCREATED 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.

Vulpes · Answer

The query to do that will be something like this: int id = (from record in table orderby record.SequenceId descending select record.SequenceId).First(); or you could also use: int id = (from record in table orderby record.SequenceId select record.SequenceId).Last();

Suthish Nair · Answer

How you inserting records using LINQ? If your are inserting records using LINQ then on after SubmitChanges() you can get it from .ID