Labels

Wednesday, April 23, 2008

Summarizing - Using SQL Server for ASP.Net session state

Hi,

Few days back, I had a post on ‘Using SQL Server for ASP.Net session state. In this post, I have exercised against the Session Information retention in various modes. Here is the summary of the post.

In Proc

Relogin after Signout

Depends on how the Signout has occurred. i.e

· Case 1 - Either only one statement is used (as below) or

· Case 2 - Both statements are used.

System.Web.Security.FormsAuthentication.SignOut();

//Session.Abandon();

Case 2: No Session information is maintained.

Case 1: Session information is maintained.

Session TimeOut

No Session information is maintained

Page Close (Using Cross button)

No Session information is maintained

For reference – See my Post.

SQLServer – Default Mode

Relogin after Signout

Depends on how the Signout has occurred. i.e

· Case 1 - Either only one statement is used (as below) or

· Case 2 - Both statements are used.

System.Web.Security.FormsAuthentication.SignOut();

//Session.Abandon();

Case 2: No Session information is maintained.

Case 1: Session information is maintained with conditions apply as below.

When Signout, Flow will take back to Login page window – After Login (Using the same window), the User will found the same session state, which was before the Sign out. i.e The Session Information will be restored.

But if new window is used to relogin the Session state will not be restored and user will find a fresh session

Session TimeOut

Orthadiction to Inproc. i.e Session information is maintained.

Page Close (Using Cross button)

Same as InProc.

SQLServer – Custom Mode

Relogin after Signout

Depends on how the Signout has occurred. i.e

· Case 1 - Either only one statement is used (as below) or

· Case 2 - Both statements are used.

System.Web.Security.FormsAuthentication.SignOut();

//Session.Abandon();

Case 2: No Session information is maintained.

Case 1: Session information is maintained regardless of same or new window. i.e

When Signout, Flow will take back to Login page window – After Login (Using the same window), the User will found the same session state, which was before the Sign out. i.e The Session Information will be restored.

But even if new window is used to relogin the Session state will be restored.

i.e Whether new or same window is used for relogin, the Session information wil be resored.

Session TimeOut

Orthadiction to Inproc. i.e Session information is maintained.

Page Close (Using Cross button)

Same as InProc.

Hope this helps.

Reference Post: Post1 & Post 2

Thanks & Regards,

Arun Manglick || Tech Lead

No comments:

Post a Comment