What is the default ResolveAction when we use sqlclientsyncprovider and how to change it.
-
giovedì 26 novembre 2009 15:22How 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:01Hi,
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
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- Proposto come risposta Mahesh DudgikarMicrosoft Employee, Owner mercoledì 2 dicembre 2009 06:53
-
sabato 5 dicembre 2009 04:19Proprietario
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- Proposto come risposta Mahesh DudgikarMicrosoft Employee, Owner lunedì 7 dicembre 2009 05:25
- Contrassegnato come risposta Dong CaoMicrosoft Employee, Moderator venerdì 11 dicembre 2009 19:48