I have an nHibernate query using Criteria, and I am trying to cast a string to bool in the query itself. I have 开发者_运维技巧done the same with casting a string to int, and that works well (the \"Da
I want to write the following query as a Hibernate Criteria query: select to_char(nvl(ol.updated_datetime, ol.created_datetime), \'dd/mm/yyyy\'), sum(discount_price)
I need to be able to do the following: Select * from Table1 left join Table2 on id1 = id2 AND i1 = ? Hibernate criteria doesn\'t allow be to specify the i1 = ? part.
I\'ve faced with a problem when querying with Hibernate Criteria in Grails. Take a look: def visitors = Client.withCriteria{
How to do either a HQL or a Criteria search (the latter is preferred) involving an enum that is used as flags. In other words, I have a persisted enum property that sto开发者_JAVA百科res some kind of
I am looking to do the following using an NHibernate Criteria Query I have \"Product\"s which has 0 to Many \"Media\"s
I want to query for a set of results based on the contents of a list, I\'ve managed to do this for a single i开发者_如何学Gonstance of the class Foo, but I\'m unsure how I would do this for a IList<
I\'m trying to figure out if there\'s a way I can do the following strictly using Criteria and DetachedCriteria via a subquery or some other way that is more optimal. NameGuidDto is nothing more than
I\'m having some trouble constructing the correct Criteria to do a particular query - after an afternoon of consultation with Professor Google, I\'m hoping that someone can point me in the right direc
I have 2 entities: public class Authority : Entity { [NotNull, NotEmpty] public virtual string Name { get; set; }