I am trying get a record updated from database with QueryOver. My code initially creates an entity and saves in database, then the same record is updated on database externally( from other program,...

I am trying to figure out how to best query in NHibernate so that the returned results are between for entries where todays time is >= PublishDateTime and <=ExpiryDateTime The expiry date can b...

I'm getting an intermittant problem with NHibernate where it generates a query for an entity, but replaces one of the columns with a column from completely different (and unrelated) entity. It on...

I'm trying to use the following statement to get an entity with the fields I'm after: retVal = session.CreateCriteria(typeof(MyEntity)) .CreateAlias("MyEntityProperty", "MyEntityProperty") .Add(...

I have a stored procedure in sql server 2008 R2 which was working fine, but suddenly it throws an exception of TimeOut Expiration. BmDaoSession.CreateSQLQuery("exec SP_Name @Param1 = '" + clientCo...

I'm refactoring old-style query CreateCriteria() to QueryOver(). My Wcf service gets string PropertyName to order queries results. For IQueryable I use Dynamic LINQ to do such ordering, for CreateC...

I have domain class location public abstract class BaseEntity<T> where T: struct { public virtual T Id { get; set; } public virtual bool Equals(BaseEntity<T> other) } public c...

I'm having a huge issue with nhibernate n+1 and nothing I try seems to fix the problem. Nhibernate profiler still shows n+1 selects hitting the database. Here's my model: public class CustomerGro...

I am trying to write QueryOver statement for selecting N rows in the descending time order. session.QueryOver<T>().Take(10).OrderBy(x=>x.DateInserted); Unfortunately this is not at all ...

Union with NHibernate and Criteria: Is it possible in Criteria or QueryOver? If not, is there any other way to achieve a union of two result within the same query?

Is it possible to obtain the sql that would be created by nhibernate in your code without actually running it? I have a complex criteria object that I have built through the criteria API. This cri...

nHibernate3; retrieving 4xxx records out of an EAV data schema. When nHibernate, or .NET, goes to initialize those collections for the first time, we're seeing a severe penalty. Subsequent calls ap...

If I search for NHibernate Criteria API query examples in internet there are examples that use Restrictions and others use Expression. What are the differences between those two? For example: pos...

I'm trying to do a like search against an integer column, what I need to do is actually cast the column to a varchar and then do the like search. Is this possible? what's the easiest way to do this...

I am new to NHibernate and I am trying to learn how to query my data. Below is the configuration xml. Only the recipe is shown. I want to be able to query recipes by recipetitle from keywords ent...