Am I misunderstanding LINQ to SQL .AsEnumerable()?

by

Calling AsEnumerable() does not execute the query, enumerating it does.

IQueryable is the interface that allows LINQ to SQL to perform its magic. IQueryable implements IEnumerable so when you call AsEnumerable(), you are changing the extension-methods being called from there on, ie from the IQueryable-methods to the IEnumerable-methods (ie changing from LINQ to SQL to LINQ to Objects in this particular case). But you are not executing the actual query, just changing how it is going to be executed in its entirety.

To force query execution, you must call ToList().

More Related Contents:

  1. LINQ – Left Join, Group By, and Count
  2. LINQ Where Ignore Accentuation and Case
  3. Operation could destabilize the runtime?
  4. How to select only the records with the highest date in LINQ
  5. DISTINCT() and ORDERBY issue
  6. Max or Default?
  7. How do I do a left outer join with Dynamic Linq?
  8. Get sum of two columns in one LINQ query
  9. Last and LastOrDefault not supported
  10. Linq where column == (null reference) not the same as column == null
  11. How to write this nested foreach loop query in LINQ?
  12. Returning IEnumerable vs. IQueryable
  13. What is the syntax for an inner join in LINQ to SQL?
  14. Linq: GroupBy, Sum and Count
  15. Update all objects in a collection using LINQ
  16. Understanding .AsEnumerable() in LINQ to SQL
  17. How to compare only Date without Time in DateTime types in Linq to SQL with Entity Framework?
  18. Linq query with nullable sum
  19. Find all child controls of specific type using Enumerable.OfType() or LINQ
  20. Join and Include in Entity Framework
  21. LINQ to SQL using GROUP BY and COUNT(DISTINCT)
  22. Remove Item in Dictionary based on Value
  23. Remove item from list based on condition
  24. How does PredicateBuilder work
  25. Linq “Could not translate expression… into SQL and could not treat it as a local expression.”
  26. How to convert DataTable to class Object?
  27. How do I compose Linq Expressions? ie Func
  28. Accessing System Databases/Tables using LINQ to SQL?
  29. If Else in LINQ
  30. C# Linq to SQL: How to express “CONVERT([…] AS INT)”?

Leave a Comment