Linq to NHibernate - How to include parent object and only certain child objects

Posted by vakman on Stack Overflow See other posts from Stack Overflow or by vakman
Published on 2010-04-28T03:12:18Z Indexed on 2010/04/28 3:33 UTC
Read the original article Hit count: 234

Given a simplified model like the following:

public class Enquiry
{
    public virtual DateTime Created { get; set; }
    public virtual Sender Sender { get; set; }
}

public class Sender
{
    public virtual IList<Enquiry> Enquiries { get; set; }
}

How can you construct a Linq to Nhibernate query such that it gives you back a list of senders and their enquiries where the enquiries meet some criteria. I have tried something like this:

return session.Linq<Enquiry>()
   .Where(enquiry => enquiry.Created < DateTime.Now)
   .Select(enquiry => enquiry.Sender)

In this case I get an InvalidCastException saying you can't cast type Sender to type Enquiry.

Any pointers on how I can do this without using HQL?

© Stack Overflow or respective owner

Related posts about nhibernate

Related posts about linq-to-nhibernate