Multiple scope problem - SQLExpress2008 - SQLCe

All replies

• 

  

  0

  Sign in to vote

  can you post the code snippet for the part you're synchronizing?

  Monday, March 21, 2011 3:04 PM
• 

  

  0

  Sign in to vote

  Sure,

  Here is the code to do the synchronization in both directions

      private void doSynchronizeBothWays()
      {
  
        RelationalSyncProvider srcProvider = providersCollection["Server"];
        RelationalSyncProvider destinationProvider = providersCollection["Client 1"];
        SyncDirectionOrder determinedSyncDirection = SyncDirectionOrder.UploadAndDownload; //(destinationProvider is SqlSyncProvider) ? SyncDirectionOrder.UploadAndDownload : SyncDirectionOrder.DownloadAndUpload;
  
        RelationalProviderProxy destinationProxy = null;
        string hostName = (destinationProvider is SqlSyncProvider)
          ? ((SqlConnection)destinationProvider.Connection).DataSource
          : destinationProvider.Connection.Database;
  
        if (destinationProvider is SqlSyncProvider)
        {
          destinationProxy = new SqlSyncProviderProxy(SyncUtils.ScopeNameBothWays, ((SqlConnection)destinationProvider.Connection).DataSource);
        }
        else
        {
          //create a reference to the server proxy
          SqlSyncProviderProxy serverProxy = new SqlSyncProviderProxy(SyncUtils.ScopeNameBothWays, SyncUtils.ScopeMachine);
  
          //retrieve the scope description from the server
          DbSyncScopeDescription scopeDesc = serverProxy.GetScopeDescriptionBothWays();
  
          serverProxy.Dispose();
  
          //generate a new proxy for the client
          destinationProxy = new CeSyncProviderProxy(SyncUtils.ScopeNameBothWays, destinationProvider.Connection.Database, scopeDesc);
        }
  
        //Set memory data cache size property. 0 represents non batched mode
        srcProvider.MemoryDataCacheSize = this._batchSize;
  
        //No need to set memory cache size for Proxy as since the source is enabled for batching, both upload and download will
        //be batched. 
  
        //Set batch spool location. Default value if not set is %Temp% directory.
        if (!string.IsNullOrEmpty(batchSpoolLocation))
        {
          srcProvider.BatchingDirectory = batchSpoolLocation;
          destinationProxy.BatchingDirectory = batchSpoolLocation;
        }
  
        SyncOperationStatistics stats = synchronizationHelper.SynchronizeProviders(srcProvider, destinationProxy, determinedSyncDirection);
  
        TimeSpan diff = stats.SyncEndTime.Subtract(stats.SyncStartTime);
  
        destinationProxy.Dispose();
  
        //Print Sync stats object
        Console.WriteLine(string.Format("Batching: {4} - Total Time To Synchronize = {0}:{1}:{2}:{3}",
          diff.Hours, diff.Minutes, diff.Seconds, diff.Milliseconds, (this._batchSize > 0) ? "Enabled" : "Disabled"));
      }
  
    }
  
  

  and here is the code block that is giving the error
  

      public SyncSessionStatistics ApplyChanges(ConflictResolutionPolicy resolutionPolicy, ChangeBatch sourceChanges, object changeData)
      {
        Log("ProcessChangeBatch: {0}", this.peerProvider.Connection.ConnectionString);
  
        DbSyncContext dataRetriever = changeData as DbSyncContext;
  
        if (dataRetriever != null && dataRetriever.IsDataBatched)
        {
          string remotePeerId = dataRetriever.MadeWithKnowledge.ReplicaId.ToString();
          //Data is batched. The client should have uploaded this file to us prior to calling ApplyChanges.
          //So look for it.
          //The Id would be the DbSyncContext.BatchFileName which is just the batch file name without the complete path
          string localBatchFileName = null;
          if (!this.batchIdToFileMapper.TryGetValue(dataRetriever.BatchFileName, out localBatchFileName))
          {
            //Service has not received this file. Throw exception
            throw new FaultException<WebSyncFaultException>(new WebSyncFaultException("No batch file uploaded for id " + dataRetriever.BatchFileName, null));
          }
          dataRetriever.BatchFileName = localBatchFileName;
        }
  
        SyncSessionStatistics sessionStatistics = new SyncSessionStatistics();
  <strong>      this.peerProvider.ProcessChangeBatch(resolutionPolicy, sourceChanges, changeData, new SyncCallbacks(), sessionStatistics);
  </strong>      return sessionStatistics;
      }
  

   

  Thanks for looking at this. Let me know if I'm not sending the right code.

  Hank

  Monday, March 21, 2011 3:18 PM
• 

  

  1

  Sign in to vote

  your ConfigureSqlSyncProvider and ConfigureCESyncProvider are provisioning two scopes, however, you are setting the provider.ScopeName to ScopeNameToClient. So when they get added to the collection, their scopenames are both ScopeNameToClient.

   

  • Marked as answer by HankAnzis Monday, March 21, 2011 4:56 PM

  Monday, March 21, 2011 4:16 PM
• 

  

  1

  Sign in to vote

  nope. a provider has only one ScopeName property. you should pass the scope name you want to sync in the ConfigureSqlSyncProvider and ConfigureCESyncProvider and assign it to the Scopename property.

  Monday, March 21, 2011 4:24 PM
• 

  

  0

  Sign in to vote

  I see what you are telling me now. I need to have a separate provider for each scope and call the ones I need for each separate sync.

  Thanks JuneT,

  Hank

  Monday, March 21, 2011 4:56 PM