CODEWITHSUNDEEP
asp.net-mvcasp.net-mvc-3cachingentity-framework-4.1outputcache
Nick
Nick

Reputation: 5892

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

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?

Upvotes: 7

Views: 2714

Answers (2)

Smartkid
Smartkid

Reputation: 1842

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

There's a SqlDependency attribute :-)

Upvotes: 4

Brian Mains
Brian Mains

Reputation: 50728

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

A custom provider would be the only way.

Upvotes: 1

Related Questions