How to get double records using LinQ?

Question

I'm writing a query in .NET using LinQ technology. I want get all double records from field city. If the city count is equel to 1, then i don't want to get this in my results. Only 2 or more times. Does anyone know how I must write my query?

Thanks a lot.

Jordy

You need to show some code and read the guidance as to how to ask question here... http://stackoverflow.com/questions/how-to-ask — MoonKnight, Feb 13 '14 at 12:21
Such records are called "duplicates" in programmers' slang. Look for "find duplicates with linq" for solutions. — Sergey Kalinichenko, Feb 13 '14 at 12:22

score 4 · Accepted Answer · answered Feb 13 '14 at 12:20

4

entities.GroupBy(e => e.City)
        .Where(g => g.Count() > 1)
        .Select(g => g.Key);

Query syntax

from e in entities
group e by e.City into g
where g.Count() > 1
select g.Key

answered Feb 13 '14 at 12:20

Sergey Berezovskiy

232,247
41
429
459

How to get double records using LinQ?

1 Answers1