Hi,
-SQL Server: 2008 SP1
-VS 2008 SP1
-Microsoft Sync Framework 1.0
-SQL 2008 -> SQLCE 3.5
-SyncDirection.DownloadOnly
I'm trying to create a application that will sync just to the client (SQL CE). I create a winform project following some basic examples. I changed one row in SQL Server and expected to update the CE after the following code:
Dim syncAgent As LocalDataCache1SyncAgent = New LocalDataCache1SyncAgent()
Dim syncStats As Microsoft.Synchronization.Data.SyncStatistics = syncAgent.Synchronize()
After Synchronize() the syncStats has DownloadChangesApplied = 1 (perfect). But when I query SQL CE 3.5 table it does not show any change? Is there any commit or update I need to complete?
One more piece of information: If I double click on LocalDataCache1.sync (Configure Data Synchronization) and then press OK, it syncs and updates the SQL CE 3.5 table. Works everytime.
Cheers,
Steven Ellis