c# Entity Framework - linq to entity query with subquery

Question

If I have the following tables/entities:

Invoice
- InvoiceId (PK)
- InvoiceAmount

InvoicePayment
- InvoicePaymentId (PK)
- InvoiceId (FK)
- PaymentAmount

How can I construct a Linq to Entity query that selects invoices with an outstanding amount - bearing in mind that the existence of a payment does not indicate that the invoice does not have an outstanding amount (i.e. partial payment are possible).

undefined · Accepted Answer · 2012-04-05 23:38:11Z

1

I would go for something along the lines of this

from i in invoices
where i.Payments.Sum(p=>p.PaymentAmount) < i.InvoiceAmount
select i;

answered Apr 5, 2012 at 23:38

undefined

34.4k23 gold badges135 silver badges203 bronze badges

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

2 Comments

Rob Over a year ago

Thanks @Luke McGregor, I was applying too much thought to it and trying to to something with .any() which isn't necessary.

undefined Over a year ago

Nah you definitally want a sum here, You can do the same as this in full fluent syntax but i think it looks readable like it is

Collectives™ on Stack Overflow

c# Entity Framework - linq to entity query with subquery

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related