Re: Persistant connections?

[Fernando Gonzalez Sanchez]

Hi,

That depends on the architecture of your desktop app, if you are planning to allow the user work work in several simultaneous views (forms) of the data, then you'd better off with a single connection.

You may also want to have several connection open loading in parallel data for a complex form (like web browsers that can open multiple TCP connections to a web server to get the images, markup, javascript, etc.).

Having said that, there are still other scenarios where you would prefer multiple connection, for example

If you are doing reading from a MySqlDataReader and for each row want to write back something to the database, then you'll need more than one connection (DataReader lock the connection for as long as the reader is used, and free it when it's closed (the reader)).

If you don't know in advance, for maximum flexibility it's better to have several connections, you can enable pooling to optimize the management of multiple connections.

Just my 2 cents.