I have a raw query in Symfony2

```
$sql = "SELECT * FROM Content
    JOIN ContentLearningAreas ON Content.id = ContentLearningAreas.content_id
    JOIN LearningArea ON ContentLearningAreas.learning_area_id = LearningArea.id
    WHERE ContentLearningAreas.learning_area_id = {$id} AND Content.active = 1";

$stmt = $this->getEntityManager()->getConnection()->prepare($sql);

$stmt->execute();

return $stmt->fetchAll();

```

This works fine, but I wish to cast the results to Content Entities so that their functions still work.

```
Jake\NameOfBundle\Entity\Content

```

How can this be done?

**EDIT**

It appears that this is using PDO and not Doctrine or Symfony2.