在实体框架中删除一个对象及其所有相关实体 [英] Delete an object and all of its related entities in Entity Framework

问题描述

有谁知道如何在不手动遍历对象图并删除每个对象的情况下删除 EF 中的对象及其所有相关实体?

Does anyone know how to delete an object and all of its related entities inside of EF without manually traversing the object graph and deleting each one?

例如，我有 SalesOrder 和 SalesOrderDetails，它们之间的关系是 1:N.当我删除 SalesOrder 时，我希望自动删除所有 SalesOrderDetails.

For example, I've got SalesOrder and SalesOrderDetails with a 1:N relationship between them. When I delete a SalesOrder, I want all SalesOrderDetails to be deleted automatically.

这在 EF 中可行吗?

Is this possible in EF?

推荐答案

你不应该在实体框架中这样做.所有流行的关系数据库都支持外键上的 ON CASCADE DELETE，这也更加高效.我建议你就这样吧.

You should not be doing this in the Entity Framework. All popular relational databases support ON CASCADE DELETE on foreign keys which is a lot more efficient as well. I suggest you just go with that.

这篇关于在实体框架中删除一个对象及其所有相关实体的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！