I am writing a web application based on C#. What I would like to achieve is the following: an application that uses a single, global SQL connection. Which can be opened or closed when querying the db.
I think it would be nice to avoid instantiating an SqlConnection object every time I read some data from the db.
What is the best way to proceed?