Distinct in Linq based on only one field of the table

by

Try this:

table1.GroupBy(x => x.Text).Select(x => x.FirstOrDefault());

This will group the table by Text and use the first row from each groups resulting in rows where Text is distinct.

More Related Contents:

  1. convert sql query into lambda expression [closed]
  2. LINQ to Entities does not recognize the method ‘System.String ToString()’ method, and this method cannot be translated into a store expression
  3. Is there a good LINQ way to do a cartesian product?
  4. LINQ to SQL – Left Outer Join with multiple join conditions
  5. linq case statement
  6. LINQ to SQL multiple tables left outer join
  7. Equivalent of SQL ISNULL in LINQ?
  8. Could not find an implementation of the query pattern
  9. Wildcard search for LINQ
  10. Get an IDataReader from a typed List
  11. Local sequence cannot be used in LINQ to SQL implementation of query operators except the Contains() operator
  12. Entity Framework. Delete all rows in table
  13. Use linq to generate direct update without select
  14. Join and Include in Entity Framework
  15. How to make LINQ execute a (SQL) LIKE range search
  16. Calling a SQL User-defined function in a LINQ query
  17. Issues Doing a String Comparison in LINQ
  18. Convert SQL to LINQ Query [closed]
  19. Linq To Sql compare Time only
  20. Linq union usage?
  21. Distinct by property of class with LINQ [duplicate]
  22. How to Bulk Update records in Entity Framework?
  23. Linq order by, group by and order by each group?
  24. Find character with most occurrences in string?
  25. SQL update statement in C#
  26. Checking for empty or null JToken in a JObject
  27. SQL/C# – Best method for executing a query
  28. Index (zero based) must be greater than or equal to zero
  29. Select all columns after JOIN in LINQ
  30. Linq – Top value from each group

Leave a Comment