using sqlserver to manage state

[wardy]

I've got a .NET web application that currently uses session to
maintain state. I am just looking down the road and thinking of
scaleability and if I need to go to a web farm, then using "inproc"
for managing my session will no longer work. I've done some research
and read about how SQL Server can manage session, but I've found very
little in terms of how to actually do this. Basically what I've found
so far is that I run a script that comes with .NET (can't think of the
name right now ) which sets up the tables and stored procs required
to manage the sessions. My question is once this is done, how is it
actually implemented? Are any code changes required (from the
"Session.Add" and "Session.Item" used with inproc session management)?

Thanks.

 

[Natty Gur]

Hi,

No code changes required. you just need to set sessionState mode
attribute to Sqlserver.

refer to : http://idunno.org/dotNet/sessionState.aspx.


Natty Gur[MVP]

blog : http://weblogs.asp.net/ngur
Mobile: +972-(0)52-8888377


*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!