Symfony2 Custom Repository Class Example

Sysmfony2 customRepository

namespace Core\MainBundle\Entity;

use Doctrine\ORM\EntityRepository;
use Core\MainBundle\Entity\user;

class userRepository extends EntityRepository
{
    public function findUserByEmail($email, $password)
    {
        $query = $this->getEntityManager()
            ->createQuery('SELECT u FROM CoreMainBundle:user u  where u.email = :email and u.password = :password');
        $query->setParameter('email', $email);
        $query->setParameter('password', $password);
        return $query->getArrayResult();
    }



}