Best way to access my SQLce Database?q -- dotnet compact framework

dotnet compact framework : Best way to access my SQLce Database?q

éric
2/5/2004 4:59:47 PM

connect once and release when you close the application... that is the best
way... overhead for keeping connection in memory is less then overheard of
trying to open and close db everytime you want to do something.

One note... if you want some other application to use the db you will have
to close and wait then reopen.

Regards,

éric

[quoted text, click to view]

Atley
2/5/2004 7:40:50 PM

I have written an application in VB.NET 2003 and I occasionally get one form
not showing any data, because it is trying to open a connection to the
database before the last form has completely released it's hold on the db.

What is the best way to connect to the database?
Is it better to connect once at the beginning and leave the connection open
through the whole application. Will idividual datasets have problems
running into each other?

Or is it better to do it the way i have done it, connect only when you need
the data and then close the connection right away.

Which one is better, why?

Thanks

éric
2/5/2004 8:21:16 PM

[quoted text, click to view]
YES

[quoted text, click to view]
YES

[quoted text, click to view]

[quoted text, click to view]

Atley
2/5/2004 8:39:57 PM

Can two different datasets be accessing through one connection at the same
time?

How would you go about this? just create a global variable for the data
connection?

Will my application run any quicker?

Thanks for your input.

[quoted text, click to view]

éric
2/6/2004 7:28:14 AM

William is right... can not be said categorically that open and close
everytime is better then open and close once... but I assumed that if you
have an application that was using multiple datasets with dataadapters your
scenario was likely to use the database often. If you only connect to sqlce
for the odd data retreival or update you should concider closing the
connection.

In my scenario I use have a point of sale application which retrieves a
customer from the database then inventory from the database then writes an
invoice to the database. I have tested both ways and open once close later
was without a doubt faster.

I rarely use datasets though.. mostly sqlcecommand and sqlcedatareader. If
speed is important don't use datasets.

Regards,

éric

William Ryan eMVP
2/6/2004 9:01:17 AM

Eric:

I have to respectfully disagree here and would not recommend leaving a
connection open for the life of an application. And the issue of overhead
efficiency can't be made categorically like that. It depends on many
factors and if anything, I think the consensus is that closing your
connections when you don't need them is a superior approach in most every
regard.
[quoted text, click to view]

William Ryan eMVP
2/6/2004 9:04:50 AM

Atley:

DataSet's don't need or use a Connection for access. The DataAdapter may
use a Connection(if you are using a DataAdapter) to fill your datasets and
get data back to the server, but datasets don't have a connectino property.

Also, you should be able to accomplish most scenarios with only one dataset.

Since I disagree wholeheartedly about leaving a connection open for the life
of the app, I'd recommend storing the connection string somewhere globally
accessible...that would allow you to create connections anywhere with the
same connection string.

HTH,

Bill
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about dotnet compact framework

View Other Months
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
December 2007
January 2008
February 2008
March 2008
April 2008
May 2008
June 2008

home · blog · groups

Questions? Comments? Contact the dn