Why are ToLookup and GroupBy different?

by

why would I ever bother with GroupBy? Why should it exist?

What happens when you call ToLookup on an object representing a remote database table with a billion rows in it?

The billion rows are sent over the wire, and you build the lookup table locally.

What happens when you call GroupBy on such an object?

A query object is built; end of story.

When that query object is enumerated then the analysis of the table is done on the database server and the grouped results are sent back on demand a few at a time.

Logically they are the same thing but the performance implications of each are completely different. Calling ToLookup means I want a cache of the entire thing right now organized by group. Calling GroupBy means “I am building an object to represent the question ‘what would these things look like if I organized them by group?'”

More Related Contents:

  1. Get All instead of FirstOrDefault
  2. How to write this nested foreach loop query in LINQ?
  3. Group by in LINQ
  4. Fluent and Query Expression — Is there any benefit(s) of one over other?
  5. Linq: GroupBy, Sum and Count
  6. Find an item in a list by LINQ
  7. Reading a file line by line in C#
  8. ToList()– does it create a new list?
  9. linq case statement
  10. XDocument containing namespaces
  11. Use own IComparer with Linq OrderBy
  12. Combination of List
  13. The ‘:’ character, hexadecimal value 0x3A, cannot be included in a name
  14. How to use the IEqualityComparer
  15. LINQ Select Distinct with Anonymous Types
  16. Check if two lists are equal
  17. How to get the closest number from a List with LINQ?
  18. Am I misunderstanding LINQ to SQL .AsEnumerable()?
  19. LINQ aggregate and group by periods of time
  20. VB.NET equivalent to C# var keyword [duplicate]
  21. Cannot use a lambda expression as an argument to a dynamically dispatched operation without first casting it to a delegate or expression tree type
  22. C# Linq where clause as a variable
  23. Find if listA contains any elements not in listB
  24. Find all child controls of specific type using Enumerable.OfType() or LINQ
  25. LINQ to SQL using GROUP BY and COUNT(DISTINCT)
  26. Remove item from list based on condition
  27. Last and LastOrDefault not supported
  28. Select multiple fields group by and sum
  29. C# Searching for files and folders except in certain folders
  30. What is the difference between LINQ ToDictionary and ToLookup

Leave a Comment