Hello,
I am learning the ropes of Microsoft Sync Framework, and have a question.
For the sake of simplicity, let's say I have a table called [Project] in SQL Server with the following structure:
[Project].[ProjectId] (PK, UID) [Project].[Name] (varchar) [Project].[Leader] (varchar)
I create an Scope called 'filtered_project', which then I add the following filter:
sqlSyncScopeProvisioning.Tables["Project"].AddFilterColumn("Leader"); sqlSyncScopeProvisioning.Tables["Project"].FilterClause = "[side].[Leader] = 'John Smith'";
So far this Scope works just great. It successfully synchronizes all projects in the table whose leader is "John Smith". However let's suppose now I want to synchronize all projects whose leader is "Mary Sue", and then "Dave Roberts", and so forth.
Do I need to create a scope for each one of my 500 project leaders in the corporation? Can't I modify the existing one (filtered_project) so it filters by different leaders by demand?
I tried to modify the FilterClause of an existing Scope, but it didn't work. I had to destroy and then re-create the scope in order to get it reflecting the current FilterClause. This could be cumbersome, since there is no way the framework can manage existing Scopes.
Thanks.