Session <sessionState mode="SQLServer" ..

Question

4.00/5 (1 vote)

See more:

Hi All,
I m using session in my website. I have used mode=SQLServer, like following.

C#

<sessionstate mode="SQLServer" ....

Now as i save some thing in session, i can see row with value in my sqlserver's 'ASPStateTempSessions' table. But as I set value for session and close the browser i am not able to get the session value back. If it is saved in sqlserver it must comes?

Please help.

Posted 28-Dec-13 3:54am

Brijesh Kr

Updated 28-Dec-13 3:59am

v2

Add a Solution

Comments

ZurdoDev 28-Dec-13 11:10am

What? This is not clear.

Sampath Lokuge 28-Dec-13 11:47am

Check this article : http://www.itorian.com/2012/09/aspnet-session-states-in-sql-server.html

joginder-banger 28-Dec-13 12:48pm

sorry what's you try??

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sampath Lokuge · Answer 1 · 2013-12-28T06:05:00

Nope.You're wrong here.When you close the browser, you cannot get that session again.The idea of storing session on Sql server is the scenario where you have a web farm for your app.At that time even though your one of the IIS server down, still you can access the session which you stored on db by using downed (failed) IIS server.But you cannot do this by using default in process session.

Please read below mentioned article for more info:

How to use ASP.NET session state SQL Server Mode in a failover cluster

Session <sessionState mode="SQLServer" ..

1 solution

Solution 1

Add your solution here

Preview 0

Session <sessionState mode="SQLServer" ..

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us