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?

possible duplicate of [Expire Output Cache ASP.Net MVC](http://stackoverflow.com/questions/376851/expire-output-cache-asp-net-mvc) — jrummell, Apr 03 '12 at 19:20
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: http://stackoverflow.com/questions/11585/clearing-page-cache-in-asp-net — Nick Bork, Apr 03 '12 at 19:20

score 4 · Accepted Answer · edited Dec 02 '13 at 02:53

4

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

There's a SqlDependency attribute :-)

edited Dec 02 '13 at 02:53

Rowan Freeman

15,724
11
69
100

answered Apr 03 '12 at 19:27

Smartkid

1,772
2
25
34

score 1 · Answer 2 · answered Apr 03 '12 at 19:22

1

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

A custom provider would be the only way.

answered Apr 03 '12 at 19:22

Brian Mains

50,520
35
148
257

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

2 Answers2