Newest price for an item in LINQ / LAMBDA

Question

how di O formulate the foolowing in LINQ with LAMBDA expressions.

Given (for simplicity - this is actually later a join) a table with the fields:

which is mapped to a class. I use BlToolkit, but could also be LINQ or ETF - makes no differnce.

I want the object with Item = 2 and the hightst timestamp (newest) and / or a query of ALL items but ONLY the most current object.

How do I formulate this?

I understand this likely will be a subselect ivolved, but I have a problem finding the correct syntax.

asked 2 hours ago

TomTom
13.4k1728

68% accept rate

ColinE · Answer 1 · 2011-06-09 07:20:13Z

Using fluent syntax, the item with the highest timestamp, and Item==2 is:

var item= table.Where(i => i.Item == 2)
               .OrderBy(i => i.Timestamp)
               .SingleOrDefault();

1 Answer