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

ตอบทั้งหมด

• 27 พฤศจิกายน 2552 12:01

   

   
  

  0
  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
   
• 27 พฤศจิกายน 2552 12:41

   

   
  

  0

  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
  
   
• 27 พฤศจิกายน 2552 15:56

   

   
  

  0
  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

  • เสนอเป็นคำตอบโดย Mahesh DudgikarMicrosoft, Owner 2 ธันวาคม 2552 6:53
  •  
   
• 5 ธันวาคม 2552 4:19

  เจ้าของ

   

   
  

  0
  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

  • เสนอเป็นคำตอบโดย Mahesh DudgikarMicrosoft, Owner 7 ธันวาคม 2552 5:25
  • ทำเครื่องหมายเป็นคำตอบโดย Dong CaoMicrosoft, Moderator 11 ธันวาคม 2552 19:48
  •