<?php

namespace DopMobile\AdsBundle\Entity;

use Doctrine\ORM\EntityRepository;

/**
 * DopMobile\AdsBundle\Entity\TbAdrequests
 * @entity(repositoryClass="DopMobile\AdsBundle\Entity\TbRequestRepository")
 */
class TbAdrequests
{
......
}


class TbRequestRepository extends EntityRepository
{
    public function getAllReqes()
    {
        return $this->_em->createQuery('SELECT u FROM DopMobile\AdsBundle\Entity\TbAdrequests u WHERE u.programId = "dd"')
                         ->getResult();
    }
}


////////////////////////////////
below is controller code:

use Doctrine\DBAL\Driver\PDOMySql;
use DopMobile\AdsBundle\Entity\TbAdrequests;

class GetAdsController extends Controller
{
	public function indexAction()
	{

		$reqs = $em->getRepository('DopMobile\AdsBundle\Entity\TbAdrequests')->getAllReqes();





////////////////////////////////////

# Doctrine Configuration
doctrine:
    dbal:
        default_connection: customer
        connections:
            default:
                driver:   %database_driver%
                host:     %database_host%
                dbname:   %database_name%
                user:     %database_user%
                password: %database_password%
                logging:  %kernel.debug%
            customer:
                driver:   %database_driver%
                host:     %database_host%
                dbname:   %database_name%
                user:     %database_user%
                password: %database_password%
                logging:  %kernel.debug%
    orm:
        auto_generate_proxy_classes: %kernel.debug%
        default_entity_manager: default
        default_connection: default
        entity_managers:
            default:
                mappings:
                    DopMobileAdsBundle: ~