What is nhibernate queryover

Now, Intellisense tells me that there is no such thing as a FirstOrDefault method. I could, of course, enumerate my ordered query, and then use LINQ to get my item. But this would load all items into memory first. Is there an alternative to FirstOrDefault , or have I understood something completely wrong? You have to add the NHibernate. Linq namespace and then:. I have now found out that I could use the Take extension method on the IQueryOver instance, and only the enumerate to a list, like so:.

In this chapter, we will be covering QueryOver Queries. It is a new syntax which is more like LINQ using the method chain syntax as shown in the following query. As we have seen in the criteria query, the first name is just an opaque string, now we're actually using an x.

FirstName , so the first name gets refactored and renamed that gets changed in the link style criteria query using the query over. We can still do many similar things, but you cannot use the query comprehension syntax with query over, you have to use the method chain syntax and you can't mix and match the link and the criteria.

SetReadOnly true ;. Skip int firstResult. Take int maxResults. CacheMode CacheMode cacheMode. CacheRegion string cacheRegion. FindMemberExpression alias. Body ;. FindMemberProjection expression.

SetProjection projections. Select x ;. SetProjection projections ;. ProjectionList ;. ForProjection projection ;. SetResultTransformer resultTransformer ;. FindMemberExpression path. Body ,. Where withClause , joinType , entityName ;. InnerJoin ;. CreateAlias path , alias , joinType ;. CreateAlias path , alias , joinType , withClause ;. Add ExpressionProcessor. ProcessExpression expression ;. Add expression ;. Add Restrictions.