Re-cache when new records are added

[WebMatrix]

Hello!

I am working on a web application with Windows Authentication.
In WindowsAuthentication_Authenticate event of Global.asax file a user is
Authenticated and User/Roles Array is loaded into GenericPrincipal object. So
User.IsInRole("somerole") can be used. User/Roles Array first retrieved from
DB through a stored procedure then cached.
So when new users with roles are added to DB table,
User.IsInRole("somerole") still uses cached array. It doesn't change untill
"iisreset".
Is there way to re-cache upon new record creation? Keep in mind data comes
from a SQL stored procedure, so table dependency is not an option, or is it?
Thank you!

Expand AllCollapse All

[Joe Fallon]

I implemented DB Cache Dependency in ASP.Net 1.1.
There is a great article that describes how to do it here:
http://www.eggheadcafe.com/articles/20040607.asp
(See my comments at the bottom of this article for improvements in the
published technique.)

This is a great tool to have in your bag of tricks!
--
Joe Fallon

"WebMatrix" <We*******@discussions.microsoft.com> wrote in message
news:E5**********************************@microsof t.com...

Hello!

I am working on a web application with Windows Authentication.
In WindowsAuthentication_Authenticate event of Global.asax file a user is
Authenticated and User/Roles Array is loaded into GenericPrincipal object.
So
User.IsInRole("somerole") can be used. User/Roles Array first retrieved
from
DB through a stored procedure then cached.
So when new users with roles are added to DB table,
User.IsInRole("somerole") still uses cached array. It doesn't change
untill
"iisreset".
Is there way to re-cache upon new record creation? Keep in mind data comes
from a SQL stored procedure, so table dependency is not an option, or is
it?
Thank you!

Expand AllCollapse All