How to solve Introducing FOREIGN KEY constraint may cause cycles or multiple cascade paths. I was writing my Entity Framework 5 Code First data models one day when I received a dramatic sounding error Introducing FOREIGN KEY constraint FKdbo. Daysdbo. WeeksWeek. ID on table Days may cause cycles or multiple cascade paths. I was instructed to Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints. And then simply the message, Could not create constraint. So what happened with my Foreign Key that makes it cyclicFirst a spot of code that can nicely demonstrate this scenario public class Year. ID get set. Name get set. ICollectionlt Month Months get set. Month. public int ID get set. Name get set. Year Year get set. ICollectionlt Day Days get set. Day. public int ID get set. Unblocked Earn To Die 2012 Part 2 Hacked' title='Unblocked Earn To Die 2012 Part 2 Hacked' />Play free action games hacked and unblocked by RedAssedBaboon. Earn to die part 3. Earn to Die part 3 is one of those titles that you need to look at with complete admiration. It successfully manages to bring an out of this world. KEKY4F7DX2A.jpg' alt='Unblocked Earn To Die 2012 Part 2 Hacked' title='Unblocked Earn To Die 2012 Part 2 Hacked' />Happy Wheels game is a bloody physicsbased vehicle game. With a slightly different twist you will get a real sensation of the accident. It can happen to everyone. InformationWeek. com News, analysis and research for business technology professionals, plus peertopeer knowledge sharing. Engage with our community. Name get set. Month Month get set. Week Week get set. Free Download Deep Freeze For Windows 7 32 Bit Crack. Week. public int ID get set. Name get set. Year Year get set. ICollectionlt Day Days get set. So, lets explain this. A Year has Months and a Month has Days all is well at this point and it will build and generate all your tables happily. The problem comes when you add the highlighted parts to add Weeks into the data model. By making those Navigation Properties you have implicitly instructed EF Code First to create Foreign Key constraints for you and each of these will have cascading deletes on them. This means, upon deleting a Year, the database will cascade that delete to that Years Months and in turn those Months Days. This is to, quite rightly, hold referential integrity you will not have Yearless Months. Artisteer web design generator for Joomla templates, Wordpress themes, Drupal themes, Blogger templates and DNN skins. Unblocked Earn To Die 2012 Part 2 Hacked' title='Unblocked Earn To Die 2012 Part 2 Hacked' />So if you think about it, now that we have added a Week entity that also has a relationship with Days this too will cascade deletes. So as well as the cascading deletes that occur when you delete a Year as I described above, now deleting a Year will also delete its Weeks and those Weeks will delete the Days. But those Days would have already been deleted by the cascade that went via Months. So who wins Who gets there first Dont know. Removing the multiple cascade paths. The way I found to solve this issue is you need to remove one of the cascades, since there is nothing wrong with the Foreign Keys, it is only the multiple cascade paths. So lets remove the cascading delete on the Week Days relationship since that delete will be taken care of by each Month cascading its deletes to their Days. Calender. Context Db. Context. public Db. Setlt Year Years get set. Db. Setlt Month Months get set. Db. Setlt Day Days get set. Db. Setlt Week Weeks get set. On. Model. CreatingDb. Model. Builder model. Builder. model. Builder. Entitylt Day. Has. Requiredd d. Week. With. Manyw w. Days. Will. Cascade. On. Deletefalse. On. Model. Creatingmodel. Builder. If you already have a Foreign. Key field explicitly written into your code model as I usually do I removed them from the above example for clarity you will need to specify this existing Foreign Key in the code just written. So if your Day entity looked like this public class Day. ID get set. Name get set. Yum Group Install Gnome Desktop Environment No Packages Were Found here. Foreign. KeyMonth. Month. ID get set. Month Month get set. Foreign. KeyWeek. Week. ID get set. Week Week get set. You will need your On. Model. Creating method to look like this model. Builder. Entitylt Day. Has. Requiredd d. Week. With. Manyw w. Days. Has. Foreign. Keyd d. Week. ID. Will. Cascade. On.