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
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