Caching until data changes in ASP.NET MVC & Entity Framework 4.1

Question

I currently use the repository pattern in my ASP.NET MVC 3 app.

I use OutputCache to lessen the load on my database by decorating my controller methods with a data annotation similar to this:

[OutputCache(Duration = 3600, VaryByParam = "userName")]

Ultimately, what I'd like to achieve is a level of caching whereby the data is cached until it is updated (i.e. it changes). I am using Entity Framework 4.1 for ORM.

What would be the recommended way to approach this using my selected stack?

How will you know when your data is updated? If you are assuming that you will manage the state of an object by using your controllers you could manipulate the cache: stackoverflow.com/questions/11585/… — Nick Bork
– Nick Bork, Commented Apr 3, 2012 at 19:20

Rowan Freeman · Accepted Answer · 2013-12-02 02:53:52Z

4

see http://msdn.microsoft.com/en-us/library/hdxfb6cy(v=vs.85).aspx

There's a SqlDependency attribute :-)

edited Dec 2, 2013 at 2:53

Rowan Freeman

16.5k12 gold badges72 silver badges105 bronze badges

answered Apr 3, 2012 at 19:27

Smartkid

1,8423 gold badges26 silver badges34 bronze badges

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

Comments

Brian Mains · Accepted Answer · 2012-04-03 19:22:43Z

1

Check out this article: http://msdn.microsoft.com/en-us/magazine/gg650661.aspx

A custom provider would be the only way.

answered Apr 3, 2012 at 19:22

Brian Mains

50.8k35 gold badges156 silver badges261 bronze badges

Collectives™ on Stack Overflow

Caching until data changes in ASP.NET MVC & Entity Framework 4.1

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related