深入理解 c# 第十一章 使用分组连接连接缺陷和订阅 使用join...into子句进行分组连接

最新推荐文章于 2023-10-27 16:31:20 发布
最新推荐文章于 2023-10-27 16:31:20 发布
阅读量294 收藏
点赞数
文章标签： c#
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/eyetired/article/details/80220015
版权 
    class AllDefectsToSubscribersGrouped
    {
        static void Main()//使用join...into子句进行分组连接 使用分组连接连接缺陷和订阅
        {
            var query = from defect in SampleData.AllDefects 
                        join subscription in SampleData.AllSubscriptions
                             on defect.Project equals subscription.Project
							 //subscription.Project {Chapter11.Model.NotificationSubscription}
//defect							 
//{ 1: MP3 files crash system    (2013/5/1-2013/5/23, Showstopper/Accepted, Tim Trotter -> Darren Dahlia)}
//defect = { 2: Text is too big(2013/5/3-2013/5/9, Trivial/Closed, Deborah Denton -> n/a)}     
//{ 3: Sky is wrong shade of blue    (2013/5/3-2013/5/19, Minor/Fixed, Colin Carton -> Tara Tutu)}  
//{ 4: Can't play files more than 200 bytes long    (2013/5/4-2013/5/23, Major/Reopened, Darren Dahlia -> Darren Dahlia)}  
//{ 5: Installation is slow    (2013/5/6-2013/5/15, Trivial/Fixed, Tim Trotter -> Tim Trotter)}  
//{ 6: DivX is choppy on Pentium 100    (2013/5/7-2013/5/29, Major/Accepted, Mary Malcop -> Darren Dahlia)}  
//{ 7: Client acts as virus    (2013/5/8-2013/5/10, Showstopper/Closed, Deborah Denton -> n/a)}  
//{ 8: Subtitles only work in Welsh(2013/5/8-2013/5/23, Major/Fixed, Darren Dahlia -> Tim Trotter)}    
//{ 9: Voice recognition is confused by background noise    (2013/5/9-2013/5/15, Minor/Closed, Colin Carton -> n/a)}  
//{10: User interface should be more caramelly    (2013/5/9-2013/5/9, Trivial/Created, Tim Trotter -> Darren Dahlia)}  
//{11: Burning a CD makes the printer catch fire    (2013/5/10-2013/5/29, Showstopper/Closed, Mary Malcop -> n/a)}  
//{12: Peer to peer pairing passes parameters poorly    (2013/5/10-2013/5/12, Minor/Accepted, Tara Tutu -> Darren Dahlia)}  
//{13: Delay when sending message    (2013/5/11-2013/5/20, Minor/Fixed, Darren Dahlia -> Tara Tutu)}  
//{14: Volume control needs to go to 11    (2013/5/11-2013/5/11, Minor/Created, Mary Malcop -> Darren Dahlia)}  
//{15: Splash screen fades too quickly    (2013/5/11-2013/5/15, Minor/Fixed, Colin Carton -> Tara Tutu)}  
//{16: Text box doesn't keep up with fast typing    (2013/5/12-2013/5/12, Major/Accepted, Deborah Denton -> Deborah Denton)}  
//{17: Password displayed in plain text    (2013/5/12-2013/5/13, Showstopper/Closed, Darren Dahlia -> n/a)}  
//{18: Play button points the wrong way    (2013/5/12-2013/5/17, Major/Fixed, Tim Trotter -> Tim Trotter)}  
//{19: Wizard needed for CD burning    (2013/5/13-2013/5/20, Minor/Fixed, Colin Carton -> Colin Carton)}  
//{20: Subtitles don't display during fast forward    (2013/5/13-2013/5/14, Trivial/Accepted, Mary Malcop -> Darren Dahlia)}  
//{21: Memory leak when watching Memento    (2013/5/13-2013/5/13, Trivial/Created, Darren Dahlia -> Deborah Denton)}  
//{22: Profile screen shows login count of -1    (2013/5/13-2013/5/20, Major/Accepted, Deborah Denton -> Deborah Denton)}  
//{23: Server crashes under heavy load (3 users)    (2013/5/13-2013/5/17, Major/Accepted, Tim Trotter -> Deborah Denton)}  
//{24: Unable to connect to any media server    (2013/5/15-2013/5/18, Showstopper/Reopened, Tara Tutu -> Darren Dahlia)}  
//{25: UI turns black and white when playing old films    (2013/5/15-2013/5/25, Minor/Fixed, Deborah Denton -> Tara Tutu)}  
//{26: Password reset changes passwords for all users    (2013/5/16-2013/5/18, Showstopper/Closed, Mary Malcop -> n/a)}  
//{27: Modern music sounds rubbish    (2013/5/17-2013/5/17, Trivial/Created, Tim Trotter -> Darren Dahlia)}  
//{28: Webcam makes me look bald    (2013/5/18-2013/5/27, Showstopper/Fixed, Tim Trotter -> Tim Trotter)}  
//{29: Sound is distorted when speakers are underwater    (2013/5/18-2013/5/18, Major/Created, Colin Carton -> Darren Dahlia)}  
//{30: Japanese characters don't display properly    (2013/5/19-2013/5/23, Major/Accepted, Darren Dahlia -> Deborah Denton)}  
//{31: Video takes 100% of CPU    (2013/5/20-2013/5/22, Major/Accepted, Tara Tutu -> Deborah Denton)}  
//{32: DVD Easter eggs unavailable    (2013/5/22-2013/5/22, Trivial/Created, Tim Trotter -> Darren Dahlia)}  
//{33: Transparency is high for menus to be readable    (2013/5/23-2013/5/25, Minor/Accepted, Mary Malcop -> Deborah Denton)}  
//{34: About box is missing version number    (2013/5/24-2013/5/29, Minor/Fixed, Colin Carton -> Colin Carton)}  
//{35: Logs record confidential conversations    (2013/5/25-2013/5/30, Major/Reopened, Tim Trotter -> Darren Dahlia)}  
//{36: Profanity filter is too aggressive    (2013/5/27-2013/5/29, Minor/Fixed, Deborah Denton -> Tara Tutu)}  
//{37: Full screen mode fails on dual monitors    (2013/5/27-2013/5/27, Minor/Created, Tara Tutu -> Deborah Denton)}  
//{38: Visualization hypnotises pets    (2013/5/28-2013/5/29, Minor/Accepted, Colin Carton -> Deborah Denton)}  
//{39: Resizing while typing loses input    (2013/5/29-2013/5/29, Trivial/Created, Mary Malcop -> Darren Dahlia)}  
//{40: Network is saturated when playing WAV file    (2013/5/30-2013/5/31, Minor/Fixed, Tim Trotter -> Tim Trotter)}  
//{41: Media library tells user to keep the noise down    (2013/5/31-2013/5/31, Major/Created, Tara Tutu -> Darren Dahlia)}  
                             into groupedSubscriptions
                        select new { Defect=defect, Subscriptions=groupedSubscriptions };
//{System.Linq.Enumerable.GroupJoinIterator<Chapter11.Model.Defect,Chapter11.Model.NotificationSubscription,Chapter11.Model.Project,<>f__AnonymousType3<Chapter11.Model.Defect,System.Collections.Generic.IEnumerable<Chapter11.Model.NotificationSubscription>>>}
//groupedSubscriptions {System.Linq.Lookup<Chapter11.Model.Project,Chapter11.Model.NotificationSubscription>.Grouping}

            foreach (var entry in query)
//entry			
//{ Defect = { 1: MP3 files crash system    (2013/5/1-2013/5/23, Showstopper/Accepted, Tim Trotter -> Darren Dahlia)}, Subscriptions = {System.Linq.Lookup<Chapter11.Model.Project,Chapter11.Model.NotificationSubscription>.Grouping} }			
//{ Defect = { 2: Text is too big    (2013/5/3-2013/5/9, Trivial/Closed, Deborah Denton -> n/a)}, Subscriptions = {System.Linq.Lookup<Chapter11.Model.Project,Chapter11.Model.NotificationSubscription>.Grouping} }
//{ Defect = { 3: Sky is wrong shade of blue    (2013/5/3-2013/5/19, Minor/Fixed, Colin Carton -> Tara Tutu)}, Subscriptions = {System.Linq.Lookup<Chapter11.Model.Project,Chapter11.Model.NotificationSubscription>.Grouping} }
//{ Defect = { 4: Can't play files more than 200 bytes long    (2013/5/4-2013/5/23, Major/Reopened, Darren Dahlia -> Darren Dahlia)}, Subscriptions = {System.Linq.Lookup<Chapter11.Model.Project,Chapter11.Model.NotificationSubscription>.Grouping} }
//{ Defect = { 5: Installation is slow    (2013/5/6-2013/5/15, Trivial/Fixed, Tim Trotter -> Tim Trotter)}, Subscriptions = {System.Linq.Lookup<Chapter11.Model.Project,Chapter11.Model.NotificationSubscription>.Grouping} }
//{ Defect = { 6: DivX is choppy on Pentium 100    (2013/5/7-2013/5/29, Major/Accepted, Mary Malcop -> Darren Dahlia)}, Subscriptions = {System.Linq.Lookup<Chapter11.Model.Project,Chapter11.Model.NotificationSubscription>.Grouping} }
//{ Defect = { 7: Client acts as virus    (2013/5/8-2013/5/10, Showstopper/Closed, Deborah Denton -> n/a)}, Subscriptions = {System.Linq.Lookup<Chapter11.Model.Project,Chapter11.Model.NotificationSubscription>.Grouping} }
//{ Defect = { 8: Subtitles only work in Welsh    (2013/5/8-2013/5/23, Major/Fixed, Darren Dahlia -> Tim Trotter)}, Subscriptions = {System.Linq.Lookup<Chapter11.Model.Project,Chapter11.Model.NotificationSubscription>.Grouping} }
//{ Defect = { 9: Voice recognition is confused by background noise    (2013/5/9-2013/5/15, Minor/Closed, Colin Carton -> n/a)}, Subscriptions = {System.Linq.Lookup<Chapter11.Model.Project,Chapter11.Model.NotificationSubscription>.Grouping} }
//{ Defect = {10: User interface should be more caramelly    (2013/5/9-2013/5/9, Trivial/Created, Tim Trotter -> Darren Dahlia)}, Subscriptions = {System.Linq.Lookup<Chapter11.Model.Project,Chapter11.Model.NotificationSubscription>.Grouping} }
//{ Defect = {11: Burning a CD makes the printer catch fire    (2013/5/10-2013/5/29, Showstopper/Closed, Mary Malcop -> n/a)}, Subscriptions = {System.Linq.Lookup<Chapter11.Model.Project,Chapter11.Model.NotificationSubscription>.Grouping} }
//{ Defect = {12: Peer to peer pairing passes parameters poorly    (2013/5/10-2013/5/12, Minor/Accepted, Tara Tutu -> Darren Dahlia)}, Subscriptions = {System.Linq.Lookup<Chapter11.Model.Project,Chapter11.Model.NotificationSubscription>.Grouping} }
//{ Defect = {13: Delay when sending message    (2013/5/11-2013/5/20, Minor/Fixed, Darren Dahlia -> Tara Tutu)}, Subscriptions = {System.Linq.Lookup<Chapter11.Model.Project,Chapter11.Model.NotificationSubscription>.Grouping} }
//{ Defect = {14: Volume control needs to go to 11    (2013/5/11-2013/5/11, Minor/Created, Mary Malcop -> Darren Dahlia)}, Subscriptions = {System.Linq.Lookup<Chapter11.Model.Project,Chapter11.Model.NotificationSubscription>.Grouping} }
//{ Defect = {15: Splash screen fades too quickly    (2013/5/11-2013/5/15, Minor/Fixed, Colin Carton -> Tara Tutu)}, Subscriptions = {System.Linq.Lookup<Chapter11.Model.Project,Chapter11.Model.NotificationSubscription>.Grouping} }
//{ Defect = {16: Text box doesn't keep up with fast typing    (2013/5/12-2013/5/12, Major/Accepted, Deborah Denton -> Deborah Denton)}, Subscriptions = {System.Linq.Lookup<Chapter11.Model.Project,Chapter11.Model.NotificationSubscription>.Grouping} }
//{ Defect = {17: Password displayed in plain text    (2013/5/12-2013/5/13, Showstopper/Closed, Darren Dahlia -> n/a)}, Subscriptions = {System.Linq.Lookup<Chapter11.Model.Project,Chapter11.Model.NotificationSubscription>.Grouping} }
//{ Defect = {18: Play button points the wrong way    (2013/5/12-2013/5/17, Major/Fixed, Tim Trotter -> Tim Trotter)}, Subscriptions = {System.Linq.Lookup<Chapter11.Model.Project,Chapter11.Model.NotificationSubscription>.Grouping} }
//{ Defect = {19: Wizard needed for CD burning    (2013/5/13-2013/5/20, Minor/Fixed, Colin Carton -> Colin Carton)}, Subscriptions = {System.Linq.Lookup<Chapter11.Model.Project,Chapter11.Model.NotificationSubscription>.Grouping} }
//{ Defect = {20: Subtitles don't display during fast forward    (2013/5/13-2013/5/14, Trivial/Accepted, Mary Malcop -> Darren Dahlia)}, Subscriptions = {System.Linq.Lookup<Chapter11.Model.Project,Chapter11.Model.NotificationSubscription>.Grouping} }
//{ Defect = {21: Memory leak when watching Memento    (2013/5/13-2013/5/13, Trivial/Created, Darren Dahlia -> Deborah Denton)}, Subscriptions = {System.Linq.Lookup<Chapter11.Model.Project,Chapter11.Model.NotificationSubscription>.Grouping} }
//{ Defect = {22: Profile screen shows login count of -1    (2013/5/13-2013/5/20, Major/Accepted, Deborah Denton -> Deborah Denton)}, Subscriptions = {System.Linq.Lookup<Chapter11.Model.Project,Chapter11.Model.NotificationSubscription>.Grouping} }
//{ Defect = {23: Server crashes under heavy load (3 users)    (2013/5/13-2013/5/17, Major/Accepted, Tim Trotter -> Deborah Denton)}, Subscriptions = {System.Linq.Lookup<Chapter11.Model.Project,Chapter11.Model.NotificationSubscription>.Grouping} }
//{ Defect = {24: Unable to connect to any media server    (2013/5/15-2013/5/18, Showstopper/Reopened, Tara Tutu -> Darren Dahlia)}, Subscriptions = {System.Linq.Lookup<Chapter11.Model.Project,Chapter11.Model.NotificationSubscription>.Grouping} }
//{ Defect = {25: UI turns black and white when playing old films    (2013/5/15-2013/5/25, Minor/Fixed, Deborah Denton -> Tara Tutu)}, Subscriptions = {System.Linq.Lookup<Chapter11.Model.Project,Chapter11.Model.NotificationSubscription>.Grouping} }
//{ Defect = {26: Password reset changes passwords for all users    (2013/5/16-2013/5/18, Showstopper/Closed, Mary Malcop -> n/a)}, Subscriptions = {System.Linq.Lookup<Chapter11.Model.Project,Chapter11.Model.NotificationSubscription>.Grouping} }
//{ Defect = {27: Modern music sounds rubbish    (2013/5/17-2013/5/17, Trivial/Created, Tim Trotter -> Darren Dahlia)}, Subscriptions = {System.Linq.Lookup<Chapter11.Model.Project,Chapter11.Model.NotificationSubscription>.Grouping} }
//{ Defect = {28: Webcam makes me look bald    (2013/5/18-2013/5/27, Showstopper/Fixed, Tim Trotter -> Tim Trotter)}, Subscriptions = {System.Linq.Lookup<Chapter11.Model.Project,Chapter11.Model.NotificationSubscription>.Grouping} }
//{ Defect = {29: Sound is distorted when speakers are underwater    (2013/5/18-2013/5/18, Major/Created, Colin Carton -> Darren Dahlia)}, Subscriptions = {System.Linq.Lookup<Chapter11.Model.Project,Chapter11.Model.NotificationSubscription>.Grouping} }
//{ Defect = {30: Japanese characters don't display properly    (2013/5/19-2013/5/23, Major/Accepted, Darren Dahlia -> Deborah Denton)}, Subscriptions = {System.Linq.Lookup<Chapter11.Model.Project,Chapter11.Model.NotificationSubscription>.Grouping} }
//{ Defect = {31: Video takes 100% of CPU    (2013/5/20-2013/5/22, Major/Accepted, Tara Tutu -> Deborah Denton)}, Subscriptions = {System.Linq.Lookup<Chapter11.Model.Project,Chapter11.Model.NotificationSubscription>.Grouping} }
//{ Defect = {32: DVD Easter eggs unavailable    (2013/5/22-2013/5/22, Trivial/Created, Tim Trotter -> Darren Dahlia)}, Subscriptions = {System.Linq.Lookup<Chapter11.Model.Project,Chapter11.Model.NotificationSubscription>.Grouping} }
//{ Defect = {33: Transparency is high for menus to be readable    (2013/5/23-2013/5/25, Minor/Accepted, Mary Malcop -> Deborah Denton)}, Subscriptions = {System.Linq.Lookup<Chapter11.Model.Project,Chapter11.Model.NotificationSubscription>.Grouping} }
//{ Defect = {34: About box is missing version number    (2013/5/24-2013/5/29, Minor/Fixed, Colin Carton -> Colin Carton)}, Subscriptions = {System.Linq.Lookup<Chapter11.Model.Project,Chapter11.Model.NotificationSubscription>.Grouping} }
//{ Defect = {35: Logs record confidential conversations    (2013/5/25-2013/5/30, Major/Reopened, Tim Trotter -> Darren Dahlia)}, Subscriptions = {System.Linq.Lookup<Chapter11.Model.Project,Chapter11.Model.NotificationSubscription>.Grouping} }
//{ Defect = {36: Profanity filter is too aggressive    (2013/5/27-2013/5/29, Minor/Fixed, Deborah Denton -> Tara Tutu)}, Subscriptions = {System.Linq.Lookup<Chapter11.Model.Project,Chapter11.Model.NotificationSubscription>.Grouping} }
//{ Defect = {37: Full screen mode fails on dual monitors    (2013/5/27-2013/5/27, Minor/Created, Tara Tutu -> Deborah Denton)}, Subscriptions = {System.Linq.Lookup<Chapter11.Model.Project,Chapter11.Model.NotificationSubscription>.Grouping} }
//{ Defect = {38: Visualization hypnotises pets    (2013/5/28-2013/5/29, Minor/Accepted, Colin Carton -> Deborah Denton)}, Subscriptions = {System.Linq.Lookup<Chapter11.Model.Project,Chapter11.Model.NotificationSubscription>.Grouping} }
//{ Defect = {39: Resizing while typing loses input    (2013/5/29-2013/5/29, Trivial/Created, Mary Malcop -> Darren Dahlia)}, Subscriptions = {System.Linq.Lookup<Chapter11.Model.Project,Chapter11.Model.NotificationSubscription>.Grouping} }
//{ Defect = {40: Network is saturated when playing WAV file    (2013/5/30-2013/5/31, Minor/Fixed, Tim Trotter -> Tim Trotter)}, Subscriptions = {System.Linq.Lookup<Chapter11.Model.Project,Chapter11.Model.NotificationSubscription>.Grouping} }
//{ Defect = {41: Media library tells user to keep the noise down    (2013/5/31-2013/5/31, Major/Created, Tara Tutu -> Darren Dahlia)}, Subscriptions = {System.Linq.Lookup<Chapter11.Model.Project,Chapter11.Model.NotificationSubscription>.Grouping} }

            {
                Console.WriteLine(entry.Defect.Summary);
                foreach (var subscription in entry.Subscriptions)
				//var subscription {Chapter11.Model.NotificationSubscription}
				
                {
                    Console.WriteLine ("  {0}", subscription.EmailAddress);
                }
            }
        }
    }


  分组连接的查询表达式与普通join子句看上去与之类似，不过却具有完全不同的结果。分组连接
结果中的每个元素由左边序列（使用它的原始范围变量）的某个元素和右边序列的所有匹配元素
的序列组成。分组连接用一个新的范围变量表示，变量由join子句中into后面的标识符指定。
  显示bug和每个bug所需的通知，但将通知按"每个缺陷"进行分解。
  每个条目的Subscriptions属性是一个内嵌序列，该序列包含了匹配该数据项缺陷的所有订阅。
内连接和分组连接之间的一个重要差异（即分组连接和普通分组之间的差异）是，对于分组连接
来说，在左边序列和结果序列之间是一对一的对应关系，即使左边序列中的某些元素在右边序列
中没有任何匹配的元素，也无所谓。这是非常重要的，有时会用于模拟SQL的左外连接。在左边
元素不匹配任何右边元素的时候，嵌入序列就是空的。与内连接一样，分组连接要对右边序列

进行缓冲，而对左边序列进行流处理。


  输出
MP3 files crash system
  media-bugs@skeetysoft.com
  theboss@skeetysoft.com
Text is too big
  media-bugs@skeetysoft.com
  theboss@skeetysoft.com
Sky is wrong shade of blue
  talk-bugs@skeetysoft.com
Can't play files more than 200 bytes long
  media-bugs@skeetysoft.com
  theboss@skeetysoft.com
Installation is slow
  media-bugs@skeetysoft.com
  theboss@skeetysoft.com
DivX is choppy on Pentium 100
  media-bugs@skeetysoft.com
  theboss@skeetysoft.com
Client acts as virus
  talk-bugs@skeetysoft.com
Subtitles only work in Welsh
  media-bugs@skeetysoft.com
  theboss@skeetysoft.com
Voice recognition is confused by background noise
  talk-bugs@skeetysoft.com
User interface should be more caramelly
  talk-bugs@skeetysoft.com
Burning a CD makes the printer catch fire
  media-bugs@skeetysoft.com
  theboss@skeetysoft.com
Peer to peer pairing passes parameters poorly
  talk-bugs@skeetysoft.com
Delay when sending message
  talk-bugs@skeetysoft.com
Volume control needs to go to 11
  media-bugs@skeetysoft.com
  theboss@skeetysoft.com
Splash screen fades too quickly
  media-bugs@skeetysoft.com
  theboss@skeetysoft.com
Text box doesn't keep up with fast typing
  talk-bugs@skeetysoft.com
Password displayed in plain text
  talk-bugs@skeetysoft.com
Play button points the wrong way
  media-bugs@skeetysoft.com
  theboss@skeetysoft.com
Wizard needed for CD burning
  media-bugs@skeetysoft.com
  theboss@skeetysoft.com
Subtitles don't display during fast forward
  media-bugs@skeetysoft.com
  theboss@skeetysoft.com
Memory leak when watching Memento
  media-bugs@skeetysoft.com
  theboss@skeetysoft.com
Profile screen shows login count of -1
  talk-bugs@skeetysoft.com
Server crashes under heavy load (3 users)
  talk-bugs@skeetysoft.com
Unable to connect to any media server
  media-bugs@skeetysoft.com
  theboss@skeetysoft.com
UI turns black and white when playing old films
  media-bugs@skeetysoft.com
  theboss@skeetysoft.com
Password reset changes passwords for all users
  talk-bugs@skeetysoft.com
Modern music sounds rubbish
  media-bugs@skeetysoft.com
  theboss@skeetysoft.com
Webcam makes me look bald
  talk-bugs@skeetysoft.com
Sound is distorted when speakers are underwater
  talk-bugs@skeetysoft.com
Japanese characters don't display properly
  talk-bugs@skeetysoft.com
Video takes 100% of CPU
  media-bugs@skeetysoft.com
  theboss@skeetysoft.com
DVD Easter eggs unavailable
  media-bugs@skeetysoft.com
  theboss@skeetysoft.com
Transparency is high for menus to be readable
  talk-bugs@skeetysoft.com
About box is missing version number
  media-bugs@skeetysoft.com
  theboss@skeetysoft.com
Logs record confidential conversations
  talk-bugs@skeetysoft.com
Profanity filter is too aggressive
  talk-bugs@skeetysoft.com
Full screen mode fails on dual monitors
  media-bugs@skeetysoft.com
  theboss@skeetysoft.com
Visualization hypnotises pets
  media-bugs@skeetysoft.com
  theboss@skeetysoft.com
Resizing while typing loses input
  talk-bugs@skeetysoft.com
Network is saturated when playing WAV file
  media-bugs@skeetysoft.com
  theboss@skeetysoft.com
Media library tells user to keep the noise down
  media-bugs@skeetysoft.com
  theboss@skeetysoft.com

eyetired
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
LINQ join into
一叶君
04-02 3067
static void QueryAnimalData() { Animal[] animals = new[] { new Animal{Name = "German Shepherd", Height = 25, Weight = ...
.NET(C#) Linq中join、into、let和group by的使用
weixin_42098295的博客
02-15 909
Linq是Language Integrated Query的简称，它是微软在.NET Framework 3.5里面新加入的特性，用以简化查询查询操作。主要包含：Linq to Object、Linq to SQL、Linq to XML，其中Linq to Object和对于对象的查询，Linq to XML则又提供了对XML格式数据的检索、设置等方法，本文主要介绍.NET(C#) Linq中join、into、let和group by的使用。 原文地址：.NET(C#) Linq中join、into、
第十一章 连接查询和分组查询
qq_36074150的博客
11-25 3873
/****** Script for SelectTopNRows command from SSMS ******/ SELECT TOP 1000 [Id] ,[StudentNo] ,[SubjectId] ,[StudentResult] ,[ExamDate] FROM [MySchool].[dbo].[Result]
C# LINQ into join（2）
xw1198354710的博客
11-07 412
var list1 = new List<(string s1, string s2)>() { ("a","1"), ("b","2"), ("c","4"), ("e","1") }; ...
C# LINQ into join（1）
xw1198354710的博客
11-07 969
var list1 = new List<(string s1, string s2)>() { ("a","1"), ("b","2"), ("c","4") }; var list2 = new List<(...
sql各种Join用法详解
热门推荐
u012861978的专栏
08-14 4万+
在关系代数中，连接运算是由一个笛卡尔积运算和一个选取运算构成的。首先用笛卡尔积完成对两个数据集合的乘运算，然后对生成的结果集合进行选取运算，确保只把分别来自两个数据集合并且具有重叠部分的行合并在一起。连接的全部意义在于在水平方向上合并两个数据集合（通常是表），并产生一个新的结果集合，其方法是将一个数据源中的行于另一个数据源中和它匹配的行组合成一个新元组。SQL提供了多种类型的连接方式，它们之间的区
Linq的使用.docx
06-16
通过使用`from`、`where`、`select`、`orderby`、`group by`和`join`等关键字，我们可以方便地进行数据过滤、排序、分组和连接，从而实现复杂的数据查询和操作。对于处理DataTable或其他数据集，这些技巧尤其有用。
C# 2008 数据库分组条件查询代码
03-16
然而，当需要对数据进行分组和条件查询时，我们需要使用GROUP BY子句。比如，如果我们想要根据某个字段（如`Category`）分组并计算每个类别中的记录数，SQL语句会是这样的： ```sql SELECT Category, COUNT(*) ...
C#初级中级学习代码 每个知识点都可以正常使用 C#详细源码
05-28
10定义一个能接收参数个数可变且有返回值的委托,11LINQ简介,12复合From子句,13where子句,14select子句,15group子句,16into子句,16orderby子句,18let子句,20join子句,Action委托 里面每个知识点都详细的解释了代码的...
第八章用SQL语句操作数据.zip
08-27
可以指定列名、使用WHERE子句过滤条件、使用GROUP BY进行分组、HAVING用于分组后的过滤、ORDER BY进行排序，甚至使用JOIN操作连接多个表的数据。 3. **聚合函数** SQL提供了诸如COUNT(), SUM(), AVG(), MAX(), MIN...
C#中Linq查询基本操作使用实例
09-04
在示例中，如果我们要结合学生和员工的信息，可以使用join连接`students`和`employees`。 8. **let子句**：let子句允许你创建一个临时变量，用于存储中间计算结果，避免重复计算。在示例中，`let words = sentence....
join的不同用法的总结
这么多圆圈圈～～的博客
02-20 693
笛卡尔积：cross join 笛卡尔积是将两个表的任一记录相互组合，如果A有m条记录，B有n条记录，那么通过笛卡尔积产生的结果就会有m*n条记录。 产生迪卡尔积有三种情况： select * from A cross join B; select * form A inner join B; #如果有on的话，就是内连接，即求交集 select * from A,B;#注意，此时不能用on或者u...
C#3.0入门系列（十）-之Join操作
Night_Elf的专栏
09-28 1283
 本节讲join操作。我们知道，T-sql中，有三种最基本的join，inner join, left join, 和right join。 而dlinq并不支持right join。道理很简单，right join以right表为基础，left表中没有对应记录的，将以null值填充。而dlinq以left表做为主表创建对象。如果一个对象为null,你如何获取它的其他的属性呢？在C# 3.0入门系
Linq表连接大全(INNER JOIN、LEFT OUTER JOIN、RIGHT OUTER JOIN、FULL OUTER JOIN、CROSS JOIN)
清闲居
11-21 4387
转自http://www.cnblogs.com/lyj/archive/2008/01/24/1051495.html 我们知道在SQL中一共有五种JOIN操作：INNER JOIN、LEFT OUTER JOIN、RIGHT OUTER JOIN、FULL OUTER JOIN、CROSS JOIN 1>先创建两个表Group、User，两表的关系是N:N  View
C# LINQ入门
q__y__L的博客
01-24 657
这里只是贴一些代码示例，很容易看懂，忘记了怎么用了就来翻看一下。 目录 1.不同的查询方法 2.查询表达式的结构  2.1. from子句 2.2. join子句 2.3 from和join的完整示例  2.3 from...let ...where 2.4 where子句 2.5 orderby子句 2.6 group子句 2.7 into子句 3. 标准查询运算符 4...
C#两个表多条件关联写法
qq_33881408的博客
10-27 703
FROM a JOIN b on 组合键关联 into 临时表 from 临时表（左关联不上右边默认为空）FROM a JOIN b on 组合键关联 into 临时表 from 临时表（不默认为空）
C#EF框架里面的 join Left Join In 写法
还是叫我官人吧
09-15 1万+
记录一下而已: Join var query = BmpDb.UserDetails.Where(i => true);   var queryList = from q in query                                 join u in Db.Users on q.id equals ac.Userid                    
C# LINQ 详解 From Where Select Group Into OrderBy Let Join
mizhenxiao的博客
06-01 5366
目录 概述 from子句 where子句 select子句 group子句 into子句 排序子句 let子句 join子句 小结 概述 LINQ的全称是Language Integrated Query，中文译成“语言集成查询”。LINQ作为一种查询技术，首先要解决数据源的封装，大致使用了三大组件来实现这个封装，分别是LINQ to Object、LINQ to ADO.NET、LINQ ...
linq to sql 连接分组 使用join和into
wwttqq85538649的专栏
02-16 6801
先附上源代码再说明吧：源代码如下：using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Collections; namespace consoleTest2 { class Transport { public string Name { get; set; } public string How
inner join连接后分组
最新发布
12-26
内连接（inner join）是一种根据连接条件将两个表中符合条件的记录进行匹配的连接方式。连接后的结果集只包含符合连接条件的记录。 如果需要对连接后的结果进行分组，可以使用GROUP BY子句。GROUP BY子句将结果集按照指定的列进行分组，并对每个分组进行聚合操作。 以下是一个示例，演示了使用内连接连接两个表，并对连接后的结果进行分组： ```sql SELECT t1.id, t1.name, COUNT(t2.id) as count FROM table1 t1 INNER JOIN table2 t2 ON t1.id = t2.id GROUP BY t1.id, t1.name;``` 上述示例中，我们连接了两个表table1和table2，并根据id列进行连接。然后使用GROUP BY子句将结果按照t1.id和t1.name进行分组。最后使用COUNT函数统计每个分组中t2.id的数量，并将结果命名为count。 注意：在实际使用中，根据具体需求可能需要对其他列进行聚合操作或使用其他聚合函数。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值