views:

11

answers:

0

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.