I have a simple one-to-many relationship between table Order and table Line. I want a query that reports each Order entity and the sum of the Line.Value field.
How can I write the following SQL using CreateCriteria: SELECTsa_bec_matricula.* FROMsa_bec_matricula INNER JOIN sa_matricula ON sa_bec_matricula.sa_mtc_num = sa_matricula.sa_mtc_num
My current project is using NHibernate 3.0b1 and the NHibernate.Linq.Query<T>() API. I\'m pretty fluent in LINQ, but I have absolutely no experience with HQL or the ICriteria API. One of my quer
Is it possible to create a anoynmous count with nhibernate? The below query throws the exception \"No column *\".
I have an entity where a composite id is used. I changed to code to make use of wrapping the composite id in a seperate key class. I expected that with Linq I could do a comparison on key object and w
I\'m stuck with a very simple criteria query problem: sess.createCriteria(user.class, \"user\") .user_c.add(Restrictions.eq(\"user.status\", 1))
OK, first my simple Domain Model is 2 classes with a one-to-many relationship, a simple Parent -> child relationship. A \'Tweet\' has one or more \'Votes\', but each Vote belongs to just one Tweets et
When you create a criteria, you can add Restrictions that apply to a property. There are 2 ways of creating a Restriction:
Let\'s say I have a Cat that has two properties: FavoriteKitten SecondFavoriteKitten These kittens are discriminated by their Rank.
While I have already solved this issue in a previous question using a native query. I am now wondering if it is possible to create a custom expression that is usable in a Criteria without using the wh
加载中,请稍侯......