Not able to understand how to pass filter parameter from Client Side ConfigureLocalSqlSyncProvider.
Firstly i am able to create Template and scope on server.
I am having difficulty over her
private SqlSyncProvider ConfigureLocalSqlSyncProvider()
{
SqlSyncProvider provider = new SqlSyncProvider();
DbSyncScopeDescription scopeDesc = SqlSyncDescriptionBuilder.GetDescriptionForScope("sales", new SqlConnection(serverCon));
SqlSyncScopeProvisioning serverConfig = new SqlSyncScopeProvisioning(new SqlConnection(localCon), scopeDesc);
serverConfig.ObjectSchema = "dbo";
If i Uncomment below line to pass parameter its giving error
The current operation could not be completed because the database is not provisioned for sync or you not have permissions to the sync configuration tables.
//serverConfig.PopulateFromTemplate("sales", "Orders_OriginState_Filter_template");
//serverConfig.Tables["order_details"].FilterParameters["order_id"].Value = 4;
serverConfig.Apply();
return Provide;
}
I am aware that i am trying to pass filter parameter before provisioning the scope @ local(Client Side).
How should i approch this issue do i need to create scope in client side and later apply filtering condition at the time of synchronisation?
Thnaks
lavanyar
