NHibernate Linq DateTime in Where-Clause not supported?

I try to use the fallowing query to g开发者_高级运维et all companies, which are created after a specific date:

return session.Query<Company>().Where(x => x.Created > value)

When I execute this, I always get a System.NotSupportedException. When I remove the Where(), it is working. I use NHibernate 3.0. Does Linq in NH3.0 not support such Where-clauses? How can I do this instead?

I have found the problem:

I have also a Skip() and a Take() used. This two has to be after the Where().

The problem is not NH3 supporting where with NH3 you should be using QueryOver and not Query. So it should be

return session.QueryOver<Company>().Where(right condn); 

whats the type of created in your query and i may be able to help

You can have the skip and take too that is totally fine.