Hi everybody,

I have a theoretical question. If we're working with SQL Server, what is the commonly-used practice: open connection at the beginning of the application and close it at the end or open and close only when sending requests to the server?

I have this question for Visual FoxPro-SQL Server applications and for .NET applications.

Thanks a lot in advance.