Clear cache in SqlDataSource

Question

I need to manually clear the cache on a SqlDataSource with caching enabled. I've tried setting EnableChaching = false, and CacheDuration = 0 (as well as = 1) and none seem to expire the content already in the cache - although they do seem to prevent new SELECTs from being cached.

How do I manually expire that cache?

Thanks.

Answer 1

Make sure your CacheExpirationPolicy is Absolute. Use a non-zero CacheDuration (0 means infinite cache duration).

Answer 2

Disabling caching (EnableCaching = false) and then forcing a new select (SqlDataSourceInstance.Select(new DataSourceSelectArguments())) before re-enabling caching clears the particular combination of CommandText and CommandParameters being selected, so it's a start.

It still retains the cache of the other combinations of queries executed by the SqlDataSource, though, so this doesn't solve all of the problem.

Answer 3

I just started researching this today and came across this post, this look likes the best solution:

Simple way to invalidate SqlDataSource cache programmatically

<asp:SqlDataSource ID="x" EnableCaching="True" CacheKeyDependency="MyCacheDependency"/>

protected void Page_Load(object sender, EventArgs e)
{ // Or somewhere else before the DataBind() takes place
  if (!IsPostBack)
  {
      //prime initial cache key value if never initialized
      if (Cache["MyCacheDependency"] == null)
      {
        Cache["MyCacheDependency"] = DateTime.Now;
      }
  }
}


// Evict cache items with an update in dependent cache:
Cache["MyCacheDependency"] = DateTime.Now;