There is now a an approach to do this, using Doctrine’s Criteria. A full example can be seen in How to use a findBy method with comparative criteria, but a brief answer follows. use \Doctrine\Common\Collections\Criteria; // Add a not equals parameter to your criteria $criteria = new Criteria(); $criteria->where(Criteria::expr()->neq(‘prize’, 200)); // Find all from the … Read more
Check the latest doctrine documentation Here is a summary : the list of possible generation strategies: AUTO (default): Tells Doctrine to pick the strategy that is preferred by the used database platform. The preferred strategies are IDENTITY for MySQL, SQLite and MsSQL and SEQUENCE for Oracle and PostgreSQL. This strategy provides full portability. SEQUENCE: Tells … Read more
DQL is easier to read as it is very similar to SQL. If you don’t need to change the query depending on a set of parameters this is probably the best choice. Query Builder is an api to construct queries, so it’s easier if you need to build a query dynamically like iterating over a … Read more
You can use: $comment->setArticle($em->getReference(‘Article’, 10));