EntityManager#remove() expects parameter 1 to be an entity object, array given. How to fix?

Question

symfony

The code :

public function deleteAction(Request $request, $id)
    {
        $form = $this->createDeleteForm($id);
        $form->handleRequest($request);

        if ($form->isValid()) {
            $em = $this->getDoctrine()->getManager();
            $entity = $em->getRepository('WindowsBundle:Category')->find($id);
            $query = $em->createQuery(
                'SELECT c.name FROM WindowsBundle:Category c
                WHERE c.id=:id')
                ->setParameter('id',$id);
            $entity_name = $query->getResult();
            $entity_product=$em->getRepository('WindowsBundle:Product')->findBy(array('category'=>$entity_name));

            if (!$entity ) {
                throw $this->createNotFoundException('Unable to find Category entity.');
            }
            $em->remove($entity);
            $em->flush();
            if($entity_product!==null)
            {
                $em->remove($entity_product);
                $em->flush();
            }
        }

I'm trying to delete a category (CategoryEntity) that is associated with (ProductEntity) If you just delete a category, then the object (ProductEntity) that requests data from CategoryEntity throws an error.
Therefore, I try to implement using this part and then delete it:

$query = $em->createQuery(
                'SELECT c.name FROM WindowsBundle:Category c
                WHERE c.id=:id')
                ->setParameter('id',$id);
            $entity_name = $query->getResult();
            $entity_product=$em->getRepository('WindowsBundle:Product')->findBy(array('category'=>$entity_name));

and then remove it here. But it says:
EntityManager#remove() expects parameter 1 to be an entity object, array given.
I will be very grateful for your help.

Answer 1

1. Why is the name property mapping not configured for the category?

$entity = $em->getRepository('WindowsBundle:Category')->find($id);

// Чтобы вместо этого
$query = $em->createQuery('SELECT c.name FROM WindowsBundle:Category c WHERE c.id=:id')
    ->setParameter('id',$id);
$entity_name = $query->getResult();

// ...писать просто
$entity_name = $entity->getName();

2. You get the Product array . So delete everything one by one:

$entity_product=$em->getRepository('WindowsBundle:Product')->findBy(array('category'=>$entity_name));
foreach ($entity_product as $product) {
    $em->remove($product);
}
$em->flush();