Entity Framework 4 Delete Object from entity collection

by

The answer depends on the way you modeled your entities. If you are using common independent relation or foreign key relation you will have to use your current approach – I’m using it as well in my project.

If you defined identifying relation you will be able to call just Clear on collection as @Craig described. Identifying relation is special relation where primary key of dependent entity contains foreign key of parent entity.

Example EF model

The example shows Order entity and OrderItem entity with foreign key identifying relation between them. Primary key of OrderItem consists of unique Id and OrderId which is FK of Order table. With this configuration you don’t need to iterate through OrderItems and delete each item separately. Simply removing OrderItem from collection will be executed as delete in database and clearing collection will delete all related OrderItems in database.

More Related Contents:

  1. LINQ to Entities case sensitive comparison
  2. Entity Framework 4 – AddObject vs Attach
  3. Entity Framework Join 3 Tables
  4. EF Including Other Entities (Generic Repository pattern)
  5. What are Independent Associations and Foreign Key Associations? [duplicate]
  6. Entity framework self referencing loop detected [duplicate]
  7. Entity Framework/Linq EXpression converting from string to int
  8. Why does the Contains() operator degrade Entity Framework’s performance so dramatically?
  9. Adding stored procedures complex types in Entity Framework
  10. Entity Framework Thread Safety
  11. The result of a query cannot be enumerated more than once
  12. Entity Framework/Linq to SQL: Skip & Take
  13. The object cannot be deleted because it was not found in the ObjectStateManager
  14. Entity Framework – Add Navigation Property Manually
  15. Entity Framework – Invalid Column Name ‘*_ID”
  16. Entity Framework creates a plural table name, but the view expects a singular table name?
  17. Entity Framework Include() is not working
  18. EF4 Code First: how to add a relationship without adding a navigation property
  19. String.Equals() not working as intended
  20. Entity Framework 4: How to find the primary key?
  21. How to Refresh DbContext
  22. Entity Framework Code First AddOrUpdate method insert Duplicate values
  23. Add the where clause dynamically in Entity Framework
  24. Entity Framework initialization is SLOW — what can I do to bootstrap it faster?
  25. Is it possible to prevent EntityFramework 4 from overwriting customized properties?
  26. Entity Framework Multiple Object Contexts
  27. The principal end of this association must be explicitly configured using either the relationship fluent API or data annotations
  28. What causes .Attach() to be slow in EF4?
  29. How to in-code supply the password to a connection string in an ADO.Net Entity Data Model
  30. Entity Framework – Eager loading of subclass related objects

Leave a Comment