What is the effect of AsEnumerable() on a LINQ Entity?

by

AsEnumerable() is effectively a cast to IEnumerable<T>, which makes member resolution find members of Enumerable instead of Queryable. It’s usually used when you want to force part of a query to run as SQL (or similar), and the remainder to run using LINQ to Objects.

See my Edulinq blog post on it for more information.

Now you’ve actually got two calls to AsEnumerable. I can see how removing the first but not the second could cause problems, but have you tried removing both?

var results = from p in pollcards
              join s in spoils
                 on new { Ocr = p.OCR, fileName = p.PrintFilename } 
                 equals new { Ocr = s.seq, fileName = s.inputFileName }
              where p.Version == null
              orderby s.fileOrdering, s.seq
              select new ReportSpoilsEntity
              {
                  seq = s.seq,
                  fileOrdering = s.fileOrdering,
                  inputFileName = s.inputFileName,
                  Ocr = p.OCR,
                  ElectorName = p.ElectorName
              };

More Related Contents:

  1. What is the use of Enumerable.Zip extension method in Linq?
  2. Why does Enumerable.All return true for an empty sequence? [duplicate]
  3. Data binding directly to a store query (DbSet, DbQuery, DbSqlQuery) is not supported
  4. LINQ to Entities does not recognize the method ‘Int32 Parse(System.String)’ method, and this method cannot be translated into a store expression
  5. Get All instead of FirstOrDefault
  6. How to write this nested foreach loop query in LINQ?
  7. Group by in LINQ
  8. What is the best way to modify a list in a ‘foreach’ loop?
  9. Linq: GroupBy, Sum and Count
  10. Find an item in a list by LINQ
  11. Reading a file line by line in C#
  12. ToList()– does it create a new list?
  13. Combination of List
  14. The ‘:’ character, hexadecimal value 0x3A, cannot be included in a name
  15. How to use the IEqualityComparer
  16. How can I get the index of an item in a list in a single step?
  17. Performance of LINQ Any vs FirstOrDefault != null
  18. Convert anonymous type to class
  19. Comparing 2 objects and retrieve a list of fields with different values
  20. Dynamic table name in linq [duplicate]
  21. C# Linq where clause as a variable
  22. Find if listA contains any elements not in listB
  23. Find all child controls of specific type using Enumerable.OfType() or LINQ
  24. LINQ to SQL using GROUP BY and COUNT(DISTINCT)
  25. Remove item from list based on condition
  26. Last and LastOrDefault not supported
  27. Convert / Cast IEnumerable to IEnumerable
  28. Where can I find the System.Linq.Dynamic dll?
  29. C# Searching for files and folders except in certain folders
  30. What is the difference between LINQ ToDictionary and ToLookup

Leave a Comment