Caching Entity Framework EntityTypes

Question

I have EntityTypes generated from a database using Entity Framework 4. I would like to use Cache to store some of these EntityTypes for performance reasons. Is it safe to do the following provided that the object will be used for read-only actions:

context.Students.MergeOption = MergeOption.NoTracking;
var students = context.Students.Where(s => s.Name == "Adam").ToList();
Cache["students"] = students;

Thanks.

Craig Stuntz · Accepted Answer · 2010-07-26 13:44:08Z

4

One way is to use the EF cache provider. Another is to use your web server's cache. But make sure you are not prematurely optimizing, or optimizing the wrong thing. Doing so will make your life miserable. It is generally better to optimize a web site with front end caching.

answered Jul 26, 2010 at 13:44

Craig Stuntz

127k12 gold badges257 silver badges275 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Craig Stuntz Over a year ago

Your edit doesn't change my answer. "Optimizing" before profiling is usually wrong.

user342552 Over a year ago

I know that EF cache provider is a solution. However, my code might be simpler to use. So my code is not safe. Is that what you mean?

Collectives™ on Stack Overflow

Caching Entity Framework EntityTypes

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related