What is the purpose of AsQueryable()?

by

There are a few main uses.

  1. As mentioned in other answers, you can use it to mock a queryable data source using an in-memory data source so that you can more easily test methods that will eventually be used on a non-enumerable based IQueryable.

  2. You can write helper methods for manipulating collections that can apply to either in-memory sequences or external data sources. If you write your help methods to use IQueryable entirely you can just use AsQueryable on all enumerables to use them. This allows you to avoid writing two separate versions of very generalized helper methods.

  3. It allows you to change the compile time type of a queryable to be an IQueryable, rather than some more derived type. In effect; you’d use it on an IQueryable at the same times that you’d use AsEnumerable on an IEnumerable. You might have an object that implements IQueryable but that also has an instance Select method. If that were the case, and you wanted to use the LINQ Select method, you’d need to change the compile time type of the object to IQueryable. You could just cast it, but by having an AsQueryable method you can take advantage of type inference. This is simply more convenient if the generic argument list is complex, and it is actually necessary if any of the generic arguments are anonymous types.

More Related Contents:

  1. Dynamic LINQ OrderBy on IEnumerable / IQueryable
  2. Returning IEnumerable vs. IQueryable
  3. How to get the index of an element in an IEnumerable?
  4. How to check if IEnumerable is null or empty?
  5. Differences between IQueryable, List, IEnumerator?
  6. Is there an IEnumerable implementation that only iterates over it’s source (e.g. LINQ) once?
  7. Pair-wise iteration in C#, or sliding window enumerator
  8. Map two lists into a dictionary in C#
  9. Group By Multiple Columns
  10. When to use Cast() and Oftype() in Linq
  11. How to get index using LINQ? [duplicate]
  12. How do I concatenate two arrays in C#?
  13. Split a collection into `n` parts with LINQ? [duplicate]
  14. Why is .Contains slow? Most efficient way to get multiple entities by primary key?
  15. Entity Framework/Linq EXpression converting from string to int
  16. How to flatten nested objects with linq expression
  17. Difference between Lookup() and Dictionary(Of list())
  18. How to convert an expression tree to a partial SQL query?
  19. Apply function to all elements of collection through LINQ [duplicate]
  20. How to convert linq results to HashSet or HashedSet
  21. IEqualityComparer for SequenceEqual
  22. Collection was modified; enumeration may not execute error when removing a ListItem from a LIstBox
  23. LINQ – Query syntax vs method chains & lambda [closed]
  24. C# Is there a LINQ to HTML, or some other good .Net HTML manipulation API?
  25. What does this C# code with an “arrow” mean and how is it called?
  26. Linq Query Group By and Selecting First Items
  27. LINQ query to return a Dictionary
  28. How to include() nested child entity in linq
  29. LINQ Query to Convert string to datetime
  30. selecting a property from FirstOrDefault in case FirstOrDefault returns null

Leave a Comment