Dataset Merge substitue

[JJ]

Hi,

I am calling a webservice to return a dataset thats been updated. Since Merge is not supported in the compact framework. What do you guys use instead in order to update the dataset on pocketpc ?

Thanks,
JJ

[Ilya Tumanov [MS]]

You can develop for CF V2 which has merge functionality. V2 beta will be
out very soon.

If you have to go with V1, you can do merging manually.

Basic idea is to check each record by locating its equivalent in another
DataSet using primary key.
For example, if record exists in the local copy, but not in the DataSet
from WS, record has been deleted from the database (or added to the local
copy).
If it's unchanged in a local copy, it should be deleted. If it has been
changed or added, your business logic should decide what to do with it.

Same should be done for records in WS DataSet.
If record present in the WS DataSet, but not in the local copy, it should
be added.

Matching records in a local copy should be updated (if unchanged) with the
data from WS DataSet.
If it has been changed locally, business logic should resolve this conflict.

Best regards,

Ilya

This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
> Thread-Topic: Dataset Merge substitue
> thread-index: AcRMpHgLr47q0LE6Ql+OwJB+dnEehQ==
> X-WN-Post: microsoft.public.dotnet.framework.compactframework
> From: "=?Utf-8?B?Sko=?=" <anon...@discussions.microsoft.com>
> Subject: Dataset Merge substitue
> Date: Mon, 7 Jun 2004 08:31:14 -0700
> Lines: 6
> Message-ID: <8BE94FCA-C5C0-44AB...@microsoft.com>
> MIME-Version: 1.0
> Content-Type: text/plain;
> charset="Utf-8"
> Content-Transfer-Encoding: 7bit
> X-Newsreader: Microsoft CDO for Windows 2000
> Content-Class: urn:content-classes:message
> Importance: normal
> Priority: normal
> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> Newsgroups: microsoft.public.dotnet.framework.compactframework
> Path: cpmsftngxa10.phx.gbl
> Xref: cpmsftngxa10.phx.gbl
microsoft.public.dotnet.framework.compactframework:54660
> NNTP-Posting-Host: tk2msftcmty1.phx.gbl 10.40.1.180
> X-Tomcat-NG: microsoft.public.dotnet.framework.compactframework