RadhaKrishnaKiJaya
asked on
Need help with Link Query for left outer join
Hi Experts,
This is my LINQ query. Now my query is doing a inner join with _adhocInvoiceToRcid table. How can I do a left outer join. If arr.AdhocInvoiceRequestId is null still I sould be able to get that record.
Thanks in advance!!
This is my LINQ query. Now my query is doing a inner join with _adhocInvoiceToRcid table. How can I do a left outer join. If arr.AdhocInvoiceRequestId is null still I sould be able to get that record.
Thanks in advance!!
from a in _adhocInvoice.Table
join r in _reseller.Table on a.ResellerId equals r.ResellerId
join arr in _adhocInvoiceToRcid.Table on a.AdhocInvoiceRequestId equals arr.AdhocInvoiceRequestId
where a.DateResolved == null
select r
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.