I am using Microsoft Sync Framework 2.1 with SqlServerCE. I have a main table with a child table linked by a foriegn key. When I delete the main table entry, it fails since there are items in the child table (which have also been deleted.)
How do I tell Sync what order to delete rows from tables in?