Link to home
Start Free TrialLog in
Avatar of RadhaKrishnaKiJaya
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!!


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

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of Dustin Saunders
Dustin Saunders
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial