linq to entites left outer join
- by parminder
I am struggling linq to entities left outer join. I have two entities (tables):
Listings
{
ListingID,
MakeID (nullable)
}
Makes
{
MakeID,
Description
}
I want to write something like this in LINQ:
select listings.listingID
,listings.makeid
, IsNull(makes.Description, 'NA')
from listings
left outer join makes
on listings.makeid = makes.makeid