>Nope it's bidirectional you get a link to the parent in the child and an EntitySet<T> collection of children in the parent.
Ahh, this comment helped me see how to get the typed object collection I've been chasing with you for a few days.
At first I was getting anonymous type with this method:
var CustomerList = (from p in db.job_info
join c in db.customers on p.cust_num equals c.custno
where p.status == 'A'
orderby c.company
select new { custno = c.custno, c.company, c.phone, c.faxno }
).Distinct();
Then, I saw an example that used a subquery technique to get a typed collection of Customer objects:
var subq = (from p in db.job_info
where p.status == 'A'
orderby p.customer_source.company
select p.customer_source.custno).Distinct();
IQueryable<customer_source> CustomerList = from a in db.customers
where subq.Contains(a.custno)
select a;
NOW, I can do it all in one query by using the "link to the parent" property of the child:
IQueryable<customer_source> CustomerList = (from p in db.job_info
where p.status == 'A'
orderby p.customer_source.company
select p.customer_source <---- the magic occurs here
).Distinct();