figuerres said:DaveK said:*snip*
I am trying to picture what kind of data and size of data you want to hold on a phone....
I have a CE app that has local data and i do not need SQL on it today and it works fine.
It's Binary Serialzed data that is managed with some LINQ to Objects classes.
for this app it works great.
even if you have a SQL database the devices storage is limited .... so i get stuff off the device as soon as it can be synced up to the server.
Thanks for the reply.
I have several SQL CE databases with a few thousand records and about 16-30 tables. I have to worry about
1) access speed
2) data corruption
3) data security
4) offline operation and sync
All of these seemed to be well handled by a SQL CE db.
I have no idea how to insure these 4 above mentioned concerns will play out storing data in xml files or some other manner on the device.
I thought that Microsoft's Project Huron would have lead to caching SQL CE db's on the device and syncing occassionally to a server.
Now I have to set up my own data store, secure it and setup a custom sync technology? If SQL CE wasn't an important step up, why was it introduced to WindowsMobile and then the desktop?
In my scenario, a slow or stopped app because a server is unavailable is not acceptable and a real deal killer.
How limited is the device storage going to be? any storage cards on the device?
Even the IPhone has SQLite.