How to do a left outer join wtih an include in sub query?

Question

I have a table which I am querying via Entity Framework:

using (Entities context = new Entities())
{
    var customizations = context.Customizations.Include("aspnet_Users").ToList();
}

However, I want to included another table, "SelectedCustomizations" as a LEFT OUTER JOIN into the above query.

Any ideas?

Answer 1

I'd say you are doing something wrong. From your question it seems that you want to Join "aspnet_Users" table with Customizations and with SelectedCustomizations.

For that you better off with Join() method.

I'd suggest you to get Linqpad, it comes with loads of examples. Joins are covered too.

Answer 2

Hello,

Check out this resource: http://www.devart.com/forums/viewtopic.php?p=43652 The first post has two related resources for outer joins.