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.
