在连接LINQ中的三个表时,我正在尝试做一个groupby。下面是我的代码。任何关于如何做到这一点的建议都将是一个很大的帮助。
var result = (from cm in DB.BRAND_NAME_MAP_COMMENTs
join R in DB.BRAND_NAME_MAP_MASTERs on cm.BRAND_NAME_MAP_ID equals R.BRAND_NAME_MAP_ID
join K in DB.V_BRANDNAME_INGREDIENT_MAPs on R.BRAND_NAME_MAP_ID equals K.BRAND_NAME_MAP_ID
orderby cm.UPDATED_TS descending
group K.PFC_DESC by K.RAND_NAME_MAP_ID into L //this where the problem is
select new WorkflowComment
{
NAMEVersion = L.PFC_DESC + "-" + K.PFC_VERSION,
BRAND_NAME = R.BRAND_NAME,
HC_BRAND_NAME = R.HC_BRAND_NAME,
NAME = K.PFC_DESC,
//VERSION = K.PFC_VERSION,
COMMENTS = cm.COMMENTS.Replace("\n", "<br />"),
UPDATED_BY = cm.UPDATED_BY,
UPDATED_TS = cm.UPDATED_TS
}).ToList();
发布于 2018-06-06 04:12:34
如果你阅读了下面的链接,我只是想确认一下:LINQ: combining join and group by
我觉得这和你面临的问题是一样的。
https://stackoverflow.com/questions/50706996
复制相似问题