zsharp
Reputation: 13756
Can I data cache an IQueryable<> collection?
can this be cached?
Upvotes: 1
Views: 246
Answers (1)
itowlson
Reputation: 74802
No, you would need to enumerate it (e.g. using ToList()) and cache the results of the enumeration. Caching the IQueryable object itself is effectively just caching the query: in that scenario it will still be re-executed every time you try to use the results.
Upvotes: 3
Related Questions
- Acessing and using a cached var for LINQ
- LINQ to SQL DataContext Caching
- Creating a queryable cached result from LINQ
- Caching Linq2Sql data
- Caching linq-to-sql results?
- Caching a LINQ to SQL DataContext
- How do I cache look up data in Linq to Sql, and use that data in a separate DataContext?
- How do I cache query results using LINQ?
- Cache strategies using IQueryables
- How do I cache an IQueryable object?