What is the default ResolveAction when we use sqlclientsyncprovider and how to change it.

All replies

• 

  

  0

  Sign in to vote

  Hi,
  
  The default ResolveAction enum is FireEvent. For handling such conflicts look at: http://msdn.microsoft.com/en-us/library/bb725997.aspx
  
  In that link you'll find out how to hand conflict as well as how to change such values.
  
  About your last question,  you mean about use SQL Server Express instead of SQL Server Compact?
  
  Cheers,
  

  ---

  José Miguel Torres

  Friday, November 27, 2009 12:01 PM
• 

  

  0

  Sign in to vote

  Hi,
  
  The default ResolveAction enum is FireEvent. For handling such conflicts look at: http://msdn.microsoft.com/en-us/library/bb725997.aspx
  
  In that link you'll find out how to hand conflict as well as how to change such values.
  
  About your last question,  you mean about use SQL Server Express instead of SQL Server Compact?
  
  Cheers,
  

  ---

  José Miguel Torres

  
  Thanks for the response
  I am using sqlclientprovider and sqldbprovider to sync sqlexpress client data with sqlserver database provided in sample .
   
  here i couldn't find how to handle dataconflict.
   
  in the sample they have defined event handlers for confilct.these events are not firing when we update the record and sync from client to server or server to client
  

  Friday, November 27, 2009 12:41 PM
• 

  

  0

  Sign in to vote

  Hi again,
  
  Try using MS Sync Framework 2.0 instead of 1.0. Download it here .  Sync FX  supports hub-and-spoke and peer-to-peer synchronization for SQL Server Express as well.
  
  n the sample they have defined event handlers for confilct.these events are not firing when we update the record and sync from client to server or server to client
  -> If no event is fire then any conflict is generated if you subscribed the event handler correctly as follows:
  
  

  this.ApplyChangeFailed +=new EventHandler<ApplyChangeFailedEventArgs>(SampleClientSyncProvider_ApplyChangeFailed);
  

  where this is
  

  public
   class
   SampleClientSyncProvider : SqlCeClientSyncProvider
  
  

  Please check it and Sync Fx 2.0 SDK samlpes and tell us what happens...
  
  Cheers,
  
  
  

  ---

  José Miguel Torres

  • Proposed as answer by Mahesh DudgikarMicrosoft employee Wednesday, December 2, 2009 6:53 AM

  Friday, November 27, 2009 3:56 PM
• 

  

  0

  Sign in to vote

  The default conflict resolution action is really Continue - which means local wins.

  ---

  This posting is provided AS IS with no warranties, and confers no rights

  • Proposed as answer by Mahesh DudgikarMicrosoft employee Monday, December 7, 2009 5:25 AM
  • Marked as answer by Dong CaoMicrosoft employee, Moderator Friday, December 11, 2009 7:48 PM

  Saturday, December 5, 2009 4:19 AM