LinQ - 随笔分类 - ghelement

内连、左连、右连

摘要：//内连 from a in TableA join b in TableB on a.Id equals b.Id select new { aName=a.aName, bName=u.bName} //左连 from a in TableA join b in TableB on a.Id e 阅读全文

posted @ 2025-04-16 11:00 ghelement 阅读(26) 评论(0) 推荐(0)

linQ

摘要：//分组排序对应SQL partion by var REList = crList.OrderByDescending(x => x.dtTime).GroupBy(x => new { x.vcRobot })//可多列 .Select(g => new { g, count = g.Coun 阅读全文

posted @ 2023-07-25 14:29 ghelement 阅读(29) 评论(0) 推荐(0)

随笔分类 - LinQ