Many to Many relationship in EF

Answer 1

Extrapolating from your description, and if a select is what you're looking for, something along those lines could work :

var query = from o in context.Order
                             .Include("OrderDetails")
                             .Include("OrderDetails.Product")
            select o;

you can then access the information through navigation properties, such as:

// using first here just for exemple purpose.
Order o = query.First();
var details = o.OrderDetails;
var aProductName = o.OrderDetails.First().ProductName;