DBAccess in Winforms

[Guest]

Hi EveryOne,

What is the best approach for data access while developing applications
using Windows Forms ? Is it opening, working with and closing a new
SQLconnection and SQLcommand object everytime a DB access is needed , or
maintaining a single open connection/command object at the application level
( one for each user ) and then just reusing it again and again. The
connection string that the connection will use can be assumed to be static.

Thanks

 

[Lloyd Dupont]

What's I have done in all my previous project (wether it's good or not, who
knows) is:
My client application talk to my server application.
It's my server application which which talk to the database.
While working in Java I used to do connection pooling (on the server), but
no need to worry about that in .NET as SqlConnection do connection pooling
automatically.


--
Regards,
Lloyd Dupont

NovaMind development team
NovaMind Software
Mind Mapping Software
<www.nova-mind.com>