{"id":54,"date":"2013-09-19T20:15:00","date_gmt":"2013-09-20T01:15:00","guid":{"rendered":"https:\/\/www.chrystalsander.com\/blog\/?p=54"},"modified":"2023-07-26T15:58:41","modified_gmt":"2023-07-26T20:58:41","slug":"linq-query-using-cross-group-joins","status":"publish","type":"post","link":"https:\/\/www.chrystalsander.com\/blog\/?p=54","title":{"rendered":"LINQ : Query Using Cross & Group Joins"},"content":{"rendered":"
\n<\/div>\n
\n–Cross Join:<\/b><\/div>\n
\n
<\/b><\/div>\n
\n\/\/LINQ Query Example For Cross Join<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n\/\/This joins elements of two sequences based on equality of an element<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n
<\/span><\/span><\/span><\/span><\/span><\/div>\n
\npublic<\/span><\/span><\/span> <\/span><\/span><\/span>static<\/span><\/span><\/span> <\/span><\/span><\/span>void<\/span><\/span><\/span> RiderBikeCrossJoinQuery()<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n{<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n \/\/create a string array<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n string<\/span><\/span><\/span>[] bikeWinners = <\/span><\/span><\/span>new<\/span><\/span><\/span> <\/span><\/span><\/span>string<\/span><\/span><\/span>[] {<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n    <\/span>“Honda”<\/span><\/span><\/span>, <\/span><\/span><\/span>“Yamaha”<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n };<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n
<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n <\/span>\n<\/div>\n
\n \/\/populate the Generic List<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n createRiders();<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n <\/span>\n<\/div>\n
\n var<\/span><\/span><\/span> linqQuery =<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n    <\/span>from<\/span><\/span><\/span> w <\/span><\/span><\/span>in<\/span><\/span><\/span> bikeWinners<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n    <\/span>join<\/span><\/span><\/span> r <\/span><\/span><\/span>in<\/span><\/span><\/span> riderList <\/span><\/span><\/span>on<\/span><\/span><\/span> w <\/span><\/span><\/span>equals<\/span><\/span><\/span> r.BikeMake<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n    <\/span>select<\/span><\/span><\/span> <\/span><\/span><\/span>new<\/span><\/span><\/span> { Winner = w, r.BikeModel, r.FirstName, r.LastName };<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n
<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n <\/span>\n<\/div>\n
\n foreach<\/span><\/span><\/span> (<\/span><\/span><\/span>var<\/span><\/span><\/span> win <\/span><\/span><\/span>in<\/span><\/span><\/span> linqQuery)<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n {<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n    <\/span>Console<\/span><\/span><\/span>.WriteLine(<\/span><\/span><\/span>“Winner is {0} {1} on the {2} from {3}  “<\/span><\/span><\/span>, win.FirstName, <\/span><\/span><\/span><\/span><\/span><\/div>\n
\n win.LastName,
\nwin.BikeModel, win.Winner);<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n }<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n
<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n Console<\/span><\/span><\/span>.ReadLine();<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n
<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n}<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n\n<\/div>\n
\n–Group Join:<\/b>
\n<\/span><\/span><\/span>\n<\/div>\n
\n
<\/b><\/div>\n
\n\/\/LINQ Query Example for Group Join<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n\/\/This joins riders that have the same BikeMake<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n
<\/span><\/span><\/span><\/span><\/span><\/div>\n
\npublic<\/span><\/span><\/span> <\/span><\/span><\/span>static<\/span><\/span><\/span> <\/span><\/span><\/span>void<\/span><\/span><\/span> RiderBikeGroupJoinQuery()<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n{<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n \/\/create a string array<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n string<\/span><\/span><\/span>[] bikeMake = <\/span><\/span><\/span>new<\/span><\/span><\/span> <\/span><\/span><\/span>string<\/span><\/span><\/span>[] {<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n    <\/span>“Yamaha”<\/span><\/span><\/span>, <\/span><\/span><\/span>“Ducati”<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n };<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n
<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n <\/span>\n<\/div>\n
\n \/\/populate the Generic List<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n createRiders();<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n <\/span>\n<\/div>\n
\n var<\/span><\/span><\/span> linqQuery =<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n    <\/span>from<\/span><\/span><\/span> b <\/span><\/span><\/span>in<\/span><\/span><\/span> bikeMake<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n    <\/span>join<\/span><\/span><\/span> r <\/span><\/span><\/span>in<\/span><\/span><\/span> riderList <\/span><\/span><\/span>on<\/span><\/span><\/span> b <\/span><\/span><\/span>equals<\/span><\/span><\/span> r.BikeMake <\/span><\/span><\/span>into<\/span><\/span><\/span> bm<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n    <\/span>select<\/span><\/span><\/span> <\/span><\/span><\/span>new<\/span><\/span><\/span> {Bikes = b, Models = bm}<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n    ;<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n
<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n <\/span>\n<\/div>\n
\n foreach<\/span><\/span><\/span> (<\/span><\/span><\/span>var<\/span><\/span><\/span> m <\/span><\/span><\/span>in<\/span><\/span><\/span> linqQuery)<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n {<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n    <\/span>Console<\/span><\/span><\/span>.WriteLine(m.Bikes + <\/span><\/span><\/span>“:”<\/span><\/span><\/span>);<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n    <\/span>Console<\/span><\/span><\/span>.WriteLine(<\/span><\/span><\/span>“——————–“<\/span><\/span><\/span>);               <\/span><\/span><\/span><\/span><\/span><\/div>\n
\n    <\/span>foreach<\/span><\/span><\/span> (<\/span><\/span><\/span>var<\/span><\/span><\/span> x <\/span><\/span><\/span>in<\/span><\/span><\/span> m.Models)<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n    {<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n        <\/span>Console<\/span><\/span><\/span>.WriteLine(x.BikeModel);<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n    }<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n    <\/span>Console<\/span><\/span><\/span>.WriteLine();          <\/span><\/span><\/span><\/span><\/span><\/div>\n
\n }<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n
<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n Console<\/span><\/span><\/span>.ReadLine();<\/span><\/span><\/span><\/span><\/span><\/div>\n
\n
<\/span><\/span><\/span><\/span><\/span><\/div>\n

<\/p>\n

\n }<\/span><\/span><\/span><\/span><\/span><\/div>\n","protected":false},"excerpt":{"rendered":"

–Cross Join: \/\/LINQ Query Example For Cross Join \/\/This joins elements of two sequences based on equality of an element public static void RiderBikeCrossJoinQuery() { \/\/create a string array string[] bikeWinners = new string[] {     “Honda”, “Yamaha” }; \/\/populate the Generic List createRiders(); var linqQuery =     from w in bikeWinners     join r in riderList on w equals r.BikeMake     select new { Winner = w, r.BikeModel, r.FirstName, r.LastName }; foreach (var win in linqQuery) {     Console.WriteLine(“Winner is {0} {1} on the {2} from {3}  “, win.FirstName,  win.LastName, win.BikeModel, win.Winner); } Console.ReadLine(); } –Group Join: \/\/LINQ Query Example for Group Join \/\/This joins riders that have the same BikeMake public static void RiderBikeGroupJoinQuery() { \/\/create a string array string[] bikeMake = new string[] {     “Yamaha”, “Ducati” }; \/\/populate the Generic List createRiders(); var linqQuery =     from b in bikeMake     join r in riderList on b equals r.BikeMake into bm     select new {Bikes = b, Models = bm}     ; foreach (var m in linqQuery) {     Console.WriteLine(m.Bikes + “:”);     Console.WriteLine(“——————–“);                    foreach (var x in m.Models)     {         Console.WriteLine(x.BikeModel);     }     Console.WriteLine();           } Console.ReadLine(); }<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[33],"tags":[83],"_links":{"self":[{"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/54"}],"collection":[{"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=54"}],"version-history":[{"count":1,"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/54\/revisions"}],"predecessor-version":[{"id":243,"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/54\/revisions\/243"}],"wp:attachment":[{"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=54"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=54"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=54"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}