Filter based downloading

• Question

• 

  

  0

  Sign in to vote

  I am using "SqlSyncProvider" and only DownloadOnly synchronization. I am using filterclause to restrict the change selection.

  Following is the issue I am facing:

  1. My filter clause downloads only those records whose POStatus = 'A' (Active). This works fine however If the status is changed on the server I need to remove them from the client. The only solution I can see as of now is don't place the filter on original selection, and then use DELETE statement. However this  is going to hit big performance issue since I have millions of records on server.

  Is there any other feasible solution for this? I mean if the particular fields value equal to the parameter value mark it delete on client?

   

   

   

  Friday, October 1, 2010 11:33 AM