what is the best way to structure this query

Question

I have a IEnumerable collection of objects. The objects have a field LastedUpdated which is a DateTime field.

I want to filter the collection, given a timestamp that I have, to return the record in the collection with that timestamp and the "next record" in time (based on this field) because I then want to have some code do a "diff" between the two different records to show what has changed.

I am trying to figure out the best way to take a collection and do this filtering possibly using LINQ

Any suggestions?

Answer 1

This isn't the most efficient, but unless you think performance is an issue, I'd consider it clearest.

var objsByDate = objects.OrderBy(x => x.LastedUpdated).ToArray();
int matchIdx = Array.FindIndex(objsByDate, x => x.LastedUpdated == timestamp);

if (matchIdx >= 0)
{
    var match = recentObjects[matchIdx];
    var next = recentObjects[matchIdx + 1]; // assuming it exists
}

Answer 2

How about this?

var results = (from o in objects
  where o.lastupdated >= tstamp
  orderby o.lastupdated
  select o).Take(2);