C# LINQ find duplicates in List

by

The easiest way to solve the problem is to group the elements based on their value, and then pick a representative of the group if there are more than one element in the group. In LINQ, this translates to:

var query = lst.GroupBy(x => x)
              .Where(g => g.Count() > 1)
              .Select(y => y.Key)
              .ToList();

If you want to know how many times the elements are repeated, you can use:

var query = lst.GroupBy(x => x)
              .Where(g => g.Count() > 1)
              .Select(y => new { Element = y.Key, Counter = y.Count() })
              .ToList();

This will return a List of an anonymous type, and each element will have the properties Element and Counter, to retrieve the information you need.

And lastly, if it’s a dictionary you are looking for, you can use

var query = lst.GroupBy(x => x)
              .Where(g => g.Count() > 1)
              .ToDictionary(x => x.Key, y => y.Count());

This will return a dictionary, with your element as key, and the number of times it’s repeated as value.

More Related Contents:

  1. How to split Fromdate and Todate based on weekdays(Sat,Sun) using linq c#
  2. IEnumerable vs List – What to Use? How do they work?
  3. LINQ: Distinct values
  4. Entity framework linq query Include() multiple children entities
  5. How can I do an OrderBy with a dynamic string parameter?
  6. LINQ to Entities does not recognize the method ‘System.String Format(System.String, System.Object, System.Object)’
  7. Combination of List
  8. How to view LINQ Generated SQL statements?
  9. LINQ across multiple databases
  10. Convert String to Int in EF 4.0
  11. System.LINQ.Dynamic: Select(” new (…)”) into a List (or any other enumerable collection of )
  12. LINQ Join with Multiple Conditions in On Clause
  13. How to get the closest number from a List with LINQ?
  14. Standard Deviation in LINQ
  15. How To Project a Line Number Into Linq Query Results
  16. Calculate difference from previous item with LINQ
  17. .NET List Concat vs AddRange
  18. Conversion from List to array T[]
  19. Entity Framework – “Unable to create a constant value of type ‘Closure type’…” error
  20. How to create a dynamic LINQ join extension method
  21. EF 4: Removing child object from collection does not delete it – why?
  22. How to dynamically add OR operator to WHERE clause in LINQ
  23. Get a list of distinct values in List
  24. Using Linq Except not Working as I Thought
  25. How to Quickly Remove Items From a List
  26. Greater Than Condition in Linq Join
  27. How do I write this cross apply query in LINQ-to-SQL?
  28. Can’t make GroupJoin work. NavigationExpandingExpressionVisitor exception
  29. What is the best way to check two List lists for equality in C#
  30. How to implement Unit of Work that works with EF and NHibernate

Leave a Comment