linq to entites left outer join

Posted by parminder on Stack Overflow See other posts from Stack Overflow or by parminder
Published on 2010-02-01T05:01:42Z Indexed on 2010/04/20 13:03 UTC
Read the original article Hit count: 257

Filed under:
|
|

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

© Stack Overflow or respective owner

Related posts about linq-to-entities

Related posts about left-join