>>
>>Maybe you'll need an anonymous object:
>>
>>

IQueryable<AreaEntity> query = from Area in this.ObjectContext.AreaEntitySet
>>                                           join Route in this.ObjectContext.RouteEntitySet on Area.are_rtefk equals Route.rte_pk
>>                                           select new{are_rtefk= Area._rtefk, rte_name = Route.rte_name};

(add other fields from Area as required)
>
>Thanks Viv,
>
>I tried that and got this error:
>
>

Cannot implicitly convert type 'System.Linq.IQueryable<AnonymousType#1>' to 'System.Linq.IQueryable<SamaanSystems.IBC.BusinessEF.AreaEntity>'. An explicit conversion exists (are you missing a cast?)

>
>One question,should Area and Route get the VS IDE formatting indicating they are defined objects/classes (light blue)? Or should they just be the normal black text?
>
>I am seriously leaning towards going back to using stored procedures and dumping the Entity Framework.

Hi Frank, I think using SP's is a no-brainer , no need to recompile when you change something, changes to the sort order etc etc... stored procs are the way forward IMHO