Add + 1 to LastOrDefault

Harlem 98

4y1.6kLINQ

Hello community.

I'm doing an insert form, and i'm trying to use a LastOrDefault to get the new value, and creating a new one binding it +1 , but i don´t know how to trasnlate this programatically. Could you help me?

//LastOrDefaultpublic ListagemTimesheet CreateNewID(int ID){using (GestaoProjectosEntities lt = new GestaoProjectosEntities()){return lt.ListagemTimesheets.LastOrDefault(a => a.ID == ID);}}//form.CSint idtimesheet = int.Parse(e.Item.OwnerTableView.DataKeyValues[e.Item.ItemIndex]["ID"].ToString()); //find for an existing ID
ListagemTimesheet timesheet = listagembll.CreateNewID(idtimesheet); //LastOrDefault //Create a new ID ?

3 Replies

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

Sachin Singh4y ago
here nextId should be your last +1;
var nextId=lt.ListagemTimesheets.LastOrDefault(a => a.ID == ID)+1;
Rajesh Gami4y ago
You can set identity by 1 in SQL Server database table or you can find the maximum primary key id and add by 1.
And also we can manage by computed column
Satya Karki4y ago
Hi, there are two ways to handle Id.

1. One way is you can make your ID filed auto increment in the database so that you don't need to check and add 1 for new Id. Database handles ID by itself.
2. Get Max Id from the database and add 1 while inserting new data.