Lazy-loading collections with restrictions in nHibernate

Question

I have two simple entities with one-to-many relationship:

public class Customer
{
    public int Id { get; private set; }
    public IList<Order> Orders { get; private set; }
}

public class Order
{
    public DateTime Date { get; set; }
}

Let's imagine, that there could be a lot of Orders for a particular Customer, and I want to see only last-month-orders.

Can I do this somehow if Orders property is lazy-loaded? I want something like:

var orders = customer.Orders.Where(x => x.Date > DateTime.Now.AddMonths(-1)).ToList();

but now nHibernate requests all the Orders on this line (SELECT * FROM Orders WHERE customerId='{0}'), and linq-restrictions are applied on the loaded data, but I want it to be applied to SQL (SELECT * FROM Orders WHERE customerId='{0}' AND date > '2011-07-31').

Is this achievable with nHibernate? Can Entity Framework do this?

hazzik · Accepted Answer · 2011-08-31 06:05:19Z

1

Is this achievable with nHibernate? Can Entity Framework do this?

Unfortunately no. NHibernate and EF cannot handle this situation.

answered Aug 31, 2011 at 6:05

hazzik

13.4k9 gold badges51 silver badges89 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Dima · Accepted Answer · 2011-08-31 05:07:16Z

1

Try NHibernate 3, linq support there is much better than in 2nd version. Otherwise you can make request using criterions syntax.

answered Aug 31, 2011 at 5:07

Dima

6,7414 gold badges26 silver badges43 bronze badges

1 Comment

Shaddix Over a year ago

I do use 3rd version. I can use criterions when doing request over the Session, but the question is about doing this with lazy-loaded collections.

Collectives™ on Stack Overflow

Lazy-loading collections with restrictions in nHibernate

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related