Entity Framework: There is already an open DataReader associated with this Command

by

It is not about closing connection. EF manages connection correctly. My understanding of this problem is that there are multiple data retrieval commands executed on single connection (or single command with multiple selects) while next DataReader is executed before first one has completed the reading. The only way to avoid the exception is to allow multiple nested DataReaders = turn on MultipleActiveResultSets. Another scenario when this always happens is when you iterate through result of the query (IQueryable) and you will trigger lazy loading for loaded entity inside the iteration.

More Related Contents:

  1. Linq: adding conditions to the where clause conditionally
  2. Entity framework linq query Include() multiple children entities
  3. How to filter nested collection Entity Framework objects?
  4. LINQ to Entities does not recognize the method ‘System.String Format(System.String, System.Object, System.Object)’
  5. Only initializers, entity members, and entity navigation properties are supported
  6. Convert String to Int in EF 4.0
  7. Linq-to-entities – Include() method not loading
  8. Entity Framework – “Unable to create a constant value of type ‘Closure type’…” error
  9. Instantiating a context in LINQ to Entities
  10. conditional include in linq to entities?
  11. EF 4: Removing child object from collection does not delete it – why?
  12. Linq To Entities – how to filter on child entities
  13. Entity Framework, Code First and Full Text Search
  14. LINQ OrderBy not ordering .. changing nothing .. why?
  15. Simple Linq query has duplicated join against same table?
  16. LINQ to Entities does not recognize the method
  17. Unable to create a constant value of type Only primitive types or enumeration types are supported in this context
  18. How to view LINQ Generated SQL statements?
  19. LINQ across multiple databases
  20. Establish a link between two lists in linq to entities where clause
  21. How do I add ROW_NUMBER to a LINQ query or Entity?
  22. A specified Include path is not valid. The EntityType does not declare a navigation property with the name *
  23. How to group by on 2 child entities and get total of both this child entities?
  24. thread messaging system database schema design
  25. Converting flattened hierarchical data from SQL Server into a structured JSON object with C#/Linq
  26. How to dynamically add OR operator to WHERE clause in LINQ
  27. Calling a SQL User-defined function in a LINQ query
  28. Greater Than Condition in Linq Join
  29. How do I write this cross apply query in LINQ-to-SQL?
  30. LINQ: How to convert the nested hierarchical object to flatten object

Leave a Comment