Doctrine: cascade="remove" vs orphanRemoval=true

symfony doctrine cascade cascading-deletes
iiirxs picture iiirxs · Aug 26, 2014 · Viewed 24.3k times · Source

What is the difference between the 2 options above? When is it preferable to choose each option?

Answer

Serge Kvashnin picture Serge Kvashnin · Aug 27, 2014

The basic difference between them is:

When using the orphanRemoval=true option Doctrine makes the assumption that the entities are privately owned and will NOT be reused by other entities. If you neglect this assumption your entities will get deleted by Doctrine even if you assigned the orphaned entity to another one.

Say your User has one-to-many relation to Comment. If you are using cascade="remove", you can remove the reference for Comment from one User, and then attach that Comment to another User. When you persist them, they will be correctly saved. But if you are using orphanRemoval=true, even if you will remove given Comment from one User, and then attach to another User, this comment will be deleted during persist, because the reference has been deleted.

Related questions

cascade={"remove"} VS orphanRemoval=true VS ondelete="CASCADE

I tried to gather few information about those following way to delete automatically child entity when a parent entity is deleted. Seems that the most common way is to use one those three annotation: cascade={"remove"} OR orphanRemoval=true OR …

Read More
How do I delete an entity from symfony2

My first symfony2 project is a list of guests (invited in an event) stored in a database. I have created the entity class Guest with all variables for them (id, name, address, phone number etc.) created the schema in the …

Read More
How to encode Doctrine entities to JSON in Symfony 2.0 AJAX application?

I'm developing game app and using Symfony 2.0. I have many AJAX requests to the backend. And more responses is converting entity to JSON. For example: class DefaultController extends Controller { public function launchAction() { $user = $this->getDoctrine() ->getRepository('UserBundle:…

Read More