如何停止“级联删除”免遭实体框架默默删除？
我的数据库中有一个级联删除集。我还为我的EDMX模型中的对应关系设置了级联删除。
但是，如果我从 EDMX 中删除具有关系的表，然后通过“从数据库更新模型”将它们添加回来 - 级联已被删除。
Craig Stuntz 提出相关问题表明这是一个功能，但是如果每次我更新模型时我的级联都会被悄悄删除 - 这是行不通的。
也许我需要更改我的工作流程，而不是删除并重新添加 EDMX 中的表，而只是手动进行所有小的单独列更改？
I have a cascade delete set in my database. I have also set a cascade delete for the corresponding relationship in my EDMX model.
However if I delete the tables with the relationship from the EDMX and then add them back in through "Update Model From Database" - the cascade has been removed.
Craig Stuntz in a related question suggests that it is a feature, however if my cascades are being silently removed each time I do an update of the model - that's unworkable.
Perhaps I need to change my workflow and not delete and re-add tables in the EDMX, rather just make all the little individual column changes by hand?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
如果您从模型中删除任何内容，您也会删除所有更改。您的更改已消失，EDMX 不再了解它们。再次添加表后，您还必须再次进行所有更改。
如果您想保留更改，请不要删除实体，而是直接运行向导。它应该只更新现有实体而不删除大部分更改。我只知道这不起作用并且您的更改丢失并且与重命名某些导航属性相关的单个示例。
If you delete anything from your model you also delete all your changes. Your changes are gone and EDMX doesn't know about them any more. Once you add tables again you must do all your changes again as well.
If you want to keep your changes don't delete your entities and instead run wizard directly. It should just update existing entities without removing most of your changes. I'm aware only about single example where this doesn't work and your changes are lost and that relates to renaming some navigation properties.