Monday, December 28, 2009

The query results cannot be enumerated more than once

Title: Error: The query results cannot be enumerated more than once

Details: Ever tried using Linq DataContext model ( using the dbml file ) and try iterating from the return type ISingleResult ? If so, you might have got the error for sure. So, the simple way to do it is to obtain the results to a generic list as shown below.

Code: Consider that GetUserDetails returns a ISingleResult generic list type of GetUserDetailsResult

List<GetUserDetailsResult> results = GetUserDetails().ToList();
foreach (GetUserDetailsResult result in results)
{
// Write your code here...
}

2 comments:

Anonymous said...

Thank you. Your simple "ToList" solution fixed my headache.

Anonymous said...

Thank u for the small solution for big problem.