DaveK said:figuerres said:*snip*
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.
I must absolutely agree, a locale database system is essential and XML files are not a replacement. Hopefully SQLite will work, I've prefered it anyways in the past. It seems they are working on a full managed library: http://sqlite.phxsoftware.com/forums/t/2233.aspx
I just wish Microsoft would implement SQLite officially on WP7, it's also on all other mobile platforms. The other problem is how to sync data from the desktop to the device? In the past I've done it via RAPI, but now? How to get into the isolated storage from the desktop? Please do not say cloud...