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 VFP-SQL Server applications and for .NET applications.

(I'm going to cross-post in .NET forum).

Thanks a lot in advance.