删除对象及其所有相关实体的实体框架 [英] 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?
推荐答案
您不应该在实体框架这样做。所有流行的关系数据库的支持 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屋!