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

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

  • giovedì 26 novembre 2009 15:22
     
     
    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.

    • Spostato Max Wang_Chinasoft giovedì 21 aprile 2011 22:26 forum consolidation (From:SyncFx - Microsoft Sync Framework Database Providers [ReadOnly])
    •  

Tutte le risposte

  • venerdì 27 novembre 2009 12:01
     
     
    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
  • venerdì 27 novembre 2009 12:41
     
     
    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
  • venerdì 27 novembre 2009 15:56
     
     Risposta suggerita Contiene codice
    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
  • sabato 5 dicembre 2009 04:19
    Proprietario
     
     Con risposta
    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