Hi to all .NET masters,
My question is about caching patterns in ASP.NET 3.5/4.0. In my web project I am using EF4 as my data model layer, Repository as DAL and Service Layer for the business logic.
I want to know which Data Caching would be best appropriate for this type of project.
I thought about using SqlCacheDependency with pooling but this one would only work for caching whole tables, and hence is not really useful.
Another option is using SqlCacheDependency with notifications, but it seems that it has problems with queries which are being produced by the EF4.
Last option I though is using simple HttpContext.Cache. But this way it would be really hard to invalidate cache when data is modified from various applications and not only the main web application.
I would really like to know what do experts
use in their big projects. Please notice that all layers I presented are in different projects in my main solution.