CODEWITHSUNDEEP
linqentity-frameworklinq-to-entities
tcode
tcode

Reputation: 5105

Linq To Entities Get 2nd Last entry In List

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.

Upvotes: 4

Views: 2579

Answers (2)

Paul Fleming
Paul Fleming

Reputation: 24526

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();

Upvotes: 10

Luiz Carlos Brazão
Luiz Carlos Brazão

Reputation: 202

    int[] items = new int[] { 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 };
    int item = items.Skip(items.Count() - 2).Take(1).Single();
    //will return 9

like this?

Upvotes: 0

Related Questions