It actually depends on your needs. Establishing a connection is expensive.


>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.