How to remove column-duplicates from the query result using entity-framework?

Posted by Jronny on Stack Overflow See other posts from Stack Overflow or by Jronny
Published on 2010-04-26T01:18:11Z Indexed on 2010/04/26 1:23 UTC
Read the original article Hit count: 367

Filed under:

On my database table I have

Key    | Value
a      | 1
a      | 2
b      | 11
c      | 1
d      | 2
b      | 3

But I just need to get the items which keys are not duplicates of the previous rows. The desired result should be:

Key    | Value
a      | 1
b      | 11
c      | 1
d      | 2

How could we get the desired result using entity-framework?

Note: we need the first value. Thank you very much.

© Stack Overflow or respective owner

Related posts about entity-framework