IsInRole Cache

Hi.

I am creating my own "Roles".

I have a table of Roles in the DB and a table which holds which users belong to which roles.

I then want the ability in ASP.NET to see if a user belongs to a role using IsInRole(RoleName);

I understand I need to create a CustomPrincipal and implement the IPrincipal interface and for the IsInRole method, create the procedure I want to validate the parameter against a datasource.

Problem here is performance where it means I have to go to the DB everytime to see if the user (stored in session) belongs to that role.

Is there a way to cache the data for checking to see if the current user is in a role?

Maybe im missing something or a better way of doing this? I must stress that I want to use the User.IsInRole("...") method.

Re: IsInRole Cache

string username = (Login1.FindControl("UserName") as TextBox).Text;
if (Roles.IsUserInRole(username, "YourRoleHere"))
Response.Redirect("~/member/default.aspx");

Re: IsInRole Cache

That does not answer the question AT ALL.

Re: IsInRole Cache

Ideally you should create a custom Role Provider. You can find plenty of articles how to do that, but you can also download the code for the existing providers from download.microsoft.com/download/a/b/3/ab3c284b-dc9a-473d-b7e3-33bacfcc8e98/ProviderToolkitSamples.msi and just modify it.

ASP.NET improves performance by caching the roles in a cookie. This cookie is set when the user logs in and is passed to the application upo each request. The role manager can then check the cookie instead of the database (but check the db if no cookie exists). Alternatively, within the provider, you could cache the roles per user in the ASP.NET Cache object.