Transferring Data Between Server and Client (Mobile)

Asked
Viewd249

1

Scenario:

  • Client (Mobile) - .Net CF 2.0, SQL CE 3.0
  • Server - .Net 2.0, SQL Server 2005, Web Service
  • Client and Server database schemas differ. From server - only certain columns from certain tables need to be synced. From client - everything will need to be synced once client has made changes.

Client will continually poll a web service to download and upload data. A framework will be developed to package and unpackage data, used by both client and server.

How would you develop the packaging and unpackaging? Use datasets, serialise strongly typed objects? All suggestions welcome.

Thanks

2 个答案

0

黑森州很棒,不仅存在 for c#

0

SQL合并复制是否是一个选项?您可以在服务器上配置发布,以过滤出客户端上所需的列(和行)。

如果这不是一个选择,答案实际上取决于数据。它多久更改一次?它如何变化?您主要从服务器获得插入吗?还是大部分是更新?有删除吗?