sql server ce - Microsoft Sync Framework error deleting foreign key linked tables -
i using microsoft sync framework 2.1 sqlserverce. have main table child table linked foriegn key. when delete main table entry, fails since there items in child table (which have been deleted.)
how tell sync order delete rows tables in?
the order in syncing tables matters. when dealing parent/child relationships must make sure specify child elements first , parents. project implemented sync framework, had child , parent table each in own syncscope, , had child scope done before parent scope since having 2 tables in ordered correctly in same scope did not seem guarantee order.
Comments
Post a Comment