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...).
You can't install Sync Framework itself on the WP7 device, so your best option will be the Sync Framework Toolkit (http://code.msdn.microsoft.com/Sync-Framework-Toolkit-4dc10f0e)
which is specifically designed for clients that can't have the full Sync Framework runtime (SL, WP, iPhone, Android, HTML5). the server side component of the toolkit remains running on Sync Framework though. You can deploy the Sync Service in Azure as well
(it's a WCF service).
if am not mistaken, there's a sample there for using SQL CE, but you might have to port it to WP7 as the WP7 samples uses Isolated Storage.