Sample Code to connect to the database with doctrine connection

ZF2_Doctrine.php

return  array (
    'Doctrine' => array (
        'Connection' => array (
            'Orm_ default ' => array (
                'DriverClass' => 'Doctrine\DBAL\Driver\PDOMySql\Driver' ,
                'Params' => array (
                    'Host'      => 'localhost' ,
                    'Port'      => '3306 ' ,
                    'User'      => 'root' ,
                    'Password' => '' ,
                    'Dbname'    => 'zf2essentials' ,
                    'DriverOptions' => array (
                        PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES 'UTF8' "
                    )
                )
            )
        )
    )
);