Hi,

I want to get one specific "Parent" from a table, and his "children". The children must be ordered by "year". The next statement gives a runtime exception: "Expression must be a MemberExpression"

 ParentEntity myParent = metaData.Parent
      .Where(p => p.Id == Id)
      .WithPath(  gp => gp.Prefetch(o => o.Children.OrderBy(ob => ob.Year)  ))
      .First<ParentEntity>();

I can't see anything wrong ?

Leon

The PrefetchPath should be applied on an IQueryable, so "select" before adding the prefetchPath. As in here:

var q = (from c in metaData.Customer
         where c.Country == "Germany"
         select c).WithPath(...

Walaa,

Using of generic prefetch<ChildEntity> did the trick

ParentEntity parent = metaData.Parent
                .Where(p => p.Id == Id)
                .WithPath(gp => gp.Prefetch<ChildEntity>(o => o.Children)
                                  .OrderBy(ob => ob.AanlegJaar)
                               )
                .First<ParentEntity>();

Greatings

Leon