DB connection - should i close it?

[moein_ak]

Hello everyone
I had a little question.
When i open a connection in vb.net should i close it after using it and open it again when i need it or let it be open the whole time until the program is terminated?
Please answer with reason
thanks

 

[cjard]

Close it, because Microsoft say that's what you should do and they know best, because they wrote the language. ADO.NET uses a mechanism that makes database access as efficient as possible. It relies on you doing what Microsoft tell you to - opening and closing connections only when needed.

If you turn off that mechanism (Connection Pooling) then open/close will cause a performance hit, but first you should have a justified reason for turning off pooling..

Personally, i just use their modern, advocated way of doing data access (read the DW4 link in my signature) and the code that visual studio generates for the data access layer worries about all that stuff..

 

[moein_ak]

Thanks a lot for the answer!