[RESOLVED] Sql Ce

[szlamany]

Ok - quick question...

I downloaded SQL CE from the MS site (SQLServerCE3 1-EN.MSI) - it installed on my workstation but nothing seems to appear in my START/PROGRAM list.

I'm guessing this is just so that my app in the VS2005 IDE can use the SQL CE - right? And when I deploy it does it copy the needed dep's and the engine to the PPC?

How to I create a DB and put that on the PPC - all through the IDE?

I'm very used to QA and EM from SQL 2000 - I like to scripts all my table objects and what not.

[petevick]

Hi
if you look at http://samples.gotdotnet.com/quickstart/CompactFramework/ there is a sample of creating a database, and table etc.

You can also do it through VS2005 and copy it to the device, or RemoteSQLCe (http://www.gui-innovations.com/html/remotesqlce.html) from our site allows you to do it, or port existing ODBC databases to SqlMobile. Remember, you can now access and manipulate SDF files on the desktop.

Writing for SqlMobile is pretty much like the desktop version, excepting that there are no stored procs, triggers etc.

Also look at SqlCeResultset - it is much faster when retrieving from a SqlMobile database

HTH

Pete

[szlamany]

Also look at SqlCeResultset - it is much faster when retrieving from a SqlMobile database
Thanks for the tips...

I'm doing a read only app - appears that the SqlCeDataReader is probably better then the SqlCeResultSet - right?

[petevick]

Hi,
would still use ceresultset - it is faster

Pete

[szlamany]

Hi,
would still use ceresultset - it is faster

PeteReally - bindable and all - scrollable? Going to take a resultset and load it into a control - listview - grid - whatever - and immediately trash that resultset. The MS doc seemed to point me in the direction of the reader...

What do you base your choice of the ceresultset on?

[petevick]

Hi,
experience, and discussions with other device developers

Pete

[szlamany]

Hi,
experience, and discussions with other device developers

PeteThanks - I'll take that under consideration...