The result of a query cannot be enumerated more than once

by

Try explicitly enumerating the results by calling ToList().

Change

foreach (var item in query)

to

foreach (var item in query.ToList())

More Related Contents:

  1. Entity Framework Timeouts
  2. Entity Framework/Linq EXpression converting from string to int
  3. LEFT JOIN in LINQ to entities?
  4. “The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities” – stumped!
  5. Creating dynamic queries with entity framework
  6. One DbContext per web request… why?
  7. There is already an open DataReader associated with this Command which must be closed first
  8. Validation failed for one or more entities. See ‘EntityValidationErrors’ property for more details [duplicate]
  9. ‘Contains()’ workaround using Linq to Entities?
  10. How to use a string to create a EF order by expression?
  11. The mapping of CLR type to EDM type is ambiguous with EF 6 & 5?
  12. Does Entity Framework 4 Code First have support for identity generators like NHibernate?
  13. Dynamic MySQL database connection for Entity Framework 6
  14. Entity Framework 6 Code First Custom Functions
  15. LINQ to Entities does not recognize the method ‘System.Web.Mvc.FileResult’
  16. Order by dynamic parameter
  17. Dynamic table name in linq [duplicate]
  18. Why is Asp.Net Identity IdentityDbContext a Black-Box?
  19. Find all child controls of specific type using Enumerable.OfType() or LINQ
  20. Join and Include in Entity Framework
  21. Setting the default value of a DateTime Property to DateTime.Now inside the System.ComponentModel Default Value Attrbute
  22. Log Queries executed by Entity Framework DbContext
  23. The data source does not support server-side data paging
  24. Remove item from list based on condition
  25. “Context cannot be used while the model is being created” exception with ASP.NET Identity
  26. How to group by DateTime.Date in EntityFramework
  27. Linq Query keeps throwing “Unable to create a constant value of type System.Object….”, Why?
  28. How to include() nested child entity in linq
  29. LINQ Query to Convert string to datetime
  30. Entity Framework select one of each group by date

Leave a Comment