Given a table and data like
Id  Year  Code  ColB  ColC
1   2013  A     Foo   Bar
2   2014  A     Baz   Qux
3   2014  B     Jax   Fizz
4   2013  C     Buub  Baq
I wish to select the "newest" row for each code, e.g.:
Id  Year  Code  ColB  ColC
2   2014  A     Baz   Qux
3   2014  B     Jax   Fizz
4   2013  C     Buub  Baq
I see this can be done directly in SQL
select a,b 
from (
select a,b,row_number() over(partition by a order by b desc) as roworder
from myTable
) temp
where roworder = 1
https://stackoverflow.com/a/7344770/141172
Can this be expressed in Linq to Entities?
 
    