Devart Forums

Posted: **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

Posted: **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

Devart Forums

DefaultIfEmpty doesn't work (OUTER JOIN)

DefaultIfEmpty doesn't work (OUTER JOIN)