开发者

How to synchronise two Sql Compact edition databases via WCF (n-tier)

开发者 https://www.devze.com 2023-03-30 08:23 出处:网络
I have a situation that requires two SQL Compact edition databases to synchronise with each other using Microsoft Sync Framework in a C# 4 Winforms app, but I am struggling to find a way to get this t

I have a situation that requires two SQL Compact edition databases to synchronise with each other using Microsoft Sync Framework in a C# 4 Winforms app, but I am struggling to find a way to get this to happen.

I have it working easily enough in a 2 tier type scenario, with SqlCeSyncProvider connecting directly to the server database, but am unsure about how to go about getting that to happen over WCF.

The samples I have seen from Microsoft are basically delegating to a SqlSyncProvider inside the WCF service, but the SqlCeSyncProvider doesn't appear to expose the same methods as the ServerSyncProviderProxy.

I could use a SqlCeClientSyncProvider inside the service (which is referred to in this question: Using MS Sync Framework to synchronize two SQL CE Dbs), but SqlCeClientSyncProvider does not expose GetSchema or GetServerInfo methods. I don't know if I can safely ignore those methods or not.

Are people just exposing the SQLCe databases over the network and using SqlCeSyn开发者_开发问答cProvider or am I missing something that makes this work?


the SqlCeClientSyncProvider/SyncAgent combo doesnt support synching between SqlCe databases not unless you want to write your own DbServerSyncProvider that uses Sql Ce.

use SqlCeSyncProvider instead.

you can find a sample here: Database Sync: SQL Server and SQL Compact N-Tier with WCF

just modify it so both endpoints are Sql Ce

0

精彩评论

暂无评论...
验证码 换一张
取 消