WCF Sync with out a primary identity column

I am doing an application in which I have some Windows Mobile devices which will synchronize with main database (Server) once a day using WCF Sync. For most of the tables in the client, the data is coming from the server, and later on only updates on those rows will be synchronized with the server.

Now the problem I'm facing is that I have a table in which data will be added throughout the day on each client database. But with those new rows on each client databases I have not been able to synchronize, because the primary key identity fields are going to be same on each client table. When they are synchronizing it will be fine for the first client, but what about the second device? Can anyone please help me to sort out this issue?

Answers


This is only true if your Identities are sequential integers.

If you make your ID field a GUID, then you won't have this problem.


Need Your Help

magento join table collection

join magento-1.5 magento

I'm customizing Magento FAQ extension for sort faq items by category.below collection is

Problem logging errors with Python's logging module

python logging error-handling error-logging

I'm logging an error with python's logging module. I made a logger object inside my class, as follows:

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.