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.

Answer 1

As of now in Controller's Action method I am using the code below to set no of records per page

 

return View(viewModel.ToList().ToPagedList(page ?? 1, 50)); 

Answer 2

How you are getting data from Controller's action: AJAX or direct call to action.

 

Provide some code snippet.