MySQL 或 Microsoft Sync Framework 同步/复制
我正在创建一个具有一台服务器和多个客户端的应用程序。这是一个在 MySQL 数据库上使用 ADO.NET Entity Framework 4 的 ac# 应用程序。
客户端需要从服务器上的多个数据库表中获取数据。还有 2 个单独的表需要从客户端发送到服务器。在某些时候，客户端应该能够删除这两个表中的一些旧数据并将其保留在服务器上。如果客户端与服务器断开连接一段时间并且需要在重新连接后的某个时刻更新表，则客户端需要能够工作。
我正在考虑使用 MySQL 复制，但我认为客户端无法在不影响服务器表的情况下删除旧数据。我也研究过微软同步框架，但我不确定这是否理想，甚至是否能满足我的需求。
我对这个主题了解不多，因此我们将不胜感激。
谢谢你， 马特·W
I am creating an application that has one server and multiple clients. It is a c# app that uses ADO.NET Entity Framework 4 over a MySQL database.
The clients need to get data from several database tables on the server. There are also 2 separate tables that need to be sent from the clients to the server. At some point, the client should be able to delete some of the old data in these 2 tables and have it stay on the server. The clients need to be able to work if they get disconnected from the server for some time and tables need to be updated at some point after reconnection.
I was thinking about going with MySQL replication but I don't think the client would be able to delete old data without effecting the server tables. I have looked at Microsoft sync framework as well, but I am not sure if that is ideal or would even work for my needs.
I don't know a lot about this subject so some direction would be appreciated.
Thank you,
Matt W
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我决定对服务器发送到客户端的数据使用 MySql 复制，因为每个数据库的数据都是相同的。对于客户端发送到服务器的表，我序列化表实体对象并将它们发送到服务器，服务器反序列化它们并将它们添加到数据库中。
I decided to go with MySql replication for the data the server sends to the clients since it is the same for every database. For the tables that the client sends to the server, I serialize the table entity objects and send them to the server which deserializes them and adds them to its database.