Top "Criteria" questions

Customizing Hibernate Criteria - Adding conditions to a left join

I need to be able to do the following: Select * from Table1 left join Table2 on id1 = id2 AND i1 = ? …

hibernate join criteria

Hibernate Criteria Projection

Well as the question title says, I am trying to make a projection criteria querying only couple of the table …

java hibernate criteria hibernate-criteria restrictions

NHibernate Criteria Query - Select Distinct

I have a Person entity belongs to a person has a Country, I want to select all the distinct countries …

nhibernate criteria icriteria

How to compile Propel Criteria to SQL

How can I compile Propel Criteria to clear SQL? I've tried $criteria->toString(); but this is not I expected. …

php sql criteria propel

Criteria join with projection

I am going to create this SQL query's Criteria equivalent: SQL: SELECT orders.id, book.title, orderitem.quantity FROM orderitem …

hibernate criteria nhibernate-criteria

Hibernate Criteria / Query on object properties

I have a class AppUser; class AppUser { private String firstName; private String lastName; //-- getters and setters } I also have …

java hibernate criteria

Case-insensitive ordering using Hibernate Criteria

I have a query created with Hibernate Criteria like this: Criteria criteria = db.getSession().createCriteria(Vendor.class); criteria.addOrder(Property.…

java hibernate sorting criteria case-insensitive

NHibernate HQL vs CriteriaAPI vs QueryOver vs Linq. Performance

What are the performance differences between the hql and criteriaApi and QueryOver? Are there any situations where one is faster …

performance nhibernate criteria icriteria

How to get the resultant array from a Mongoid::Criteria without an "each" block

Our application uses ajax very heavily and as a result of this we have statements like var items = #{@items.to_…

arrays mongoid criteria

ResultTransformer in Hibernate return null

I'm using ResultTransformer to select only particular properties from entity, just i don't need all properties from entity. But the …

java hibernate criteria resulttransformer