Why use AsQueryable() instead of List()?

by

AsQueryable just creates a query, the instructions needed to get a list. You can make futher changes to the query later such as adding new Where clauses that get sent all the way down to the database level.

AsList returns an actual list with all the items in memory. If you add a new Where cluse to it, you don’t get the fast filtering the database provides. Instead you get all the information in the list and then filter out what you don’t need in the application.

So basically it comes down to waiting until the last possible momment before committing yourself.

More Related Contents:

  1. Dynamic LINQ OrderBy on IEnumerable / IQueryable
  2. Returning IEnumerable vs. IQueryable
  3. Using IQueryable with Linq
  4. Differences between IQueryable, List, IEnumerator?
  5. What is the purpose of AsQueryable()?
  6. Simultaneous equations in C# LINQ [closed]
  7. Get All instead of FirstOrDefault
  8. LINQ to Entities does not recognize the method ‘System.String ToString()’ method, and this method cannot be translated into a store expression
  9. Find an item in a list by LINQ
  10. How to Count Duplicates in List with LINQ
  11. How do I find the text within a div in the source of a web page using C#
  12. LINQ Select Distinct with Anonymous Types
  13. LINQ Orderby Descending Query
  14. Equivalent of SQL ISNULL in LINQ?
  15. How to get the closest number from a List with LINQ?
  16. Multiple Order By with LINQ [duplicate]
  17. Extension methods syntax vs query syntax
  18. Conversion from List to array T[]
  19. ILookup vs. IGrouping
  20. Enumerating Collections that are not inherently IEnumerable?
  21. Comparing 2 objects and retrieve a list of fields with different values
  22. C# Linq where clause as a variable
  23. How to merge a list of lists with same type of items to a single list of items?
  24. Split an IEnumerable into fixed-sized chunks (return an IEnumerable where the inner sequences are of fixed length) [duplicate]
  25. How to set property value using Expressions? [duplicate]
  26. Should the order of LINQ query clauses affect Entity Framework performance?
  27. Transform IEnumerable asynchronously by awaiting each task
  28. Map two lists into a dictionary in C#
  29. How to check if all list items have the same value and return it, or return an “otherValue” if they don’t?
  30. Can I use Linq’s Except() with a lambda expression comparer?

Leave a Comment