I have a query which has an Order By clause. The generated SQL fro开发者_Go百科m NHibernate looks like
I want to do something like this... return GetSession() .ToPagedList<Employee>(page, pageSize, x=> x.SetFetchMode(DomainModelHelper.GetAssociationEntityNameAsPlural<Team>(), FetchMode
Using NHibernate I\'m trying to get obtain a list of B\'s where an IList property of B contains a specific instance of A.
What are the performance differences between the hql and criteriaApi and QueryOver? Are there any situations where one is faster or slower than the other?
I have the following two entities: public class Entity1 { public IList e2 { get; set; } }开发者_如何学Go
Assuming the following fictional layout Dealership has many Cars has a Manufacturer I want to write a query that says get me a Dealership with a Name of X and also get the Cars collection but use
I needed to filter a list of results using the combination of two properties. A plain SQL statement would look like this:
How should I go about writing a backwards like statement using NHibernate criteria? WHERE \'somestring\' LIKE [Property] + \'%\'
I have a person object, which can have unlimited number of first names.So the first names are another object.
I write same query with two approach by using NHibernate: 1- by using HQL like below public long RetrieveHQLCount<T>(string propertyName, object propertyValue)