Hello,
I have this simple class:
public class SomeClass
{
public Int32 Id { get; set; }
public SomeClass Parent { get; set; }
public ISet<SomeClass> Children { get; set; }
}
As you can see, it maps a simple table which is related with itself,
recursively. All mappings are fine.
Now, I want to list all records that have children; with HQL, it is
pretty easy:
var l1 = session.CreateQuery("from SomeClass sc where sc.Children.size
> 0").List<SomeClass>();
How would I do this with the Criteria API? And what about LINQ to
NHibernate? The following both fail:
var l2 = session.CreateCriteria<SomeClass>("p").Add
(NHibernate.Criterion.Expression.Gt("p.Children.Count",
"0")).List<SomeClass>();
var l3 = (from l in session.Linq<SomeClass>() where l.Children.Count >
0 select l).ToList();
var l4 = session.Linq<SomeClass>().Where(l => l.Children.Count >
0).ToList();
Can you help?
Thanks,
Ricardo Peres
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"nhusers" 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/nhusers?hl=en
-~----------~----~----~----~------~----~------~--~---
