Sharing DB connection

[David Dvali]

How can I share DB connections between many pages?

 

[Teemu Keiski]

Hi,

why would you need to? Do you have some sort of transaction which should
last over multiple pages?

Anyways, connection pooling in .NET is one reason why you shouldn't try to
share connections, but instead use them so that open the conn late and close
as soon as possible and when you need a another conn, instantiate such when
needed.

 

[Kevin Spencer]

You should not. This is not your grandfather's ASP. ASP.Net uses Connection
Pooling to solve the problems that ASP had. With ASP.Net, you should open
and close Connections as quickly as possible.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
The sun never sets on
the Kingdom of Heaven