I think you dont have to set the projection on the id.
2011/2/1, maumad <[email protected]>: > 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. > > -- Enviado desde mi dispositivo móvil -- 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.
