Richey, thanks a lot for the reply. I have been waiting for some thoughts from others on this forum. Your answer cleared a lot of my doubt and assumption. So please let me clarify if i understand what you said correctly.
Richey
When you store the data in session with SQL Server session state mode the data will be encrypted.
Based on the above quote, it means, for example, I created Session("ClientID"), so the value of the session is ecrypted in the AspStateTempSession table, is it correct? Is it encrypted in the SessionItemShort column?
The reason that I tried to understand this is because I have read a post by one member (http://forums.asp.net/t/1794432.aspx/2/10?Need+your+advice+on+passing+values+between+pages+)
saying that storing the session variable in SQL server will preserve the value even after session time out. But it doesn't preserve it in my case. After the time out, that expired session row is deleted from the table.
Is there a way I can preserve the session variables that I want to keep after session time out?
asplearning
Participant
909 Points
952 Posts
Re: Need your advice on storing session variable in SQLServer
May 07, 2012 11:01 PM|LINK
Richey, thanks a lot for the reply. I have been waiting for some thoughts from others on this forum. Your answer cleared a lot of my doubt and assumption. So please let me clarify if i understand what you said correctly.
Based on the above quote, it means, for example, I created Session("ClientID"), so the value of the session is ecrypted in the AspStateTempSession table, is it correct? Is it encrypted in the SessionItemShort column?
The reason that I tried to understand this is because I have read a post by one member (http://forums.asp.net/t/1794432.aspx/2/10?Need+your+advice+on+passing+values+between+pages+) saying that storing the session variable in SQL server will preserve the value even after session time out. But it doesn't preserve it in my case. After the time out, that expired session row is deleted from the table.
Is there a way I can preserve the session variables that I want to keep after session time out?
Thanks.