ASP.Net Caching

Question

How can we do Database driven caching in ASP.Net.

Answer 1

Oh it is really easy. You need to Use de Cache object in ASP.NET. It is different from the Session object since th information stored in the Cache object is global and not per session. You can activate de Cache per Page or per Web control. I prefer per Web Control since you have a finer control over what data is cached.

If you need Database driven caching just store your business objects in the Cache object and include logic in your page in case it expires.

example

protected void Page_Load(object sender, Eventargs e){
  BusinessObject bo = Cache["SomeBO"] as BusinessObject;
  if (bo == null){
    //reload bo from database since data expired...
  }

}

check this link: http://msdn.microsoft.com/en-us/kb/kb00323290.aspx

Answer 2

You can use the SqlDependency or SqlCacheDependency objects.