Linq ve lambda Join/Where

Örnek sql ,

select t.name,c.name from table t

join chair c on c.id=t.id

where t.color!=’Black’;

•