LINQ to Entities how to return all records from the Parent table?

Answer 1

from entity in MyContext.EntityType.Include("ChildEntitiesNavigationPropertyName")
select entity;

This returns all instances of EntityType, plus ChildEntitiesNavigationPropertyName when/if it exists. For tabular form use an anonymous type:

from entity in MyContext.EntityType.Include("ChildEntitiesNavigationPropertyName")
select new {ParentProperty = entity.ParentProperty, 
            ChildProperty  = entity.ChildEntitiesNavigationPropertyName.ChildProperty};

For a 1..* property:

from entity in MyContext.EntityType.Include("ChildEntitiesNavigationPropertyName")
from child in entity.ChildEntitiesNavigationPropertyName.DefaultIfEmpty()
select new {ParentProperty = entity.ParentProperty, 
            ChildProperty  = child.ChildProperty};

Answer 2

I'm pretty sure you can select from employees and then do a left join in LINQ, something like this (I don't have VS on this machine):

var results = from e in dbContext.Employees join s in dbContext.Sales on e.EmployeeID equals s.EmployeeID select new { e, s };

You may want to select the columns you just want. Hope it gives you the results you want.