Linq To Entities Get 2nd Last entry In List

Question

I have the following code which returns a list of Objects.

var listOfLogins = _logService.GetLogEventsByItemID(137).ToList();

I would like to get the 2nd last object in this list.

Does anyone know how to do this using Linq to Entities?

Thanks.

Answer 1

var secondlast = _logService.GetLogEventsByItemID(137)
    .Reverse()
    .Skip(1)
    .Take(1)
    .FirstOrDefault();

Update
@Dherik makes a good point in his comment that .Reverse is not actually supported in LINQ to Entities and will result in the query being evaluated at the point of calling reverse, rather than at the point of calling .FirstOrDefault. See here for all (not) supported methods.

The alternative (LINQ to Entities friendly) solution requires that you have a suitable field to order by (which must be the case anyway otherwise "second last" has no relevance):

var secondlast = _logService.GetLogEventsByItemID(137)
    .OrderByDescending(e => e.EventDate /* could be any db field */)
    .Skip(1)
    .Take(1)
    .FirstOrDefault();