Im developing an app in vb .net that uses a SQL database. My question is, is it best to publicly declare and keep open an SQL connection, or best to open and close the connection each time needed?
Users of my app could potentially keep the app open for days at a time (yes, they're not very computer savvy).
So, what do you think is best option?
Hope my question isnt too vague...appreicate your help