Linq-Entities return null if non existent
LINQ
1
Posts
1
Posters
0
Views
1
Watching
-
i have a query like: var z = from a in ab.apple from b in ab.banana from c in ab.cherry where a.color==b.color &&..........&&... select new { a.color, b.color..........}; what i want is that if the table banana is empty, then instead of returning 0 results, the query return values where b.___ are set to null and all others are populated. this is what happens in E-SQL with eager loading could anyone tell how i could achieve that or how can i explicity define the type of join i want to use in linq-entities? Thanks