CODEWITHSUNDEEP
.netmicrosoft-sync-frameworkdata-synchronization
gyozo kudor
gyozo kudor

Reputation: 6336

How do I specify table order with sync framework when using sync orchestrator

I'm using sync framework with SyncOrchestrator and SqlSyncProvider. My problem is that the updates are applied in the incorrect order. I have a many to many relationship. Let's say I have 3 tables Students Courses StudentsCourses, it first tries to insert rows into the 3rd table StudentsCourses even if the student doesn't exist. It should do an insert for a student (or course) first and then an insert into studentsCourses. How can I do that. Thanks.

Upvotes: 0

Views: 191

Answers (1)

JuneT
JuneT

Reputation: 7860

the order in which tables are synched is the order in which they were added to the scope.

in your case, you should add Students, Courses and StudentsCourses in that order to the scope.

Upvotes: 2

Related Questions