Linq syntax transfer

Question

Can someone help me transfer the logic below using linq, the entire syntax


SELECT CountOfColorValue, ColorTable*, IIf([CountOfColorValue]<7,"Invalid Color",[ColorCode]) AS COLOR STATUS
FROM  INNER JOIN ColorTable ON (ColorLocation=ColorLocation) AND (ColorPart=ColorPart) AND (ColorCode=ColorCode);