Local datastore for visual basic .net aplication on a pda

[Guest]

I have this project for developing an drug interaction aplication for a pda
under a windows o.s .

The aplication is being developed on visual basic .net (using visual studio
..net 2003), and I needed to create an local datastore, the problem is that
most of the database access controls and etc available on the full .net
framework aren´t available for the .net compact framework, so, so much for
using an MS access database file, as for SQL, I kinda dislike the ideia of
having to install the CE server on the pda just to run a lame database that
only uses SELECT and WHERE (=?) queries (the aplication only reads a
specific value from a field on the database and compares it to another value
from another field).

So after all this, here's my questions: Is there any way to use an sql
database file as an local datastore without the SQL server running? Just by
reading from the file that is? And how about an serialized xml file from the
object model, could it do the trick or does it run in to the missing class
prob in compact framework?

Thanks for reading and for your time, help is most welcome.

 

[Chris Tacke, eMVP]

Sure. SqlServerCe is what you want. You don't need a backend server to use
it, it works fine as a local data store.

 

[Aaron]

In other words, if you don't need to sync your datastore with the desktop,
or back your data up on the desktop in any way, SqlServerCe can be used
without having SQL Server on the desktop?

 

[Chris Tacke, eMVP]

Yes. And in that case it's also free.