title: Return one-level result list from a join statement in EF
body: <p>I have the following simple join statement:</p>
  
  <pre><code>Dim result = (From PropertyDefinition In econtext.PropertyDefinitions
                Join ProductDef In econtext.ProductPropertyValues
                  On PropertyDefinition.PropertyDefID Equals ProductDef.ProductPropDefID
                Where ProductDef.ProductID = 1
                Select ProductDef,
                       PropertyDefinition.PropertyDefName,
                       PropertyDefinition.PropertyDefName2,
                       PropertyDefinition.PropertyDefIIsDeleted).list()
  </code></pre>
  
  <p>If i explicitly included all columns under <strong>ProductDef</strong> it works, and the result comes in one list, currently the result of <strong>ProductDef</strong> is coming in a separated list:</p>
  
  <p><img src="https://i.stack.imgur.com/Osj1A.jpg" alt="enter image description here"></p>
  
  <p>I need everything from <strong>ProductDef</strong> and some from <strong>PropertyDefinition</strong> but not in nested lists, </p>
  
  <p>How to get the result in one-shot list without the need to explicitly include all columns of <strong>ProductDef</strong>?</p>