DefaultIfEmpty doesn't work (OUTER JOIN)

mars · Post by **mars** » Tue 14 Jul 2009 14:15

Hello,

I am using query

from c in model.Customers
join p in model.Orders on c.Customer_id equals p.Customer_id into inline
from i in inline.DefaultIfEmpty()
select new {c.Customer_id}

and get error

LINQ to Entities does not recognize the ... DefaultIfEmpty method ....

What's wrong with query?
How I can build 'OUTER JOIN' SQL query?

Thanks in advance

AndreyR · Post by **AndreyR** » Tue 14 Jul 2009 14:39

The DefaultIfEmpty method is not supported in LINQ to Entities.
The similar question was already discussed here:
http://www.devart.com/forums/viewtopic.php?p=43652