linq联合查询例子

发布时间:2020-06-23 12:28:18 作者:cndhey
来源:网络 阅读:439

where_model wm=new  where_model ();
    wm.kid = 58;
    IList<teacher> mlist = BasicDataProxy.teacher_GetList(wm);

    IList<kin_roleinfo> klist = BasicDataProxy.kin_roleinfo_GetList(wm);

    mlist = (from x in mlist
              where (x.title == "" && x.did != 1324 && x.userid>0)
              orderby x.did
              select x
              ).ToList<teacher>();

    var list = (from x in mlist
                join p in klist on x.kid equals p.kid
                where (p.rid > 1000)
                select new kininfo()
                {

                    kid=x.kid,
                    rid=p.rid,
                    title=x.title,
                    uname=x.uname
                });

 

 

var list = (from x in mlist
                join p in klist on x.kid equals p.kid
                where (p.rid > 1000)
                group p by new {
                    x.kid,
                    x.uname
                }into g 
                select new kininfo()
                {

                    kid = g.Count(),
                    rid = g.Sum(x=>x.rid+g.Key.kid),
                    uname=g.Key.uname
                });

推荐阅读:
  1. 并行Linq
  2. 什么是mysql的联合查询

免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。

查询 联合

上一篇:如何通过ShareSDK的 Unity3D快速接入Android/iOS分享与授权

下一篇:ORA-30013: undo tablespace currently in use故障处理思路

相关阅读

您好,登录后才能下订单哦!

密码登录
登录注册
其他方式登录
点击 登录注册 即表示同意《亿速云用户服务条款》