tags:

views:

143

answers:

1
Q: 

Performing Left Joins in ADO.NET Entity Framework

Pre .NET 4.0 - the EF does not support the DefaultIfEmpty() clause. Is there a better way of performing a left join on a query?

A: 

Yes, just don't use the join syntax at all. It's almost never correct to use join in LINQ to Entities (or LINQ to SQL). Use associations instead.

Craig Stuntz  2010-02-23 21:24:43

related questions

Linq to Entities and concatenated properties
Entity framework: One big model or a set of smaller models?
LinqToEntities not retrieving child objects of an entity
Entity Framework & LINQ To SQL - Conflict of interest?
How do I put business logic in my ADO.NET Entity Framework classes?
How do I extend ADO.NET Entity Framework objects with partial classes?
How do I use LINQ to Entities in Visual Basic?
How to check for the presence of an OrderBy in a ObjectQuery<T> expression tree
Linq to Entities with WCF
Filter EntityDataSource on Association value
Persistence framework?
Entity framework and queries' SQL logging
Best Practices for Entity Framework and ASP.NET
Using Linq with WCF
Has anyone used lucene.net with Linq-to-Entities?
Is there a DataContext in LINQ-to-Entities (NOT Linq-to-SQL)?
SQL tracing LINQ to Entities
How to do a "where in values" in LINQ-to-Entities
Linq to Entity with multiple left outer joins
How to Implement Database Independence with Entity Framework
Why all the Linq To Entities Hate?
How to implement Repository pattern withe LinqToEntities?
Linq to Entities vs ESQL
Learning about LINQ
Expression.Invoke in Entity Framework?