Mobile App Design

[Guest]

Hi

I have a Mobile App running on PocketPc 2003 OS. My connection to a Sql database is not consistent. What design should I go with in order to store data locally and when connection is made download data to database ? Should I use maybe web services or MSMQ? Any ideas please

Thanks

JJ

 

[William Ryan eMVP]

JJ:

you can use SQL Server CE and implement replication. If you check out
www.devbuzz.com we have a pretty good discussion on the subject and Rob
Tiffany (who wrote the quintessential quide to SQL CE and the Compact
Framework) is the primary moderator. However, CE may or may not be a good
solution. You can easily serialize and deserialize datasets using
dataSet.ReadXML("filename") or dataSet.WriteXML("FileName"). Basically, if
you use ADo.NET the way that it's intended, this will integrate perfectly.
Similarly Web Services provide a great solution, but you need connectivity
to really take advantage of them, so you are reading and writing XML to a
web service instead of reading and writing XML to a file locally.

MSMQ isn't implemented on the CF yet, although it is on PocketPC.
www.opennetcf.org has an implementation, but I'm not sure if it's been
released.

HTH,

Bill

Hi,

I have a Mobile App running on PocketPc 2003 OS. My connection to a Sql

database is not consistent. What design should I go with in order to store
data locally and when connection is made download data to database ? Should
I use maybe web services or MSMQ? Any ideas please ?