You define a LINQ query to retrieve entities from your database. You want to reuse the query result set multiple times without executing the query each time this result set is accessed.

What should you do?

To avoid executing a query multiple times, convert the results into any number of standard collection classes. It is easy to convert the results into a list or array using the standard query operators ToList() and ToArray().

You can use a compiled query to increase performance, but using a compiled query still executes the query each time.