>Hi all just playing around with LINQ and EF and need some help with what I think is a pretty simple query
>
>

>
>int InvoiceAmount = 1000000;
>
>var results =
>                 from cl in Context.clients.ToList().Distinct()
>                 from inv in cl.invoices.ToList().Where(x => x.invoiceamount >= InvoiceAmount)
>                 where cl.id == inv.clientid
>                 select cl;
>

>

I don't think you need the cl.Invoices, just Invoices.