query = from
technologyCategory.Technology == 5
When I compile I receive the error message "The type of one of the expressions in the join clause is incorrect. Type inference failed in the call to 'Join'". The column technologyCategory.Category is actually technologyCategory.Category_ID but since it is an FK to category.ID EF makes it technologyCategory.Category. Also, I looked at the mappings in the .edmx file and they look correct. However, the one thing I did see is in the entity for table TechnologyCategory the column Category_ID has nothing in the Value/Property column and there is no way for me to set it.
Edited byRandomBenTuesday, January 19, 2010 6:01 PMcleaned up