What is the default ResolveAction when we use sqlclientsyncprovider and how to change it.
-
26 listopada 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.
- Przeniesiony przez Max Wang_Chinasoft 21 kwietnia 2011 22:26 forum consolidation (From:SyncFx - Microsoft Sync Framework Database Providers [ReadOnly])
Wszystkie odpowiedzi
-
27 listopada 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 -
27 listopada 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 -
27 listopada 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- Zaproponowany jako odpowiedź przez Mahesh DudgikarMicrosoft Employee, Owner 2 grudnia 2009 06:53
-
5 grudnia 2009 04:19Właściciel
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- Zaproponowany jako odpowiedź przez Mahesh DudgikarMicrosoft Employee, Owner 7 grudnia 2009 05:25
- Oznaczony jako odpowiedź przez Dong CaoMicrosoft Employee, Moderator 11 grudnia 2009 19:48