I have read in detail the articles of using a middle tier in Windows Azure to sync a SQL Azure database with SQLServerCE thus providing a means to have a "sometimes connected" app. Client to Windows Azure uses WCF. Middle tier (web roles to worker(s)
via Service bus / queues. Worker communicates to Azure. I believe each client can maintain a "sync parternship" to retrieve recent changes.
Can this technique also be employed from within a Windows Phone 7.x app? Any articles or videos on this topic? I know SQLServerCE is new to Mango and haven't seen many new articles on this topic.
If so, is this a viable approach given that you may have tens of thousands of users? Given the scalability of Azure it would make sense but want to make sure I am going down the right path.
Ultimately, I am actually looking for a means to allow my phone to sync with my desktop/notebook. I'd like both to use the Sync framework so they can work offline (e.g. no phones or in airplane mode...).
This seems like a really good solution.
Ed