title: Is it acceptable to keep a db connection open for the life of the page?
body: <p>Everybody knows that you should close a connection immediately after you finish using it.</p>
  
  <p>Due to a flaw in my domain object model design, I've had to leave the connection open for the full page life cycle.  Essentially, I have a Just In Time property which opens a connection on first call, and then on Page.Unload (..) it would check if a db connection was ever open, and then close it if it was.  Since it only takes a second, I’ve had the opinion its not too much different than closing it immediately.</p>
  
  <p>Is this ok?  Or should it still be closed immediately after every single use?  </p>
  
  <p>Thanks in advance.</p>