Microsoft Sync Framework Filtering and Multiple Tables
Posted on 2013-05-25
I need to wirte an application to sync data from an SQL Server 2008 and an SQL Server Compact 3.5 database. The application will be written in VS VB 2008. I need to use parameterized filtering so only the data the mobile user needs will be synced. My problem is that I'm having a hard time wrapping my head around how to determine what tables will be added to each scope and how to design the scopes. What's giving me the most trouble is how to do a paramterized filter for a table that doesn't have the data that will determine what will be filtered. For example: our customer database is designed only with an identifier that joins it back to an address table for address information and the address table joins back to a zip code table to get the zip code information which contains the city and state, so for me to filter a customer by state I have to join it to 2 other tables. How do I design the scopes for this situation? Thanks for any help.