EF框架+Lamada表达式（联合多表lamada表达式的用法）

有俩张表对应的EF框架的类Reviews和Commodity_Review，新建一个新的类，字段是联合俩张表后自己需要展示的字段ReviewsShow

IQueryable<ReviewsShow> resultList = Queryable.GroupJoin<Reviews, Commodity_Review, String, ReviewsShow>(db.DS_Reviews, db.DS_CommodityReview, r => r.CommentNumber, d => d.CommentID, (r, d) => new ReviewsShow
{
FeedbackSource = r.FeedbackSource,
RecordDate = r.RecordDate,
CustomName = r.CustomName,
Site = r.Site,
OrderNumber = r.OrderNumber,
C_ASIN = r.C_ASIN,
SKU = r.SKU,
Title = r.Title,
ChineseTitle = r.ChineseTitle,
Comment = d.Where(g => g.CommentID == r.CommentNumber).FirstOrDefault().Comment
});

上述结合了EF框架获取数据+Lamada表达式的运用。