tags:

views:

225

answers:

0
+1  Q: 

Linq to Entities Multiple left outer Joins in VB.NET

I am using Linq to entities which does not allow the .DefaultIfEmpty method. I need to know how to preform the following Multiple left outer join using Linq to Entities in VB.net

select * from capitalrequests cr 
left outer join capitalrequestquotes crq on cr.ID = crq.CapitalRequestID 
left outer join la_vendor lv on crq.vendorid = lv.id where cr.id='84D6A08D-5D59-47F9-BF0C-F41F9F5A6FF9'

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?