首页 > 其他 > 详细

Linq 将两个查询结果合称为一个

时间:2019-09-18 17:04:12      阅读:94      评论:0      收藏:0      [点我收藏+]
 1       var handsonitems = from a in db.DltQuestionHandson
 2                                join c in db.DltBdChapter
 3                                on new { a.ChapterCode } equals new { c.ChapterCode }
 4                                select new
 5                                {
 6                                    a.PlantCode,
 7                                    c.ChapterCode,
 8                                    c.ChapterKnowledge,
 9                                    a.OrgSkillId,
10                                    c.SkillCode
11                                };
12             var Jobevalitems = from a in db.DltQuestionJobeval
13                                join c in db.DltBdChapter
14                                on new { a.ChapterCode } equals new { c.ChapterCode }
15                                select new
16                                {
17                                    a.PlantCode,
18                                    c.ChapterCode,
19                                    c.ChapterKnowledge,
20                                    a.OrgSkillId,
21                                    c.SkillCode
22                                };
23             var items = handsonitems.Union(Jobevalitems);

 

Linq 将两个查询结果合称为一个

原文:https://www.cnblogs.com/battlecry/p/11543252.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!