Try peeking at the generated query using NHibernate Profiler. On 1 Lut, 04:27, maumad <[email protected]> wrote: > I am trying to get very simple query working. It does not throw but > returns empty list. Here is the query: > > using (var session = > ActiveRecordContext.Instance.SessionFactory.OpenSession()) > { > var query1 = session.CreateCriteria<ModuleData>(); > query1.SetProjection(Projections.Property("Id")); > query1.Add(Expression.Ge("Id", 0)); > var list = query1.List<ModuleData>(); > } > > If I write HqlBasedQuery it works fine: > > var query = new HqlBasedQuery(typeof(ModuleData), > QueryLanguage.Sql, > @"SELECT Id > FROM `aviprod`.`ModuleData` > WHERE Id > '0'"); > > Any pointers?
-- You received this message because you are subscribed to the Google Groups "Castle Project Users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/castle-project-users?hl=en.
