Store SqlConnection in SessionVariable

From: Rolf Gossen (rolf.gossen_at_gmx.de)
Date: 04/16/04 

Date: 16 Apr 2004 04:40:09 -0700

Hello NG,

sometimes I read: "Never store an SqlClient.SqlConnection in a Session
Variable." But noone explains why. Is there anyone who can briefly
summarize the main problems about this approach.

Thanks in advance
Rolf

Relevant Pages

  • Re: Storing a datatable (or arraylist )on ASP.NET Session
    ... Perhaps your ArrayList store smth which can't be casted to object. ... If exactly that code u shown didn't work (emply arraylists) that I recomment to re-register asp.net 2.0 calling aspnet_regiis,exe - i ... Team blog: http://devkids.blogspot.com/ ... b> session variables is stored on web server's local sql database. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: LISP for web
    ... >>Ideas on how to store this information centrally for all of the app ... > ucw's form handling code (to make sure session ids are always ... > can deal with hardware failures an the app servers but this ...
    (comp.lang.lisp)
  • Re: Problem with asp.net app only allowing 1 user at a time
    ... from the client to the server), Application (an object that can store ... Now in your case you are reading and writing everything to the database, ... there is the Session object. ... To retrieve this you would do something like: ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: LISP for web
    ... > Ideas on how to store this information centrally for all of the app ... the risk of losing data and sessions if one of the machines goes ... ucw's form handling code (to make sure session ids are always ...
    (comp.lang.lisp)
  • Re: Dynamic controls query
    ... If they are choosing their own UI, I am assuming they will want to retain ... these settings beyond this session? ... In that case you would store in either a data store (xml file on server, ... in a session variable and call from a postback, ...
    (microsoft.public.dotnet.framework.aspnet)