Sign in
Microsoft.com
 
Microsoft
 
 
 
Note: Forums will be making significant UX changes to address key usability improvements surrounding search, discoverability and navigation. To learn more about these changes please visit the announcement which can be found HERE.
Microsoft >
> 
> 
What is the default ResolveAction when we use sqlclientsyncprovider and how to change it.

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

  • Thursday, 26 November, 2009 3:22 PM
     
     
    Sign In to Vote
    0
    How to handle/set conflict resolver with SqlClientSyncProvider.

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

    Can we user SqlCeProvider to interact with sql express edition as client database.

    • Moved by Max Wang_Chinasoft Thursday, 21 April, 2011 10:26 PM forum consolidation (From:SyncFx - Microsoft Sync Framework Database Providers [ReadOnly])
    •  
       

    All Replies

    • Friday, 27 November, 2009 12:01 PM
       
       
      Sign In to Vote
      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
         
      • Friday, 27 November, 2009 12:41 PM
         
         
        Sign In to Vote
        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
           
        • Friday, 27 November, 2009 3:56 PM
           
           Proposed Has Code
          Sign In to Vote
          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
             
          • Saturday, 5 December, 2009 4:19 AM
            Owner
             
             Answered
            Sign In to Vote
            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