Asp .NET MVC OutputCache stored in SQL db

Question

How can you configure OutputCache in Asp .NET MVC 2 (with .NET 3.5) so that the cached data is stored in SQL database?

would this not negate the reason for caching in the first place? — dove
– dove, Commented Jan 25, 2011 at 11:55
It depends. In my case the web application calls remote web service and every invocation takes up to 10 seconds. — mgamer
– mgamer, Commented Jan 25, 2011 at 11:58
would you not want to cache the results from the remote web service then rather then the output from your app? — Sam Holder
– Sam Holder, Commented Jan 25, 2011 at 12:06
@SamHolder, I absolutely agree with you but there are some conditions which force us to cache output from the web app rather than only the output from the remote web service. Thanks for your pertinent comments nonetheless. — mgamer
– mgamer, Commented Jan 25, 2011 at 12:10

Darin Dimitrov · Accepted Answer · 2011-01-25 13:07:59Z

1

This could be achieved in ASP.NET 4.0 where you can write a custom cache provider. Quote from this very same blog post:

One limitation of output caching with ASP.NET V1->V3.5, though, is that the cache store itself is not extensible – and the cached content always has to be stored in-memory.

Time to upgrade :-)

answered Jan 25, 2011 at 13:07

Darin Dimitrov

1.0m277 gold badges3.3k silver badges3k bronze badges

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

Collectives™ on Stack Overflow

Asp .NET MVC OutputCache stored in SQL db

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related