I have the following prefetch path statement:
ppe01.SubPath.Add(CgmBanEntity.PrefetchPathInvoices,5,null,null,new SortExpression(InvoiceFields.BillYyyymm|SortOperator.Descending));
The important point is that I am trying to sort on InvoiceFields.BillYyyyMm descending
and then return the first 5 items from that list for each parent entity (CgmBanEntity).
Instead it seems I am getting the first 5 items from the list for each parent those 5 are then sorted in descending sequence on this field.
I haven't put together a test case yet, I first wanted to check that my expectation is the way it should work, sort first then limit the list.
LlblGen 4.1 OrmSupprtClass v4.1.13.206
(If I do need a repro case, do we use adventure works?)