Retrieve invoice details when retrieving invoices

Question

I've got this simple LINQ to CRM query:

//retrieve all invoices associated to the cycle...
List<Invoice> invoiceCycleInvoices = ctx.InvoiceSet.Where(x => x.new_invoice_cycle_invoicesid.Id == invoiceCycle.Id
    && x.new_erpsync == false
    && x.StateCode != InvoiceState.Canceled).ToList();

Usually, a ToList call pulls all the relevant information that lazy loading forgets, but there is this property called invoice_details in Invoice that's always null.

How do I get it populated in one fell swoop ?

The `invoice_details` is a child? – Mike Perrenoud Jul 05 '16 at 21:08 — Mike Perrenoud, Jul 05 '16 at 21:08
Yes, sorry. Edited the question to clear that up. – Francis Ducharme Jul 05 '16 at 21:09 — Francis Ducharme, Jul 05 '16 at 21:09

score 1 · Accepted Answer · answered Jul 05 '16 at 21:36

1

Access entity relationships using LoadProperty.

foreach (var invoice in invoiceCycleInvoices)
{
    ctx.LoadProperty(invoice, "invoice_details");
    var invoiceDetail = invoice.GetRelatedEntity<Entity>("invoice_details");
}

answered Jul 05 '16 at 21:36

dynamicallyCRM

2,980
11
16

score 0 · Answer 2 · answered Jul 05 '16 at 21:09

It should be:

List<Invoice> invoiceCycleInvoices = ctx.InvoiceSet
    .Where(x => x.new_invoice_cycle_invoicesid.Id == invoiceCycle.Id
        && x.new_erpsync == false
        && x.StateCode != InvoiceState.Canceled)
    .Include(x => x.invoice_details)
    .ToList();

Retrieve invoice details when retrieving invoices

2 Answers2