The Doctrine2 ORM integration offers several console commands under the

``doctrine`` namespace. To view the command list you canrun theconsole

without any arguments:

``doctrine`` namespace. To view the command list you canuse the``list``

command:

..code-block::bash

A list of available commands will print out, many of which start with the

commands (or any Symfony command) by running the ``help`` command. For example,

to get details about the ``doctrine:database:create``task, run:

A list of available commands will print out. You can find out more information

command. For example, to get details about the ``doctrine:database:create``

task, run:

..code-block::bash

* ``doctrine:query:dql`` and ``doctrine:query:sql`` - allow you to execute

DQL or SQL queries directly from the command line.

..note::

To be able to load data fixtures to your database, you will need to have

the DoctrineFixturesBundle bundle installed. To learn how to do it,

read the ":doc:`/bundles/DoctrineFixturesBundle/index`" entry of the

documentation.

..tip::

This page shows working with Doctrine within a controller. You may also

want to work with Doctrine elsewhere in your application. The

:method:`Symfony\\Bundle\\FrameworkBundle\\Controller\\Controller::getDoctrine`

method of the controller returns the ``doctrine`` service, you can work with

this in the same way elsewhere by injecting this into your own

services. See:doc:`/book/service_container` for more on creating

your own services.