Getting odd/even part of a sequence with LINQ

by

If you’re using LINQ to SQL or LINQ to Entities you should first fully materialize the results into memory:

var oddCategories  = projectsByCat.ToList().Where((c,i) => i % 2 != 0);
var evenCategories = projectsByCat.ToList().Where((c,i) => i % 2 == 0);

It isn’t possible to iterate through results on the database with an indexer without the use of a cursor, which either ORM framework does not do.

More Related Contents:

  1. How to read lines to dictionary with linQ [closed]
  2. Difference Between Select and SelectMany
  3. How to flatten tree via LINQ?
  4. Using LINQ to remove elements from a List
  5. Dynamically generate LINQ queries
  6. Extension methods must be defined in a non-generic static class
  7. Dynamically access table in EF Core 2.0
  8. What’s the hardest or most misunderstood aspect of LINQ? [closed]
  9. LINQ to SQL and a running total on ordered results
  10. How to return anonymous type from c# method that uses LINQ to SQL [duplicate]
  11. linq where list contains any in list
  12. Wildcard search for LINQ
  13. Convert Linq Query Result to Dictionary
  14. Get an IDataReader from a typed List
  15. LINQ Group By Multiple fields -Syntax help
  16. How do I take the Cartesian join of two lists in c#?
  17. LINQ query to find if items in a list are contained in another list
  18. lambda expressions in immediate window for VS2015
  19. How to make LINQ execute a (SQL) LIKE range search
  20. List complex sorting
  21. Good way to get the key of the highest value of a Dictionary in C#
  22. How to sort a dictionary by key
  23. LINQ performance Count vs Where and Count
  24. Issues Doing a String Comparison in LINQ
  25. How to include() nested child entity in linq
  26. Linq OrderBy against specific values
  27. What is the best way to check two List lists for equality in C#
  28. Linq access property by variable
  29. LINQ Query to Convert string to datetime
  30. LINQ query — Data aggregation (group adjacent)

Leave a Comment