SyncFramework with SQL Server

Question

I have three tables in SQL Server 2008

Account
Case
CaseStatus

Table Case has a reference using column AccountId to AccountTable, and CaseStatus has a reference on caseId to table Case.

I need to sync these three table depending on AccountId(AccountTable). Please help me to write code (template) in Microsoft Sync Framework

stombeur · Accepted Answer · 2011-04-04 09:00:37Z

1

If I understand correctly, you want to use an AccountId selected on the client side to sync data from all three tables to the client, but limited to the AccountId.

Pass along the accountId as a parameter when filtering (see How to: Filter Data for Database Synchronization (SQL Server))

Next, you need to rewrite the filterclause with subselects to something like this, assuming you name your parameter 'AccountId':
Account table: side.AccountId = @AccountId
Case table: side.AccountId = @AccountId
CaseStatus table: side.CaseId in (Select CaseId from Case Where AccountId = @AccountId)

answered Apr 4, 2011 at 9:00

stombeur

2,67922 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

JuneT · Accepted Answer · 2011-04-03 10:26:58Z

0

are you filtering on AccountID?

you can set the FilterClause for the Case table to "side.AccountId in (Select AccountId from AccountTable)"

and for CaseStatus table to "side.CaseId in (Select CaseId from Case)"

answered Apr 3, 2011 at 10:26

JuneT

7,7802 gold badges17 silver badges14 bronze badges

3 Comments

Shankar Over a year ago

Hear I give only Account Id then depending on Account Id I have to retrieve data from all the three tables . Please help me

BoltClock Over a year ago

@Shankar: You already left a comment, why do you need to edit and paste your comment there?

JuneT Over a year ago

@Shankar - StephaneT's post should do the trick. you have to change the FilterClause for CaseStatus to query from the_tracking table though as the inner query will not pick up Delete's e.g : CaseStatus table: side.CaseId in (Select CaseId from Case_tracking Where AccountId = @AccountId)

Collectives™ on Stack Overflow

SyncFramework with SQL Server

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related