Creating a standalone database application on WP7 - finding the right way

Question

I need to create a standalone database application on WP7. The application is simple - it is about ordering from our customers and then transferring it to the main server (MS SQL).

Spend a few days reading about existing technologies, but I'm still confused. What is suitable for this project?

• Synchronization. It looks good, but, as I understand it, it provides single tables - there are no links to them. All the links I have to build on the client side. Garden.

• Entity FrameWork on the server side. And I have no idea what I can use on the client side. Is there a way to serialize the object of the object to isolate the store, and then restore it and continue working with it? Maybe I can use Sync FrameWork, but the circuit will become strange then - curious one way.)))

• Working with WCF and XML is the easiest for me. A lot of code and conversion, but in this case I understand the data flow. In another, I already have an application with pure SQL queries. I want to be advanced. ))))

• Using ext. Databases (e.g. siaqodb). Which one of? siaqodb suppots is a "synchronization provider", but it does not support object references - so do I have to build them myself? Any profit? I dont know.

Is there any other way to create such applications? Direct him.

Answer 1

If you need to do this offline, I would usually use something like:

• keeping the minimum amount of data required in isolation using a specific WP7 database such as Sterling
• using either the new REST or the new RIA / WCF service with the objects / functions that you define to ensure the required data synchronization.

I think this is your option 3?

I never liked automatic data synchronization. It’s just easier for me to program the synchronization and handle errors myself - this is especially important if your wp7 client application uses a rather small data size in relation to a larger db server.