How to synchronize data between multiple client applications

Question

I need to synchronize the data that "one client" has updated, and they need to be updated on the "other client" (in another room) of the same application.

1 - What is the best approach to this? I thought about SqlDependency, but the application can also work on other database mechanisms (I reject it) I also think about polling the timer for updates, but I really do not want to check the changes periodically.

Does anyone have this problem? How did you solve it?

2 - Optional. When should the data be updated in the user interface without interfering with the work of people on another PC?

Scenario: 3 PCs working with the same data. Creating / updating records that need to be synchronized (to get the latest changes that each PC made).

I hope I clearly understood my situation.

Thanks in advance.

Answer 1

If you know that you have only two instances of the application, you can do this with WCF. Each of the clients acts as a server for the other when it wants to send an update.

How you want to process data updates edited by both clients ... it can be tricky. It depends on your data type if the GUI is designed to handle updates and such things.