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