Inner Join 在Linq中的写法如下: [csharp] view plain copy var results = from f in db.Farms join fc in db.FarmCategories on f.FarmId equals fc.FarmId where f.FarmId.Equals(2) select f; Left Join 在Linq中的写法如下,后面使用 DefaultIfEmpty() [csharp] view plain copy var results = from f in db.Farms join fc in db.FarmCategories.DefaultIfEmpty() on f.FarmId equals fc.FarmId where f.FarmId.Equals(2) select f; http://blog.youkuaiyun.com/keepitshortandsimple/article/details/6874105