Using Sync Framework to sync individual rows

I have a requirement to sync remote databases to a central database, but the customer wants to be able to choose with rows of data is synched. For example, if there is a table with 5 rows, the user wants "checkbox functionality" to say only sync rows 1, 4, and 5.

I don't believe Sync Framework does this out of the box. I have only seen where the entire table is synched with a central database.

Is there a way to tell the Sync Framework to sync individual rows of a table?

Answers


There are ways to filter rows, this is built into all of the sync framework's SQL providers. This MSDN page covers filtering: http://msdn.microsoft.com/en-us/library/ff928701(v=sql.110).aspx.

If it will be as simple as a checkbox to turn rows on/off you can probably just add a bit/boolean field to the table and use that column in the filter clause. Otherwise, you can use data that is relevant to your application - such as the MSDN sample where only sales data for a particular region will be synced.


Need Your Help

Is it possible to get Android.mk or native source file from .apk file?

android security android-ndk decompiling native-code

It seems that it is quite easy to get Java source files from .apk file. But is it possible to get Android.mk or native source file from .apk file, by tools or tricky methods?

c++ Jobqueue: Is there a rule of thumb for the number of worker threads?

c++ multithreading queue jobs

I just implemented a very first simple multithreaded jobqueue in c++ and I thought (and read) that it's a good idea to use one worker thread for each hardware thread (in my case that would be 4).

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.