Select distinct using linq

myList.GroupBy(test => test.id)
      .Select(grp => grp.First());

Edit: as getting this IEnumerable<> into a List<> seems to be a mystery to many people, you can simply write:

var result = myList.GroupBy(test => test.id)
                   .Select(grp => grp.First())
                   .ToList();

But one is often better off working with the IEnumerable rather than IList as the Linq above is lazily evaluated: it doesn’t actually do all of the work until the enumerable is iterated. When you call ToList it actually walks the entire enumerable forcing all of the work to be done up front. (And may take a little while if your enumerable is infinitely long.)

The flipside to this advice is that each time you enumerate such an IEnumerable the work to evaluate it has to be done afresh. So you need to decide for each case whether it is better to work with the lazily evaluated IEnumerable or to realize it into a List, Set, Dictionary or whatnot.

Related Posts:

  1. IEnumerable vs List – What to Use? How do they work?
  2. Linq select objects in list where exists IN (A,B,C)
  3. Quickest way to compare two generic lists for differences
  4. Group by in LINQ
  5. Join/Where with LINQ and Lambda
  6. LINQ’s Distinct() on a particular property
  7. How to Sort a List by a property in the object
  8. finding the maximum length of lists in c#
  9. Sequence contains no elements?
  10. LEFT OUTER JOIN in LINQ
  11. How can I find a specific element in a List?
  12. ToList().ForEach in Linq
  13. Extension methods must be defined in a non-generic static class
  14. Check if list is empty in C#
  15. C# List to string with delimiter
  16. Convert a list of strings to a single string
  17. Proper Linq where clauses
  18. Extension methods must be defined in a non-generic static class
  19. How to initialize a list of strings (List) with many string values
  20. Convert Linq Query Result to Dictionary
  21. Get single value from dictionary by key
  22. Are 2 dimensional Lists possible in c#?
  23. Sequence contains no matching element
  24. How to easily initialize a list of Tuples?
  25. Merge two (or more) lists into one, in C# .NET
  26. Converting from IEnumerable to List
  27. finding the maximum length of lists in c#
  28. How to split() a delimited string to a List
  29. Cannot implicitly convert type ‘System.Collections.Generic.List< >‘ to ‘System.Collections.Generic.IList< >‘
  30. How to add List<> to a List<> in asp.net [duplicate]
  31. Sort list by field (C#)
  32. Remove duplicates from a List in C#
  33. ‘namespace’ but is used like a ‘type’
  34. How do I concatenate two arrays in C#?
  35. Convert SQL to LINQ Query
  36. C# Convert List to Dictionary
  37. How do I clone a generic list in C#?
  38. Sequence contains more than one element
  39. LINQ query on a DataTable
  40. Using .Select and .Where in a single LINQ statement
  41. Linq: GroupBy, Sum and Count
  42. What is IP address ‘::1’?
  43. What is the yield keyword used for in C#?
  44. C# compiler error: “not all code paths return a value”
  45. C# equivalent of C++ map
  46. The page was not displayed because the request entity is too large on IIS
  47. Export Pervasive to MySQL (C#)
  48. Why use the params keyword?
  49. What does plus equals(+=) operator means here?
  50. The request was aborted: Could not create SSL/TLS secure channel
  51. The located assembly’s manifest definition does not match the assembly reference
  52. OnTriggerEnter not working at Unity3D
  53. The requested resource does not support HTTP method ‘GET’
  54. Rename a file in C#
  55. What does mscorlib stand for?
  56. What is the best way to iterate over a dictionary?
  57. What is and how to fix System.TypeInitializationException error?
  58. Adding values to a C# array
  59. What does {0} mean when found in a string in C#?
  60. Collection was modified; enumeration operation may not execute
  61. Cross-thread operation not valid: Control accessed from a thread other than the thread it was created on
  62. Unity – Gameobject look at mouse
  63. What does the @ symbol before a variable name mean in C#?
  64. What is the C# version of VB.net’s InputDialog?
  65. How to add comments into a Xaml file in WPF?
  66. How do I target @Model within a src of an image tag?
  67. How to round up in c#
  68. Escape double quotes in a string
  69. How to do constructor chaining in C#
  70. What represents a double in sql server?
  71. How do you get the index of the current iteration of a foreach loop?
  72. Expression denotes a `type’, where a `variable’, `value’ or `method group’ was expected UNITY3D
  73. How do I restart my C# WinForm Application?
  74. WSACancelBlockingCall exception
  75. Padding is invalid and cannot be removed?
  76. Why is it that “No HTTP resource was found that matches the request URI” here?
  77. Best way to reverse a string
  78. C# Foreach statement does not contain public definition for GetEnumerator
  79. Does C++11 have C#-style properties?
  80. How do I exit a foreach loop in C#?
  81. Fastest way to remove first char in a String
  82. How to convert datetime format to date format in crystal report using C#?
  83. Most efficient way to remove special characters from string
  84. When do we use ANTLR
  85. How would you count occurrences of a string (actually a char) within a string?
  86. Rotate object in Unity 3D
  87. C# equivalent to Java’s charAt()?
  88. How to play a sound in C#, .NET
  89. How to resolve file being used by another process?
  90. How to crop an image using C#?
  91. How do you wait for input on the same Console.WriteLine() line?
  92. Why doesn’t C# have header files? Will the namespace take care of everything?
  93. How to avoid a System.Runtime.InteropServices.COMException?
  94. Define: What is a HashSet?
  95. Convert string to decimal, keeping fractions
  96. Format of the initialization string does not conform to specification starting at index 0
  97. How can I generate random alphanumeric strings?
  98. How do you do a deep copy of an object in .NET? 
  99. Cannot declare instance members in a static class in C#
  100. How to convert HTML to PDF using iTextSharp

Leave a Comment