RE: Dataset Merge substitue

From: Ilya Tumanov [MS] (ilyatum_at_online.microsoft.com)
Date: 06/07/04


Date: Mon, 07 Jun 2004 21:09:00 GMT

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=?=" <anonymous@discussions.microsoft.com>
> Subject: Dataset Merge substitue
> Date: Mon, 7 Jun 2004 08:31:14 -0700
> Lines: 6
> Message-ID: <8BE94FCA-C5C0-44AB-A538-67C593672527@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
>
> 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
>



Relevant Pages

  • Re: Asp.net 2.0 question.
    ... the only new features likely to have benefited you for that ... functionality were cut from ASP.NET 2.0 shortly after beta 1. ... > Is it going to be any different working with image into database in the ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Customer asks for database password & link in
    ... customer, instead say "That will cost you an additional $$$ for the ... additional functionality", or "We cannot do exactly what you have requested, ... Your license to them must have a limitation on what they can do with your ... > one of my programs which holds a large database. ...
    (microsoft.public.vb.general.discussion)
  • Re: Too many fields?
    ... my laptop in and have been trying to build a database to use. ... depreciation ratios, along with the phyiscal, functional and external ... In a relational database, you would rarely find a table with more than 20 ... easier functionality out of Access. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Migration Documents: Beta 2 to ASP.NET 2.0 Shipping Bits
    ... > SQL2000 and should just learn SQL2005 and now regret not starting when it was in beta. ... I have resisted using SQL 2005 because I'm quite happy with SQL 2000, ... >> Personalization database changed between Beta 2 and RTM, ... >> which address the schema changes for the membership db. ...
    (microsoft.public.dotnet.framework.aspnet)
  • NexusDB Database Engine ADO.Net data provider beta
    ... Nexus Database Systems is pleased to announce the availability of our ... ADO.Net data provider beta. ... server, royalty-free, high-speed C/S systems can be created, at a fraction ... Support for the IProvider interface is included. ...
    (borland.public.delphi.thirdpartytools.general)