hello, I am using the Orcas march CTP and Linq I have a problem with join between 2 tables let's say I have these tables : BaseProduct ProductID Code etc... AND Asset AssetID Code etc... While "code" is not considered as a primary key I coded this linq query : var query = from p in context.BaseProducts join a in context.Assets on p.Code equals a.Code where a.Code == "PRODSFJSDFJ0450" and when I look to the sql query executed, Linq doesn't generate a standard "inner join"
Read More...