Performance with SqlCeConnection

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Please,
What is the better choice with the SqlCeConnection.Open / .Close :

1 - Open the Connection and Keep always open while the application is
running and Close only when the application is Ended.
or
2 - Open and Close the Connection after use every time is necessary.
??
Tanks
 
It really depends on your application. In general - I'd have a strong bias
toward closing your connections - store the data in a Dataset and use it
throughout the program - CE works the opposite though of normal
SqlConnection objects - you can only open one instance but you can fire
multiple commadns on it - with that said, I still personally lean toward
closing my stuff and writing to the actual db only when I have to.
 
Hi Julio,

Its a common practise to have a single global connection for the entire
application for perfomance.
Open it when the application starts using the database. There are some
times you have to check the state of the connection using ConnectionState
property, mostly while you work with DataReader as it needs a live
connection, and open if found closed. Its a best practise to fill you
DataSets and close the connection if there is no further need with the
command objects and data readers.
 
Back
Top