LINQ for LS Problems

 I am having a problem with LINQ, to be honest I am not sure if this is a limitation of LINQ in general, and limitation of LINQ for LS, or I am just doing something really stupid. I suspect the last, but would just like a confirmation.

If I use the following LINQ command:

var lst = from i in uow.Invoices
             join d in uow.InvoiceDetails on i.Id equals d.InvoiceId
             where i.InvoiceNo > 1000
             where d.AmountPaid == 0
             select new InvoiceSummary
                                {
                                    InvoiceId = i.Id,
                                    InvoiceNo = i.InvoiceNo,
                                    AmountPaid = d.AmountPaid
                                };

Even though there are matchicn records in the tables, I always get no rows returned. But if I removre the second where, i.e. where on the joined table, I get all the rows.

So what I need to know, is am I not supposed to be able to filter based on fields in both tables, or am I doing something wrong?

Thanks

You should be able to filter based on fields in both tables.  I've just run a quick test with a query that looks equivalent to yours and it is working correctly for me -- I get rows returned even with both where clauses.  But I can't see any difference between your query and mine (except of course that I am using different classes) so I don't think you are doing anything wrong.

If you are on an older build it may be worth testing your query with a recent nightly.