Cool, looks like your coming along nicely on this.
>
>>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();