How to get first record in each group using Linq

by 
var result = input.GroupBy(x => x.F1, (key,g) => g.OrderBy(e => e.F2).First());

More Related Contents:

  1. Dynamic where clause (OR) in Linq to Entities
  2. How to create LINQ Expression Tree to select an anonymous type
  3. Linq-to-Entities Join vs GroupJoin
  4. ‘Contains()’ workaround using Linq to Entities?
  5. “A lambda expression with a statement body cannot be converted to an expression tree”
  6. Bulk-deleting in LINQ to Entities
  7. The type of one of the expressions in the join clause is incorrect in Entity Framework
  8. Entity framework left join
  9. C# – code to order by a property using the property name as a string [duplicate]
  10. LEFT JOIN in LINQ to entities?
  11. How to compare only date components from DateTime in EF?
  12. “The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities” – stumped!
  13. Serialize an object to XElement and Deserialize it in memory
  14. How to tell if an IEnumerable is subject to deferred execution?
  15. How do I perform Date Comparison in EF query?
  16. Linq to Entity Join table with multiple OR conditions
  17. ‘Date’ is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported
  18. String.IsNullOrWhiteSpace in LINQ Expression
  19. Dynamic query with OR conditions in Entity Framework
  20. Calling a SQL User-defined function in a LINQ query
  21. linq to entities vs linq to objects – are they the same?
  22. The LINQ expression node type ‘ArrayIndex’ is not supported in LINQ to Entities
  23. How do you construct a LINQ to Entities query to load child objects directly, instead of calling a Reference property or Load()
  24. Only parameterless constructors and initializers are supported in LINQ to Entities message
  25. LINQ to Entities group-by failure using .date
  26. Is Injection Possible through Dynamic LINQ?
  27. Check if two lists are equal
  28. linq distinct or group by multiple properties
  29. LINQ to SQL using GROUP BY and COUNT(DISTINCT)
  30. Linq Select 5 items per Iteration [duplicate]

Leave a Comment