Loading

How to retrive the last inserted item ID in LINQ

vijay rags

15y29.5kLINQ

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.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

FRAiDOON FETRAT5y ago
int id = (from r in tableName orderby r.ID select r.ID).MAX();
Suthish Nair15y ago
How you inserting records, using LINQ?

If your are inserting records using LINQ, then on after SubmitChanges() you can get it from ".ID"
Vulpes15y ago
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();