Filter based downloading RRS feed

  • Question

  • 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