How to: Handle Data Conflicts and Errors 【转载】

最新推荐文章于 2024-01-31 13:46:15 发布

原创最新推荐文章于 2024-01-31 13:46:15 发布 · 741 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#conflict #server #microsoft #filter #processing #application

[随笔分类]Microsoft .NET 同时被 3 个专栏收录

441 篇文章

订阅专栏

[网站分类]VS2010

17 篇文章

订阅专栏

[随笔分类].NET Framework Fundamental

7 篇文章

订阅专栏

本文介绍了Microsoft Sync Framework (MSF)中数据同步时的冲突检测与处理机制。冲突发生在行级别，当一行数据在多个节点间发生变化时，MSF会检测到冲突。常见的避免冲突的方法包括仅在一个节点上更新数据或通过过滤数据来确保每个节点只更新特定行。对于不可避免的冲突，MSF提供了一套解决方案。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

MSF(Microsoft Sync Framework）是微软的一套数据同步框架，其中一个典型场景就是实现本地数据库与远程数据库之间的数据同步，这样可以比较容易实现脱机应用程序的架构

有关MSF的一些具体内容，可以参考微软的官方网站

http://msdn.microsoft.com/en-us/library/bb902854.aspx

这一篇特别摘录一下有关数据同步时的冲突检测和处理，完整的文档参考下面

http://msdn.microsoft.com/en-us/library/bb725997.aspx

Understanding Data Conflicts and Errors

In Sync Framework, conflicts and errors are detected at the level of the row. A row is in conflict if it has been changed at more than one node between synchronizations. Errors during synchronization typically involve a constraint violation, such as a duplicate primary key. Applications should be designed to avoid conflicts if they can, because conflict detection and resolution introduce additional complexity, processing, and network traffic. The most common ways to avoid conflicts are as follows: to update a table at only one node (typically the server); or to filter data so that only one node updates a particular row. For more information about filtering, see How to: Filter Rows and Columns. In some applications, conflicts cannot be avoided. For example, in a sales force application, two salespeople might share a territory. Both salespeople could update the data for the same customer and orders. Therefore, Sync Framework provides a set of features that can be used to detect and resolve conflicts.

Data conflicts can occur in any synchronization scenario in which changes are made at more than one node. Obviously, conflicts can occur in bidirectional synchronization, but they can also occur in download-only and upload-only synchronization. For example, if a row is deleted at the server and the same row is updated at the client, there is a conflict when Sync Framework tries to apply the update that is uploaded to the server. Conflicts are always between the server and the client that is currently synchronizing. Consider the following example:

Client A and client B synchronize with the server.
A row is updated at client A, and then client A synchronizes. There is no conflict, and the row is applied at the server.
The same row is updated at client B, and then client B synchronizes. The row from client B is now in conflict with the row from the server because of the update that originated at client A.
If you resolve this conflict in favor of the server, Sync Framework can apply the row from the server to client B. If you resolve in favor of client B, Sync Framework can apply the row from client B to the server. During a later synchronization between client A and the server, the update that originated at client B is applied to client A.