Printable View
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.
Hi
if you look at http://samples.gotdotnet.com/quickst...pactFramework/ 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 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
Thanks for the tips...Quote:
Originally Posted by petevick
I'm doing a read only app - appears that the SqlCeDataReader is probably better then the SqlCeResultSet - right?
Hi,
would still use ceresultset - it is faster
Pete
Really - 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...Quote:
Originally Posted by petevick
What do you base your choice of the ceresultset on?
Hi,
experience, and discussions with other device developers
Pete
Thanks - I'll take that under consideration...Quote:
Originally Posted by petevick