Resolving Cyclical Reference in Referential Relationships
Since you are using SQL Server Compact Edition, which doesn't support triggers that could solve this issue, my recommendation is either:


write your own manual DELETE statements in the proper order, rather than use CASCADE
change the design
use Express / LocalDB instead of Compact Edition, which is extremely limited and has been deprecated