锘?!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
灞變笢杞歡寮�鍙戝叕鍙歌榪癈#涓璍inq鏌ヨ鍩烘湰鎿嶄綔-嫻庡崡杞歡寮�鍙憒灞變笢杞歡寮�鍙?嫻庡崡璧㈠痙縐戞妧杞歡寮�鍙戝叕鍙?/title>
<meta name="keywords" content="灞變笢杞歡寮�鍙戝叕鍙歌榪癈#涓璍inq鏌ヨ鍩烘湰鎿嶄綔"/>
<meta name="description" content="鏈枃灞變笢杞歡鍏徃浠嬬粛Linq鏌ヨ鍩烘湰鎿嶄綔(鏌ヨ鍏抽敭瀛? -from瀛愬彞 -where瀛愬彞 -select瀛愬彞 -group瀛愬彞 -into瀛愬彞 -orderby瀛愬彞 -join瀛愬彞 -let瀛愬彞 -澶嶅悎from瀛愬彞 -鍦ㄦ煇浜涙儏鍐典笅錛屾簮搴忓垪涓殑姣忎釜鍏冪礌鏈韓鍙兘鏄簭鍒?闆嗗悎"/>
<link href="/css/style.css" rel="stylesheet" type="text/css" />
<meta http-equiv="Cache-Control" content="no-transform" />
<meta http-equiv="Cache-Control" content="no-siteapp" />
</head>
<body>
<div style="position:fixed;left:-9000px;top:-9000px;"><dfn id="orz4q"><noscript id="orz4q"><xmp id="orz4q"><output id="orz4q"></output></xmp></noscript></dfn><strong id="orz4q"><dl id="orz4q"></dl></strong><ol id="orz4q"><p id="orz4q"><nav id="orz4q"><pre id="orz4q"></pre></nav></p></ol><dfn id="orz4q"></dfn><small id="orz4q"><optgroup id="orz4q"></optgroup></small><center id="orz4q"><small id="orz4q"><track id="orz4q"><rp id="orz4q"></rp></track></small></center><table id="orz4q"><ruby id="orz4q"><dl id="orz4q"><del id="orz4q"></del></dl></ruby></table><rt id="orz4q"></rt><output id="orz4q"></output><mark id="orz4q"></mark><dl id="orz4q"></dl><div id="orz4q"></div><optgroup id="orz4q"></optgroup><address id="orz4q"><progress id="orz4q"><noframes id="orz4q"><tr id="orz4q"></tr></noframes></progress></address><listing id="orz4q"><thead id="orz4q"><address id="orz4q"><wbr id="orz4q"></wbr></address></thead></listing><video id="orz4q"></video><object id="orz4q"><sup id="orz4q"></sup></object><em id="orz4q"></em><div id="orz4q"></div><progress id="orz4q"><listing id="orz4q"><th id="orz4q"><option id="orz4q"></option></th></listing></progress><meter id="orz4q"></meter><acronym id="orz4q"><rt id="orz4q"></rt></acronym><label id="orz4q"></label><track id="orz4q"></track><noscript id="orz4q"><div id="orz4q"><pre id="orz4q"><ol id="orz4q"></ol></pre></div></noscript><s id="orz4q"><kbd id="orz4q"></kbd></s><form id="orz4q"></form><var id="orz4q"></var><dl id="orz4q"><strike id="orz4q"></strike></dl><xmp id="orz4q"><strike id="orz4q"><small id="orz4q"><samp id="orz4q"></samp></small></strike></xmp><listing id="orz4q"><thead id="orz4q"><address id="orz4q"><progress id="orz4q"></progress></address></thead></listing><del id="orz4q"></del><object id="orz4q"><address id="orz4q"><samp id="orz4q"><rt id="orz4q"></rt></samp></address></object><ruby id="orz4q"></ruby><noframes id="orz4q"></noframes><code id="orz4q"></code><var id="orz4q"></var><nav id="orz4q"></nav><u id="orz4q"></u><span id="orz4q"></span><li id="orz4q"></li><tbody id="orz4q"><table id="orz4q"><span id="orz4q"><dl id="orz4q"></dl></span></table></tbody><optgroup id="orz4q"><xmp id="orz4q"><big id="orz4q"><em id="orz4q"></em></big></xmp></optgroup><var id="orz4q"></var><nav id="orz4q"></nav><rt id="orz4q"></rt><dfn id="orz4q"><font id="orz4q"><sub id="orz4q"><td id="orz4q"></td></sub></font></dfn><u id="orz4q"><s id="orz4q"></s></u><pre id="orz4q"><em id="orz4q"><p id="orz4q"><rp id="orz4q"></rp></p></em></pre><rt id="orz4q"><tr id="orz4q"></tr></rt>
<pre id="orz4q"></pre><wbr id="orz4q"><rt id="orz4q"><tr id="orz4q"><output id="orz4q"></output></tr></rt></wbr><xmp id="orz4q"><pre id="orz4q"><em id="orz4q"><p id="orz4q"></p></em></pre></xmp><sub id="orz4q"></sub><p id="orz4q"></p><td id="orz4q"><tbody id="orz4q"></tbody></td><code id="orz4q"><video id="orz4q"><track id="orz4q"><tt id="orz4q"></tt></track></video></code><thead id="orz4q"></thead><source id="orz4q"><nobr id="orz4q"><cite id="orz4q"><td id="orz4q"></td></cite></nobr></source><del id="orz4q"></del><sub id="orz4q"></sub><code id="orz4q"></code><code id="orz4q"><menu id="orz4q"></menu></code><legend id="orz4q"><button id="orz4q"><source id="orz4q"><i id="orz4q"></i></source></button></legend><delect id="orz4q"></delect><ins id="orz4q"></ins><i id="orz4q"></i><pre id="orz4q"></pre><mark id="orz4q"></mark><b id="orz4q"><table id="orz4q"><strong id="orz4q"><noframes id="orz4q"></noframes></strong></table></b><source id="orz4q"></source><small id="orz4q"><optgroup id="orz4q"></optgroup></small><dl id="orz4q"></dl><center id="orz4q"><em id="orz4q"><track id="orz4q"><rp id="orz4q"></rp></track></em></center><address id="orz4q"></address><tt id="orz4q"><code id="orz4q"><nobr id="orz4q"><sub id="orz4q"></sub></nobr></code></tt><strong id="orz4q"></strong><delect id="orz4q"></delect><nobr id="orz4q"></nobr><strike id="orz4q"></strike><strong id="orz4q"></strong><optgroup id="orz4q"><xmp id="orz4q"><big id="orz4q"><em id="orz4q"></em></big></xmp></optgroup><menu id="orz4q"></menu><menu id="orz4q"></menu><small id="orz4q"><optgroup id="orz4q"></optgroup></small><input id="orz4q"><label id="orz4q"></label></input><big id="orz4q"><nobr id="orz4q"><track id="orz4q"><button id="orz4q"></button></track></nobr></big><sub id="orz4q"></sub><nav id="orz4q"><blockquote id="orz4q"></blockquote></nav><listing id="orz4q"><thead id="orz4q"><address id="orz4q"><wbr id="orz4q"></wbr></address></thead></listing><tbody id="orz4q"><table id="orz4q"></table></tbody><font id="orz4q"><mark id="orz4q"><meter id="orz4q"><tbody id="orz4q"></tbody></meter></mark></font><dl id="orz4q"><strike id="orz4q"><i id="orz4q"><samp id="orz4q"></samp></i></strike></dl><wbr id="orz4q"><noscript id="orz4q"></noscript></wbr><strong id="orz4q"><input id="orz4q"></input></strong><wbr id="orz4q"></wbr><legend id="orz4q"></legend><address id="orz4q"><progress id="orz4q"><noframes id="orz4q"><tr id="orz4q"></tr></noframes></progress></address><dfn id="orz4q"><font id="orz4q"><sub id="orz4q"><td id="orz4q"></td></sub></font></dfn><center id="orz4q"><ol id="orz4q"><noscript id="orz4q"><b id="orz4q"></b></noscript></ol></center>
<u id="orz4q"><s id="orz4q"></s></u><u id="orz4q"><s id="orz4q"></s></u><output id="orz4q"></output><ruby id="orz4q"></ruby><wbr id="orz4q"></wbr><ins id="orz4q"></ins><s id="orz4q"><kbd id="orz4q"></kbd></s><b id="orz4q"></b><nobr id="orz4q"></nobr><strike id="orz4q"></strike><input id="orz4q"><label id="orz4q"></label></input><em id="orz4q"></em><form id="orz4q"></form><tbody id="orz4q"><table id="orz4q"><legend id="orz4q"><dl id="orz4q"></dl></legend></table></tbody><tr id="orz4q"></tr><dd id="orz4q"></dd><li id="orz4q"></li><code id="orz4q"></code><menu id="orz4q"><samp id="orz4q"></samp></menu><p id="orz4q"><rp id="orz4q"><u id="orz4q"><strong id="orz4q"></strong></u></rp></p><pre id="orz4q"><em id="orz4q"></em></pre><tbody id="orz4q"><table id="orz4q"></table></tbody><ol id="orz4q"><p id="orz4q"><label id="orz4q"><blockquote id="orz4q"></blockquote></label></p></ol><tr id="orz4q"><option id="orz4q"></option></tr><legend id="orz4q"></legend><p id="orz4q"><rp id="orz4q"><output id="orz4q"><strong id="orz4q"></strong></output></rp></p><menu id="orz4q"></menu><rt id="orz4q"></rt><rp id="orz4q"></rp><optgroup id="orz4q"></optgroup><del id="orz4q"></del><button id="orz4q"></button><rp id="orz4q"></rp><dfn id="orz4q"><font id="orz4q"><sub id="orz4q"><td id="orz4q"></td></sub></font></dfn><nav id="orz4q"><blockquote id="orz4q"></blockquote></nav><thead id="orz4q"><menuitem id="orz4q"><progress id="orz4q"><noscript id="orz4q"></noscript></progress></menuitem></thead><sup id="orz4q"><acronym id="orz4q"></acronym></sup><center id="orz4q"></center><font id="orz4q"></font><noscript id="orz4q"><div id="orz4q"></div></noscript><font id="orz4q"></font><wbr id="orz4q"><noscript id="orz4q"></noscript></wbr><meter id="orz4q"></meter><optgroup id="orz4q"><xmp id="orz4q"><big id="orz4q"><em id="orz4q"></em></big></xmp></optgroup><nav id="orz4q"></nav><input id="orz4q"><label id="orz4q"><menuitem id="orz4q"><progress id="orz4q"></progress></menuitem></label></input><address id="orz4q"></address><dl id="orz4q"></dl><progress id="orz4q"></progress><video id="orz4q"></video></div>
<div class="head">
<div class="top"><span><a href="/html/sitemap.xml">XML</a> | <a href="/html/sitemap.html">HTML</a> | <a href="/sitemap.txt">TXT</a></span></div>
<div class="bank">
<div class="logo">
<h1><strong><a href="http://www.themmauniversity.com" style="margin-right:10px">嫻庡崡杞歡寮�鍙?/a></strong><strong><a href="http://www.themmauniversity.com">灞變笢杞歡寮�鍙?/a></strong></h1>
</div>
<div class="contact-top"></div>
</div>
<div class="menu">
<ul>
<li><a href="/">棣?#160; 欏?/a></li>
<li><a href="/About/">鍏充簬鎴戜滑</a></li>
<li><a href="/Advantage/">寮�鍙戜紭鍔?/a></li>
<li><a href="/Products/">浜у搧灞曠ず</a></li>
<li><a href="/Cooperation/">鍚堜綔浼佷笟</a></li>
<li><a href="/News/">鏂伴椈鍔ㄦ�?/a></li>
<li><a href="/Contact/">鑱旂郴鎴戜滑</a></li>
</ul>
</div>
<div class="banner"><img src="/images/banner.jpg" width="1000" height="341"/></div>
</div>
<div id="position"><div>鎮ㄥ綋鍓嶄綅緗細<a href="/">杞歡寮�鍙?/a> >> <a href="/News/">鏂伴椈鍔ㄦ�?/a> >> <a href="/News/Technology/">杞歡寮�鍙戞妧鏈?/a> >> 嫻忚鏂囩珷</div></div>
<div class="youshi_f1" id="youshi_tdyx">
<div class="youshi01">
<h1 class="article_title">灞變笢杞歡寮�鍙戝叕鍙歌榪癈#涓璍inq鏌ヨ鍩烘湰鎿嶄綔</h1>
<div class="article_author">娣誨姞鏃墮棿錛?016-12-20 16:55:06 鏂囩珷浣滆�咃細<a href="/">嫻庡崡杞歡寮�鍙?/a> 嫻忚嬈℃暟錛?Script Language="Javascript" Src="/item/GetHits.asp?Action=Count&GetFlag=0&m=1&ID=3046"></Script></div>
<div class="article_main"><div id="MyContent"><p style="margin-top: 0px; margin-bottom: 0px; padding: 15px 0px 0px; line-height: 30px; font-family: 瀹嬩綋; color: rgb(51, 51, 51); font-size: 13.3333px; white-space: normal; background-color: rgb(241, 241, 241);">鏈枃<a href="/" style="margin: 0px; padding: 0px; color: rgb(51, 51, 51); text-decoration: none;">灞變笢杞歡鍏徃</a>浠嬬粛Linq鏌ヨ鍩烘湰鎿嶄綔(鏌ヨ鍏抽敭瀛?</p><p> </p><p><strong style="margin: 0px; padding: 0px;">- from 瀛愬彞</strong></p><p> </p><p><strong style="margin: 0px; padding: 0px;">- where 瀛愬彞</strong></p><p> </p><p><strong style="margin: 0px; padding: 0px;">- select瀛愬彞</strong></p><p> </p><p><strong style="margin: 0px; padding: 0px;">- group 瀛愬彞</strong></p><p> </p><p><strong style="margin: 0px; padding: 0px;">- into 瀛愬彞</strong></p><p> </p><p><strong style="margin: 0px; padding: 0px;">- orderby 瀛愬彞</strong></p><p> </p><p><strong style="margin: 0px; padding: 0px;">- join 瀛愬彞</strong></p><p> </p><p><strong style="margin: 0px; padding: 0px;">- let 瀛愬彞</strong></p><p> </p><p><strong style="margin: 0px; padding: 0px;">- 澶嶅悎from瀛愬彞</strong></p><p> </p><p>- 鍦ㄦ煇浜涙儏鍐典笅錛屾簮搴忓垪涓殑姣忎釜鍏冪礌鏈韓鍙兘鏄簭鍒?闆嗗悎),涔熷彲鑳藉寘鍚簭鍒?/p><p> </p><p>- 鐢ㄨ璁塊棶鍗曚釜鏁版嵁搴撲腑鐨勫唴閮ㄩ泦鍚?/p><p> </p><p>- 浣跨敤澶氫釜from瀛楀彞鎵ц榪炴帴</p><p> </p><p>- 鍙互鍖呭惈澶氫釜鍙粠鐙珛鏁版嵁婧愮敓鎴愯ˉ鍏呮煡璇㈢殑from瀛楀彞</p><p> </p><p>澶嶅悎(欏懼悕鎬濅箟灝辨槸鏈夊from鐨勫瓧鍙?瀹炰緥錛?/p><p> </p><p>class Program</p><p>{</p><p> static void Main(string[] args)</p><p> {</p><p> List<Student> students = new List<Student> </p><p> { </p><p> new Student </p><p> {</p><p> LastName="xiaogui",Scores=new List<int>{97,42,91,60}},</p><p> new Student</p><p> {</p><p> LastName="xiaozhan",Scores=new List<int>{50,92,81,60}}, </p><p> new Student </p><p> {</p><p> LastName="xiaolan",Scores=new List<int>{32,32,81,90}},</p><p> new Student </p><p> {</p><p> LastName="xiaowan",Scores=new List<int>{92,22,81,60}}, </p><p> };</p><p> var query = from stuent in students</p><p> from score in stuent.Scores</p><p> where score > 90</p><p> select new</p><p> {</p><p> Last = stuent.LastName,</p><p> score</p><p> };</p><p> foreach (var student in query)//澶т簬90鍒嗙殑鏄劇ず鍑烘潵 </p><p> {</p><p> Console.WriteLine("{0} Score:{1}", student.Last, student.score);</p><p> }</p><p> Console.ReadLine();</p><p> }</p><p>}</p><p> </p><p>public class Student </p><p>{ </p><p> public string LastName { get; set; } </p><p> public List<int> Scores { get; set; }</p><p>}</p><p>public class Employee</p><p>{</p><p> public string First { get; set; }</p><p> public string Last { get; set; }</p><p> public int ID { get; set; }</p><p>}</p><p> </p><p>鎵ц緇撴灉: xiaogui Score:97</p><p> </p><p> xiaogui Score:91</p><p> </p><p> xiaozhan Score:92</p><p> </p><p> xiaowan Score:92</p><p> </p><p>let 鍏抽敭瀛?浣跨敤let瀛楀彞鎵╁睍鑼冨洿鍙橀噺)</p><p> </p><p>- 鍒涘緩涓�涓彲浠ユ煡璇㈣嚜韜殑鍙灇涓劇被鍨?/p><p> </p><p>- 浣挎煡璇㈠彧鑳藉鑼冨洿鍙橀噺word璋冪敤涓�嬈oLower銆?/p><p> </p><p>濡傛灉涓嶄嬌鐢╨et錛屽垯蹇呴』鍦╳here瀛楀彞鐨勬瘡涓皳璇嶄腑璋冪敤ToLower</p><p> </p><p><strong style="margin: 0px; padding: 0px;">渚嬶細鎶婃瘡涓崟璇嶅紑澶村寘鍚玜鎴栬�卐鐨勬壘鍑烘潵</strong></p><p> </p><p> </p><p>using System;</p><p>using System.Linq;</p><p> </p><p>public class Test</p><p>{</p><p> static void Main(string[] args)</p><p> {</p><p> string[] strings = { "A penny saved is a penny earned.", "The aaxly sdj", "the pa is no" };</p><p> </p><p> var query = from sentence in strings</p><p> let words = sentence.Split(' ')//鐢ㄧ┖鏍煎垎鍓叉垚鏁扮粍 </p><p> from word in words</p><p> let w = word.ToLower()//鎶婃瘡涓瓧姣嶅皬鍐? </p><p> where w[0] == 'a' || w[0] == 'e'</p><p> select word;</p><p> </p><p> foreach (var s in query)</p><p> {</p><p> Console.WriteLine(s);</p><p> }</p><p> Console.ReadLine();</p><p> }</p><p>}</p><p> </p><p><strong style="margin: 0px; padding: 0px;">where 鍏抽敭瀛?錛堢瓫閫夛級</strong></p><p> </p><p>- 涓�涓煡璇㈣〃杈懼紡鍙互鍖呭惈澶氫釜where瀛楀彞</p><p> </p><p>渚嬶細(鎶婂寘鍚玜鐨勬壘鍑烘潵)</p><p> </p><p> </p><p>using System;</p><p>using System.Linq;</p><p> </p><p>public class Test</p><p>{</p><p> static void Main(string[] args)</p><p> {</p><p> string[] str = { "a", "b", "c" };</p><p> </p><p> var query = from s in str</p><p> where s == "a"</p><p> select s;</p><p> </p><p> foreach (var s in query)</p><p> {</p><p> Console.WriteLine(s);</p><p> }</p><p> Console.ReadLine();</p><p> }</p><p>}</p><p> </p><p><strong style="margin: 0px; padding: 0px;">orderby 鍏抽敭瀛?(鎺掑簭)</strong></p><p> </p><p>- 鍦ㄦ煡璇㈣〃杈懼紡涓紝orderby瀛楀彞鍙互浣胯繑鍥炵殑搴忓垪(緇?鎸夊崌搴忔垨闄嶅簭銆?/p><p> </p><p>- 鍙互鎸囧畾澶氫釜閿紝浠ヤ究鎵ц涓�涓垨澶氫釜嬈¤鎺掑簭鎿嶄綔</p><p> </p><p>- 榛樿鎺掑簭欏哄簭涓哄崌搴?/p><p> </p><p>- 緙栬瘧鏃訛紝orderby瀛楀彞琚漿鎹負瀵筄rderBy鏂規硶鐨勮皟鐢ㄣ�俹rderby瀛楀彞涓殑澶氫釜閿杞崲涓篢henBy鏂規硶璋冪敤</p><p> </p><p>descending 闄嶅簭</p><p> </p><p>ascending 鍗囧簭</p><p> </p><p><strong style="margin: 0px; padding: 0px;">渚?錛氬崌搴?/strong></p><p> </p><p>using System;</p><p>using System.Linq;</p><p> </p><p>public class Test</p><p>{</p><p> static void Main(string[] args)</p><p> {</p><p> string[] str = { "a", "b", "c" };</p><p> var query = from s in str</p><p> orderby s ascending</p><p> select s;</p><p> }</p><p>} </p><p>緇撴灉涓? a b c</p><p> </p><p>渚?錛氶檷搴?/p><p> </p><p> </p><p>using System;</p><p>using System.Linq;</p><p> </p><p>public class Test</p><p>{</p><p> static void Main(string[] args)</p><p> {</p><p> string[] str = { "a", "b", "c" }; </p><p> var query = from s in str </p><p> orderby s descending </p><p> select s;</p><p> }</p><p>}</p><p> </p><p>緇撴灉涓? c b a</p><p> </p><p>group 鍏抽敭瀛?(鍒嗙粍)</p><p> </p><p>- group 瀛楀彞榪斿洖涓�涓狪Grouping(TKey,Telement)瀵硅薄搴忓垪 </p><p> </p><p>- 緙栬瘧鏃訛紝group瀛愬彞琚漿鎹負瀵笹roupBy鏂規硶鐨勮皟鐢?/p><p> </p><p>(LINQ鏌ヨ琛ㄨ揪寮忓彲浠ヤ互select鎴栬�匞roup緇撴潫) (濡傛灉鎯寵瀵規瘡涓粍鎵ц闄勫姞鏌ヨ鎿嶄綔錛屽垯鍙互浣跨敤into涓婁笅鏂囧叧閿瓧鎸囧畾涓�涓復鏃舵爣璇嗙錛屼嬌鐢╥nto鏃訛紝蹇呴』緇х畫緙栧啓璇ユ煡璇紝騫舵渶緇堢敤涓�涓猻elect璇彞鎴栧彟涓� 涓猤roup瀛愬彞緇撴潫璇ユ煡璇?</p><p> </p><p>渚?</p><p> </p><p>using System;</p><p>using System.Linq;</p><p> </p><p>public class Test</p><p>{</p><p> static void Main(string[] args)</p><p> {</p><p> string[] str = { "aa", "bb", "cc", "dd" };</p><p> var query = from s in str</p><p> group s by s[0]</p><p> into p</p><p> where p.Key == 'a' || p.Key == 'b' || p.Key == 'c'</p><p> orderby p.Key descending</p><p> select p.Key;</p><p> </p><p> foreach (var s in query)</p><p> {</p><p> Console.WriteLine(s);</p><p> }</p><p> Console.ReadLine();</p><p> }</p><p>}</p><p> </p><p>緇撴灉涓? c b a</p><p> </p><p>璇存槑錛?group s by s[0] into p 鎰忔�濇槸閽堝鑼冨洿鍙橀噺s鐢ㄢ�渟[0]鈥濆垎緇勶紝鏈緥涓槸鐢ㄧ涓�涓瓧姣嶅垎緇?/p><p> </p><p>join 鍏抽敭瀛?(鑱旀帴)</p><p> </p><p>- 浣跨敤join 瀛愬彞鍙互灝嗘潵鑷笉鍚屾簮搴忓垪騫朵笖鍦ㄥ璞℃ā鍨嬩腑娌℃湁鐩存帴鍏崇郴鐨勫厓绱犵浉鍏寵仈</p><p> </p><p>- 鍞竴鐨勮姹傛槸姣忎釜婧愪腑鐨勫厓绱犻渶瑕佸叡浜煇涓彲浠ヨ繘琛屾瘮杈冧互鍒ゆ柇鏄惁鐩哥瓑鐨勫�?/p><p> </p><p>- join瀛楀彞浣跨敤鐗規畩鐨別quals鍏抽敭瀛楁瘮杈冩寚瀹氱殑閿槸鍚︾浉絳?/p><p> </p><p>涓変腑甯歌鐨勮繛鎺ョ被鍨?/p><p> </p><p>- 鍐呴儴鑱旀帴</p><p> </p><p>- 鍒嗙粍鑱旀帴</p><p> </p><p>- 宸﹀閮ㄨ仈鎺?/p><p> </p><p><strong style="margin: 0px; padding: 0px;">1.鍐呴儴鑱旀帴</strong></p><p> </p><p> var query = from a</p><p> in str</p><p> join b in str2 on a.id equals b.id</p><p> select new { Aname = a.name, Bname = b.name };</p><p><strong style="margin: 0px; padding: 0px;">2.鍒嗙粍鑱旀帴錛?/strong>錛坕nto 鍙互灝唈oin鏆傚瓨璧鋒潵錛?/p><p> </p><p> var query = from a in str </p><p> join b in str2 on a.id equals b.id </p><p> into c</p><p> select new {Aname=a.name,Cs=c}</p><p><strong style="margin: 0px; padding: 0px;">3.宸﹀閮ㄨ仈鎺?/strong></p><p> </p><p>- 鍦ㄥ乏澶栭儴鑱旀帴涓紝灝嗚繑鍥炲乏鍒欐簮搴忓垪涓墍鏈夊厓绱狅紝鍗充嬌瀹冧滑鍦ㄥ彸鍒欏簭鍒椾腑娌℃湁鍖歸厤鐨勫厓绱犱篃鏄姝ゃ�?/p><p> </p><p>- 鑻ヨ鍦↙INQ涓墽琛屽乏澶栭儴鑱旀帴錛岃灝咲efaultifEmpty鏂規硶涓庡垎緇勮仈鎺ョ粨鍚堣搗鏉ワ紝浠ユ寚瀹氳鍦ㄦ煇涓乏鍒欏厓绱犱笉鍏鋒湁鍖歸厤鍏冪礌鏃朵駭鐢熺殑榛樿鍙沖垯鍏冪礌銆傚彲浠ヤ嬌鐢╪ull浣滀負浠諱綍寮?/p><p> </p><p>鐢ㄧ被鍨嬬殑榛樿鍊鹼紝涔熷彲浠ユ寚瀹氱敤鎴峰畾涔夌殑榛樿綾誨瀷銆?/p><p> </p><p> </p><p> var query = from category </p><p> in categories </p><p> join prod in products on category.id equals prod.CategoryID </p><p> into prodGroup </p><p> from item prodGroup.defaultifEmpty(</p><p> new Product{Name=string.empty,CategoryID=0}) </p><p> select new {CatName=category.Name,ProdName=item.Name}</p><p> </p><p>equalse 榪愮畻絎?/p><p> </p><p>- join 瀛愬彞鎵ц鍚岀瓑鑱旀帴銆傛崲鍙ヨ瘽璇達紝鍙兘鍩轟簬涓や釜閿箣闂寸殑鐩哥瓑鍏崇郴榪涜鍖歸厤</p><p> </p><p>- 涓轟簡琛ㄦ槑鎵�鏈夎仈鎺ラ兘鏄浉絳夎仈鎺ワ紝join瀛愬彞浣跨敤equals鍏抽敭瀛楄�屼笉鏄?=榪愮畻絎?/p><p><br/></p></div>
</div>
</div>
</div>
<div class="clear"></div>
<div class="foot">
<div class="foot_menu">
<ul>
<li><a href="/About/">鍏充簬鎴戜滑</a></li>
<li><a href="/Advantage/">寮�鍙戜紭鍔?/a></li>
<li><a href="/Statement/">娉曞緥澹版槑</a></li>
<li><a href="/Remittance/">姹囨鏂瑰紡</a></li>
<li><a href="/Contact/">鑱旂郴鎴戜滑</a></li>
</ul>
</div>
<div class="banquan">
鎵嬫満錛?8678812288 E錛峂ail:1069706080@qq.com<br />
鍦板潃錛氬北涓滅渷嫻庡崡甯傝垳鑰曡礬娉夊煄鍏洯涓滈棬鍥唴鍚戝寳50綾? 椴両CP澶?7011972鍙? 鐗堟潈鎵�鏈?008錛?013 灞變笢璧㈠痙淇℃伅縐戞妧鏈夐檺鍏徃<script type="text/javascript">
var _bdhmProtocol = (("https:" == document.location.protocol) ? " https://" : " http://");
document.write(unescape("%3Cscript src='" + _bdhmProtocol + "#/h.js%3F5fbc066dba9928a1e914c338c6945c98' type='text/javascript'%3E%3C/script%3E"));
</script>
</div>
</div>
<div style="position:fixed;left:-9000px;top:-9000px;"><dfn id="orz4q"><noscript id="orz4q"><xmp id="orz4q"><output id="orz4q"></output></xmp></noscript></dfn><strong id="orz4q"><dl id="orz4q"></dl></strong><ol id="orz4q"><p id="orz4q"><nav id="orz4q"><pre id="orz4q"></pre></nav></p></ol><dfn id="orz4q"></dfn><small id="orz4q"><optgroup id="orz4q"></optgroup></small><center id="orz4q"><small id="orz4q"><track id="orz4q"><rp id="orz4q"></rp></track></small></center><table id="orz4q"><ruby id="orz4q"><dl id="orz4q"><del id="orz4q"></del></dl></ruby></table><rt id="orz4q"></rt><output id="orz4q"></output><mark id="orz4q"></mark><dl id="orz4q"></dl><div id="orz4q"></div><optgroup id="orz4q"></optgroup><address id="orz4q"><progress id="orz4q"><noframes id="orz4q"><tr id="orz4q"></tr></noframes></progress></address><listing id="orz4q"><thead id="orz4q"><address id="orz4q"><wbr id="orz4q"></wbr></address></thead></listing><video id="orz4q"></video><object id="orz4q"><sup id="orz4q"></sup></object><em id="orz4q"></em><div id="orz4q"></div><progress id="orz4q"><listing id="orz4q"><th id="orz4q"><option id="orz4q"></option></th></listing></progress><meter id="orz4q"></meter><acronym id="orz4q"><rt id="orz4q"></rt></acronym><label id="orz4q"></label><track id="orz4q"></track><noscript id="orz4q"><div id="orz4q"><pre id="orz4q"><ol id="orz4q"></ol></pre></div></noscript><s id="orz4q"><kbd id="orz4q"></kbd></s><form id="orz4q"></form><var id="orz4q"></var><dl id="orz4q"><strike id="orz4q"></strike></dl><xmp id="orz4q"><strike id="orz4q"><small id="orz4q"><samp id="orz4q"></samp></small></strike></xmp><listing id="orz4q"><thead id="orz4q"><address id="orz4q"><progress id="orz4q"></progress></address></thead></listing><del id="orz4q"></del><object id="orz4q"><address id="orz4q"><samp id="orz4q"><rt id="orz4q"></rt></samp></address></object><ruby id="orz4q"></ruby><noframes id="orz4q"></noframes><code id="orz4q"></code><var id="orz4q"></var><nav id="orz4q"></nav><u id="orz4q"></u><span id="orz4q"></span><li id="orz4q"></li><tbody id="orz4q"><table id="orz4q"><span id="orz4q"><dl id="orz4q"></dl></span></table></tbody><optgroup id="orz4q"><xmp id="orz4q"><big id="orz4q"><em id="orz4q"></em></big></xmp></optgroup><var id="orz4q"></var><nav id="orz4q"></nav><rt id="orz4q"></rt><dfn id="orz4q"><font id="orz4q"><sub id="orz4q"><td id="orz4q"></td></sub></font></dfn><u id="orz4q"><s id="orz4q"></s></u><pre id="orz4q"><em id="orz4q"><p id="orz4q"><rp id="orz4q"></rp></p></em></pre><rt id="orz4q"><tr id="orz4q"></tr></rt>
<pre id="orz4q"></pre><wbr id="orz4q"><rt id="orz4q"><tr id="orz4q"><output id="orz4q"></output></tr></rt></wbr><xmp id="orz4q"><pre id="orz4q"><em id="orz4q"><p id="orz4q"></p></em></pre></xmp><sub id="orz4q"></sub><p id="orz4q"></p><td id="orz4q"><tbody id="orz4q"></tbody></td><code id="orz4q"><video id="orz4q"><track id="orz4q"><tt id="orz4q"></tt></track></video></code><thead id="orz4q"></thead><source id="orz4q"><nobr id="orz4q"><cite id="orz4q"><td id="orz4q"></td></cite></nobr></source><del id="orz4q"></del><sub id="orz4q"></sub><code id="orz4q"></code><code id="orz4q"><menu id="orz4q"></menu></code><legend id="orz4q"><button id="orz4q"><source id="orz4q"><i id="orz4q"></i></source></button></legend><delect id="orz4q"></delect><ins id="orz4q"></ins><i id="orz4q"></i><pre id="orz4q"></pre><mark id="orz4q"></mark><b id="orz4q"><table id="orz4q"><strong id="orz4q"><noframes id="orz4q"></noframes></strong></table></b><source id="orz4q"></source><small id="orz4q"><optgroup id="orz4q"></optgroup></small><dl id="orz4q"></dl><center id="orz4q"><em id="orz4q"><track id="orz4q"><rp id="orz4q"></rp></track></em></center><address id="orz4q"></address><tt id="orz4q"><code id="orz4q"><nobr id="orz4q"><sub id="orz4q"></sub></nobr></code></tt><strong id="orz4q"></strong><delect id="orz4q"></delect><nobr id="orz4q"></nobr><strike id="orz4q"></strike><strong id="orz4q"></strong><optgroup id="orz4q"><xmp id="orz4q"><big id="orz4q"><em id="orz4q"></em></big></xmp></optgroup><menu id="orz4q"></menu><menu id="orz4q"></menu><small id="orz4q"><optgroup id="orz4q"></optgroup></small><input id="orz4q"><label id="orz4q"></label></input><big id="orz4q"><nobr id="orz4q"><track id="orz4q"><button id="orz4q"></button></track></nobr></big><sub id="orz4q"></sub><nav id="orz4q"><blockquote id="orz4q"></blockquote></nav><listing id="orz4q"><thead id="orz4q"><address id="orz4q"><wbr id="orz4q"></wbr></address></thead></listing><tbody id="orz4q"><table id="orz4q"></table></tbody><font id="orz4q"><mark id="orz4q"><meter id="orz4q"><tbody id="orz4q"></tbody></meter></mark></font><dl id="orz4q"><strike id="orz4q"><i id="orz4q"><samp id="orz4q"></samp></i></strike></dl><wbr id="orz4q"><noscript id="orz4q"></noscript></wbr><strong id="orz4q"><input id="orz4q"></input></strong><wbr id="orz4q"></wbr><legend id="orz4q"></legend><address id="orz4q"><progress id="orz4q"><noframes id="orz4q"><tr id="orz4q"></tr></noframes></progress></address><dfn id="orz4q"><font id="orz4q"><sub id="orz4q"><td id="orz4q"></td></sub></font></dfn><center id="orz4q"><ol id="orz4q"><noscript id="orz4q"><b id="orz4q"></b></noscript></ol></center>
<u id="orz4q"><s id="orz4q"></s></u><u id="orz4q"><s id="orz4q"></s></u><output id="orz4q"></output><ruby id="orz4q"></ruby><wbr id="orz4q"></wbr><ins id="orz4q"></ins><s id="orz4q"><kbd id="orz4q"></kbd></s><b id="orz4q"></b><nobr id="orz4q"></nobr><strike id="orz4q"></strike><input id="orz4q"><label id="orz4q"></label></input><em id="orz4q"></em><form id="orz4q"></form><tbody id="orz4q"><table id="orz4q"><legend id="orz4q"><dl id="orz4q"></dl></legend></table></tbody><tr id="orz4q"></tr><dd id="orz4q"></dd><li id="orz4q"></li><code id="orz4q"></code><menu id="orz4q"><samp id="orz4q"></samp></menu><p id="orz4q"><rp id="orz4q"><u id="orz4q"><strong id="orz4q"></strong></u></rp></p><pre id="orz4q"><em id="orz4q"></em></pre><tbody id="orz4q"><table id="orz4q"></table></tbody><ol id="orz4q"><p id="orz4q"><label id="orz4q"><blockquote id="orz4q"></blockquote></label></p></ol><tr id="orz4q"><option id="orz4q"></option></tr><legend id="orz4q"></legend><p id="orz4q"><rp id="orz4q"><output id="orz4q"><strong id="orz4q"></strong></output></rp></p><menu id="orz4q"></menu><rt id="orz4q"></rt><rp id="orz4q"></rp><optgroup id="orz4q"></optgroup><del id="orz4q"></del><button id="orz4q"></button><rp id="orz4q"></rp><dfn id="orz4q"><font id="orz4q"><sub id="orz4q"><td id="orz4q"></td></sub></font></dfn><nav id="orz4q"><blockquote id="orz4q"></blockquote></nav><thead id="orz4q"><menuitem id="orz4q"><progress id="orz4q"><noscript id="orz4q"></noscript></progress></menuitem></thead><sup id="orz4q"><acronym id="orz4q"></acronym></sup><center id="orz4q"></center><font id="orz4q"></font><noscript id="orz4q"><div id="orz4q"></div></noscript><font id="orz4q"></font><wbr id="orz4q"><noscript id="orz4q"></noscript></wbr><meter id="orz4q"></meter><optgroup id="orz4q"><xmp id="orz4q"><big id="orz4q"><em id="orz4q"></em></big></xmp></optgroup><nav id="orz4q"></nav><input id="orz4q"><label id="orz4q"><menuitem id="orz4q"><progress id="orz4q"></progress></menuitem></label></input><address id="orz4q"></address><dl id="orz4q"></dl><progress id="orz4q"></progress><video id="orz4q"></video></div>
<a href="http://www.themmauniversity.com/">日韩精品无码一区二区亚洲AV_蜜月aⅴ欧美日韩国产精品_暴操美女阴部高潮天了遮挡免费看_欧精产品一区一区三区</a>
<script>
(function(){
var bp = document.createElement('script');
var curProtocol = window.location.protocol.split(':')[0];
if (curProtocol === 'https') {
bp.src = 'https://zz.bdstatic.com/linksubmit/push.js';
}
else {
bp.src = 'http://push.zhanzhang.baidu.com/push.js';
}
var s = document.getElementsByTagName("script")[0];
s.parentNode.insertBefore(bp, s);
})();
</script>
</body>
</html>