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

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 2

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

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