Introducing FOREIGN KEY constraint may cause cycles or multiple cascade paths

All relationships in your model are required because all foreign key properties (CountryId, RegionId, CityId) are not nullable. For required one-to-many relationships EF will enable cascading delete by convention. Country and Region have multiple delete paths to the Store table, for example if you delete a Country the related Stores can be deleted via three … Read more