Linq - Boolean - where statement

Question

I have the below code which I am struggling with.

var q = from hed in cxt.SOPOrderReturns.ToExpandable()
        join cus in cxt.SLCustomerAccounts 
              on hed.CustomerID equals cus.SLCustomerAccountID
        join ad in cxt.SOPDocDelAddresses 
              on hed.SOPOrderReturnID equals ad.SOPOrderReturnID
        where hed.AnalysisCode1 == "SO"
        select new
        {
            hed.SOPOrderReturnID,
            hed.DocumentNo,
            hed.DocumentDate,
            cus.CustomerAccountNumber,
            Route = hed.AnalysisCode2,
            Drop = hed.AnalysisCode5,
            hed.ReadyForInvoicePrint,
        };

q = q.RemoveExpandable();

return q;

The column hed.ReadyForInvoicePrint is Boolean and I want to add a where statement which also shows if the column is FALSE.

Thanks

Jamie

Answer 1

You can filter on false value of this column by adding && !hed.ReadyForInvoicePrint to your where statement.