ASP vs ASP.NET

[Anandraj]

Hi All,
I ASP experts use to tell that it is always good to create and close the
connection in each page instead of creating once and stored in the Session
Variable. Same thing will goes for ASP.NET also or Can we use Connection
Object by storing it in the Session Variable.
Is there any Pooling Advantages over this.

Thanks
Anandraj.A.

 

[James Zhuo]

yeah, why not let ADO.NET handle it for you automatically.
Tho i alway assume that connection pooling is also handled automatically by
ASP. any one with an answer to this?

Also, doesn't RDBMS like MS SQL does connection pooling automatically for
you?? Does ADO.NET take advantage of this RDBMS feature to implement
connection pooling. I have no idea, experts please explain.

thanx and cheer

J