Hi Jeff: Thanks for the response. Can I do it without join using the navigation property ?
–
DotnetSparrowApr 3 '11 at 9:26

@Sparrow: Sure it can be written without using join explicitly, though I don't know what you mean by the navigation property. I just saw "need this SQL-ish query converted to LINQ." I don't really have too much experience working with EF.
–
Jeff MercadoApr 3 '11 at 9:34

I mean because these two entities have related properties accountowners has account property and account has accountOwners property. they can access each others columns without join.
–
DotnetSparrowApr 3 '11 at 9:48

@Sparrow: That I didn't notice. However I think rewriting it to use that property may be pointless as the query provider will probably write it back to using a join anyway.
–
Jeff MercadoApr 3 '11 at 20:19