How Do I Get Last Record From Table In This Scenior

See more:

C#

ASP

i have database table in which i am storing multiple status of same employee ,and then get these record in to the report,it work fine ,problem is here when i add a little bit change in the his status that status add as fresh record because i want to save previous one so can use update method.now i want to get last record of that employee c# code is here.

var incharge = _service.GetEmployeeStatusBySector_Id(sectorId).Where(x => x.DutyType_Id == 7 && x.EmployeeStatusType_Id == 1 && x.IsDutiable == true);
           foreach (EmployeeStatus Inchargesector in incharge)
           {
               var emp = _service.GetEmployee(Inchargesector.Employee_Id);

               foreach (var empp in incharge)
               {
                   dataset.InchargeSector.Rows.Add(Inchargesector.EmployeeShift_Id, emp.Name, emp.RankName, emp.CellNo);
                   InchargeSector.Remove(empp);
               }

           }

i cant use it as follow that create problem

var incharge = _service.GetEmployeeStatusBySector_Id(sectorId).Where(x => x.DutyType_Id == 7 && x.EmployeeStatusType_Id == 1 && x.IsDutiable == true).last();