Maintaining connection to MSSQL 1

[haddaway]

I am facing problems of how to solve an issue. I have an application that is always on in the background. The application call a lot of stored procedures and it's seems costly to connect and disconnect for each question.

Which is the best way to maintain the connection state and connect if needed? I mean, the state can be other than open or closed. Please give me any input on this matter. Thanks.

 

[litton1]

As far as I am aware while the program is running the connection state is active. That is by default you are in a connection pool and thus reduce server load on creating a connection. That is my understanding anyway….
Hope this helps

Age is a consequence of experience

 

[haddaway]

So,how do I use it? Do I open it once? And if connection state is closed/inactive I open it again, and the I close it when I close my application?

 

[litton1]

no you should open and close as and when you use it but ADO.NET will keep you a connection to the server.
hope that is more clear?

Age is a consequence of experience