Hello,
I am try to do this tutorial:
http://msdn.microsoft.com/en-us/library/ff928494(v=SQL.110).aspx
I get to the last part with this code:
Imports
System
Imports
System.Data
Imports
System.Data.SqlClient
Imports
System.Data.SqlServerCe
Imports
Microsoft.Synchronization
Imports
Microsoft.Synchronization.Data
Imports
Microsoft.Synchronization.Data.SqlServer
Imports
Microsoft.Synchronization.Data.SqlServerCe
Module
Module1
Sub
Main()
' create a connection to the SyncCompactDB database
Dim
clientConn As
New
SqlCeConnection("Data
Source='C:\Users\MutlyP\Documents\Visual Studio 2010\Projects\SyncSQLServerAndSQLCompact\SyncCompactDB.sdf'")
' create a connection to the SyncDB server database
Dim
serverConn As
New
SqlConnection("Data
Source=localhost; Initial Catalog=SyncDB; Integrated Security=True")
' create the sync orhcestrator
Dim
syncOrchestrator As
New
SyncOrchestrator()
' set local provider of orchestrator to a CE sync
provider associated with the
' ProductsScope in the SyncCompactDB compact client
database
syncOrchestrator.LocalProvider =
New
SqlCeSyncProvider("ProductsScope",
clientConn)
' set the remote provider of orchestrator to a
server sync provider associated with
' the ProductsScope in the SyncDB server database
syncOrchestrator.RemoteProvider =
New
SqlSyncProvider("ProductsScope",
serverConn)
' set the direction of sync session to Upload and
Download
syncOrchestrator.Direction =
SyncDirectionOrder.UploadAndDownload
' subscribe for errors that occur when applying
changes to the client
'DirectCast(syncOrchestrator.LocalProvider, SqlCeSyncProvider).ApplyChangeFailed
+= New EventHandler(Of DbApplyChangeFailedEventArgs)(Program_ApplyChangeFailed)
' execute the synchronization process
Dim
syncStats As
SyncOperationStatistics
= syncOrchestrator.Synchronize()
' print statistics
Console.WriteLine("Start
Time: " + syncStats.SyncStartTime)
Console.WriteLine("Total
Changes Uploaded: " + syncStats.UploadChangesTotal)
Console.WriteLine("Total
Changes Downloaded: " + syncStats.DownloadChangesTotal)
Console.WriteLine("Complete
Time: " + syncStats.SyncEndTime)
Console.WriteLine([String].Empty)
End
Sub
Private
Sub
Program_ApplyChangeFailed(ByVal
sender As
Object,
ByVal
e As
DbApplyChangeFailedEventArgs)
' display conflict type
Console.WriteLine(e.Conflict.Type)
' display error message
Console.WriteLine(e.[Error])
End
Sub
End
Module
This line of code:
New
SqlCeSyncProvider("ProductsScope",
clientConn)
gives me the error:
"Type SqlCeSyncProvider is not defined"
But as you can see I have the reference:
Microsoft.Synchronization.Data.SqlServerCe
and it is 3.5 version.
Why am I getting this error.
Please help.
Thank You
