有谁知道如何在不手动遍历对象图并删除每个对象的情况下删除 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.
更多推荐
在实体框架中删除一个对象及其所有相关实体
发布评论