Linq查询join多连接条件（多个on）和group by

cgs108

于 2018-11-15 16:21:00 发布

阅读量4k

点赞数

CC 4.0 BY-SA版权

分类专栏： C# 文章标签： linq join on group by

本文链接：https://blog.csdn.net/CGS_______/article/details/84106339

C# 专栏收录该内容

92 篇文章

订阅专栏

本文深入探讨了使用Linq进行多表联接和动态条件查询的技术细节，展示了如何在复杂的数据环境中高效地筛选和处理数据。通过具体的代码示例，讲解了如何实现基于属性的联接和条件过滤，为开发人员提供了实用的参考。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

join

var vmasQuery = from sum in det.Det_Summary join vmas in det.Det_VMAS 
                on new {DetLsh = sum.DetLsh,DetTimes = sum.DetTimes} equals
                   new {DetLsh = vmas.DetLsh,DetTimes = vmas.DetTimes}
                join dets in det.Det_Detail
                on new {DetLsh = sum.DetLsh,DetTimes = sum.DetTimes} equals
                   new {DetLsh = dets.DetLsh,DetTimes = dets.DetTimes}
                join veh in det.Det_Vehicle
                on new {DetLsh = sum.DetLsh,DetTimes = sum.DetTimes} equals
                   new {DetLsh = veh.DetLsh,DetTimes = veh.DetTimes}
                where (sum.DetLsh == detlsh) && (sum.DetTimes == Convert.ToInt32(dettimes))
                select new GasVmasResult
                {
                    co = vmas.VmasCO,
                    hc = vmas.VmasHC,
                    nox = vmas.VmasNO
                }

group by

                    var lineCount = from line in det.Org_DetectLine
                                    group line by line.StaID into g
                                    select new
                                    {
                                       StaID =  g.Key,
                                       LineCount = g.Count()
                                    };

动态条件查询

var query = from item in det.Det_Detail
                        orderby item.KSSJ
                        where (string.IsNullOrEmpty(state) || item.SCBZ == state) //linq 动态条件查询
                            && (string.IsNullOrEmpty(jcff) || item.JCFFID == jcff)
                            && (string.IsNullOrEmpty(lsh) || item.DetLsh == lsh)
                            && item.KSSJ >= kssj && item.JSSJ <= jssj
                        select item;