Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > Loading the session state from the database

Reply
Thread Tools

Loading the session state from the database

 
 
Scott Vercuski
Guest
Posts: n/a
 
      05-13-2004
Hello all,

I've got a question about session state. Is it possible to
declare and load a session into a session object from the sql server
database. Here's the scenario ...

I've got a website using SqlServer as the session state manager.
I've got a web service that I'd like to pass in the SessionID and have
it load the session from the database. I'd just like to know if this
is possible.

Thank you in advance for any assistance.
Scott Vercuski

 
Reply With Quote
 
 
 
 
Patrice
Guest
Posts: n/a
 
      05-13-2004
In the worst case, you can alwyas read from the database anyway.

That said, for a web service I'm not sure this is quite an ideal
architecture. I would let rather the webservice works as a single thing (ie
not depend on having a session established somewhere else).

If you need to make multiple calls the webservice could expose login/logout
methods and maintain state between these two calls if needed ???

Else it can be more than something that is queued to a table and that the
webservices uses at a later time ?

Patrice

"Scott Vercuski" <> a écrit dans le message de
news: om...
> Hello all,
>
> I've got a question about session state. Is it possible to
> declare and load a session into a session object from the sql server
> database. Here's the scenario ...
>
> I've got a website using SqlServer as the session state manager.
> I've got a web service that I'd like to pass in the SessionID and have
> it load the session from the database. I'd just like to know if this
> is possible.
>
> Thank you in advance for any assistance.
> Scott Vercuski
>



 
Reply With Quote
 
 
 
 
Scott Vercuski
Guest
Posts: n/a
 
      05-13-2004
Patrice,

You make a good point, but I would also like to know if it is
possible to "reload" a session object from the database for other
purposes in my application.

Thank you,
Scott

"Patrice" <> wrote in message news:<#e$Lv$>...
> In the worst case, you can alwyas read from the database anyway.
>
> That said, for a web service I'm not sure this is quite an ideal
> architecture. I would let rather the webservice works as a single thing (ie
> not depend on having a session established somewhere else).
>
> If you need to make multiple calls the webservice could expose login/logout
> methods and maintain state between these two calls if needed ???
>
> Else it can be more than something that is queued to a table and that the
> webservices uses at a later time ?
>
> Patrice
>
> "Scott Vercuski" <> a écrit dans le message de
> news: om...
> > Hello all,
> >
> > I've got a question about session state. Is it possible to
> > declare and load a session into a session object from the sql server
> > database. Here's the scenario ...
> >
> > I've got a website using SqlServer as the session state manager.
> > I've got a web service that I'd like to pass in the SessionID and have
> > it load the session from the database. I'd just like to know if this
> > is possible.
> >
> > Thank you in advance for any assistance.
> > Scott Vercuski
> >

 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
ASP.NET 2.0 Session State and ASP.NET 1.1 Session State jnickfl1 ASP .Net 0 09-18-2006 03:23 PM
Unable to make the session state request to the session state server Maciek ASP .Net 0 09-15-2005 08:49 PM
Unable to serialize the session state. Please note that non-serializable objects or MarshalByRef objects are not permitted when session state mode is 'StateServer' or 'SQLServer'. Mike Larkin ASP .Net 1 05-23-2005 12:33 PM
Unable to make the session state request to the session state server Not Liking Dot Net Today ASP .Net 0 04-21-2004 11:54 AM
unable to make the session state request to the session state server shamanthakamani ASP .Net 1 11-20-2003 04:51 AM



Advertisments
 



1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57