We are building a large scale Silverlight 4.0 application which requires offline capability especially when the network goes down. We are planning to leverage Microsoft Sync Framework 4.0 to enable offline capability.
1)Can we use SQL Compact Edition instead of Isolated Storage to locally store data on client's machine in Sync Framework 4.0?
2) If Yes, then do we have to explicitly copy the .sdf file on client's machine?
3) If Yes, then how to copy the .sdf file on client's machine?
Please provide the code sample if possible.
Thanks in advance:)