I'm quite new to LINQ.

Suppose that I had the following table:

Incident 

ID DeviceID Time          Info

1    1      5/2/2009    d

2    2      5/3/2009    c

3    2      5/4/2009    b

4    1      5/5/2009    a

In LINQ, how could I write a query that finds the most recent and distinct (on Device ID) set of incidents? The result I'd like is this:

ID DeviceID Time           Info

3    2      5/4/2009    b

4    1      5/5/2009    a

Do you have to create an IEqualityComparer to do this?

linq sql-order-by distinct
Edit
Report