Select Multiple Fields from List in Linq

by

Anonymous types allow you to select arbitrary fields into data structures that are strongly typed later on in your code:

var cats = listObject
    .Select(i => new { i.category_id, i.category_name })
    .Distinct()
    .OrderByDescending(i => i.category_name)
    .ToArray();

Since you (apparently) need to store it for later use, you could use the GroupBy operator:

Data[] cats = listObject
    .GroupBy(i => new { i.category_id, i.category_name })
    .OrderByDescending(g => g.Key.category_name)
    .Select(g => g.First())
    .ToArray();

More Related Contents:

  1. Split List into Sublists with LINQ
  2. Preserving order with LINQ
  3. Split a collection into `n` parts with LINQ? [duplicate]
  4. How can I return an anonymous type from a method?
  5. Get all checked nodes of a treeview
  6. How to flatten tree via LINQ?
  7. Distinct by property of class with LINQ [duplicate]
  8. Using LINQ to concatenate strings
  9. Dynamically generate LINQ queries
  10. LINQ to SQL and a running total on ordered results
  11. How to get values from IGrouping
  12. LEFT JOIN in LINQ to entities?
  13. Can I specify my explicit type comparator inline?
  14. Find the most occurring number in a List
  15. Entity Framework (.NET Full Framework) Ordering Includes [duplicate]
  16. How to compare only date components from DateTime in EF?
  17. Except has similar effect to Distinct?
  18. Entity Framework 6 Code First Custom Functions
  19. LINQ to Entities does not recognize the method ‘System.Web.Mvc.FileResult’
  20. Order by dynamic parameter
  21. How to tell if an IEnumerable is subject to deferred execution?
  22. C#: How to convert a list of objects to a list of a single property of that object?
  23. linq group by contiguous blocks
  24. how do I chunk an enumerable?
  25. Code equivalent to the ‘let’ keyword in chained LINQ extension method calls
  26. Select all columns after JOIN in LINQ
  27. Sorting a List
  28. linq: order by random
  29. Select distinct rows from datatable in Linq
  30. Is Injection Possible through Dynamic LINQ?

Leave a Comment