clear OutputCache VaryByParam using code?

[Les Caudle]

When displaying a database driven product page, I cache the page using:

<%@ OutputCache Duration="86400" VaryByParam="ProductID" %>

which works fine UNLESS I change the pricing or description for that page in the
database.

Then, I need to clear the cache (either for that specific productID- or for the
aspx page and all the ProductID's it displays).

How can I clear the cache under program control?
--
Thanks in advance, Les Caudle

[Les Caudle]

Yes, I realize that - but that is not a good solution.

As the data on the page is tied to a database, I need a way to automatically
clear this cache when the database has changed.

By automatically, I mean using code, not modifying a page by hand in an editor -
or even changing the timestamp on the file (which requires certain permissions)

Somewhere inside of .NET, this cache lives - and there must be a way to clear
it..

Regards, Les Caudle

On Fri, 25 Jun 2004 08:50:10 -0700, "sunshine"
<su******@discussions.microsoft.com> wrote:

I don't know it this is a proper way to do it, but I found that when I alter the page and resave it (you can just type anything and undo it for the sake of saving), the cache starts from fresh again...

"Les Caudle" wrote:

When displaying a database driven product page, I cache the page using:

<%@ OutputCache Duration="86400" VaryByParam="ProductID" %>

which works fine UNLESS I change the pricing or description for that page in the
database.

Then, I need to clear the cache (either for that specific productID- or for the
aspx page and all the ProductID's it displays).

How can I clear the cache under program control?
--
Thanks in advance, Les Caudle

[sunshine]

What you're talking about is database dependency.... Asp.net does not support this natively unless your db is file based (it supports file dedendencies). But it can be done. Refer to: http://www.gotdotnet.com/team/rhoward/

"Les Caudle" wrote:

Yes, I realize that - but that is not a good solution.

As the data on the page is tied to a database, I need a way to automatically
clear this cache when the database has changed.

By automatically, I mean using code, not modifying a page by hand in an editor -
or even changing the timestamp on the file (which requires certain permissions)

Somewhere inside of .NET, this cache lives - and there must be a way to clear
it..

Regards, Les Caudle

On Fri, 25 Jun 2004 08:50:10 -0700, "sunshine"
<su******@discussions.microsoft.com> wrote:

I don't know it this is a proper way to do it, but I found that when I alter the page and resave it (you can just type anything and undo it for the sake of saving), the cache starts from fresh again...

"Les Caudle" wrote:

When displaying a database driven product page, I cache the page using:

<%@ OutputCache Duration="86400" VaryByParam="ProductID" %>

which works fine UNLESS I change the pricing or description for that page in the
database.

Then, I need to clear the cache (either for that specific productID- or for the
aspx page and all the ProductID's it displays).

How can I clear the cache under program control?
--
Thanks in advance, Les Caudle