<ruby id="bdb3f"></ruby>

    <p id="bdb3f"><cite id="bdb3f"></cite></p>

      <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
        <p id="bdb3f"><cite id="bdb3f"></cite></p>

          <pre id="bdb3f"></pre>
          <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

          <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
          <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

          <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                <ruby id="bdb3f"></ruby>

                ThinkChat2.0新版上線,更智能更精彩,支持會話、畫圖、視頻、閱讀、搜索等,送10W Token,即刻開啟你的AI之旅 廣告
                # 如何:對 Join 子句的結果進行排序(C# 編程指南) 此示例演示如何對聯接運算的結果進行排序。請注意,排序是在聯接之后執行的。盡管可以在聯接之前將 **orderby** 子句用于一個或多個源序列,但通常我們不建議這樣做。某些 LINQ 提供程序可能不會在聯接之后保留排序。 此查詢將創建一個分組聯接,然后基于類別元素(仍然在范圍中)對組進行排序。在匿名類型初始值設定項中,子查詢將對產品序列中的所有匹配元素進行排序。 ``` class HowToOrderJoins { #region Data class Product { public string Name { get; set; } public int CategoryID { get; set; } } class Category { public string Name { get; set; } public int ID { get; set; } } // Specify the first data source. List<Category> categories = new List<Category>() { new Category(){Name="Beverages", ID=001}, new Category(){ Name="Condiments", ID=002}, new Category(){ Name="Vegetables", ID=003}, new Category() { Name="Grains", ID=004}, new Category() { Name="Fruit", ID=005} }; // Specify the second data source. List<Product> products = new List<Product>() { new Product{Name="Cola", CategoryID=001}, new Product{Name="Tea", CategoryID=001}, new Product{Name="Mustard", CategoryID=002}, new Product{Name="Pickles", CategoryID=002}, new Product{Name="Carrots", CategoryID=003}, new Product{Name="Bok Choy", CategoryID=003}, new Product{Name="Peaches", CategoryID=005}, new Product{Name="Melons", CategoryID=005}, }; #endregion static void Main() { HowToOrderJoins app = new HowToOrderJoins(); app.OrderJoin1(); // Keep console window open in debug mode. Console.WriteLine("Press any key to exit."); Console.ReadKey(); } void OrderJoin1() { var groupJoinQuery2 = from category in categories join prod in products on category.ID equals prod.CategoryID into prodGroup orderby category.Name select new { Category = category.Name, Products = from prod2 in prodGroup orderby prod2.Name select prod2 }; foreach (var productGroup in groupJoinQuery2) { Console.WriteLine(productGroup.Category); foreach (var prodItem in productGroup.Products) { Console.WriteLine(" {0,-10} {1}", prodItem.Name, prodItem.CategoryID); } } } /* Output: Beverages Cola 1 Tea 1 Condiments Mustard 2 Pickles 2 Fruit Melons 5 Peaches 5 Grains Vegetables Bok Choy 3 Carrots 3 */ } ``` ## 編譯代碼 * 創建面向 .NET Framework 3.5 版的 Visual Studio 項目。默認情況下,該項目具有一個對 System.Core.dll 的引用以及一條針對 System.Linq 命名空間的 **using** 指令。 * 將代碼復制到項目中。 * 按 F5 編譯并運行程序。 * 按任意鍵退出控制臺窗口。 ## 請參閱 [LINQ 查詢表達式(C# 編程指南)](https://msdn.microsoft.com/zh-cn/library/bb397676.aspx) [orderby 子句(C# 參考)](https://msdn.microsoft.com/zh-cn/library/bb383982.aspx) [join 子句(C# 參考)](https://msdn.microsoft.com/zh-cn/library/bb311040.aspx) [Join Operations](https://msdn.microsoft.com/zh-cn/library/bb397908.aspx)
                  <ruby id="bdb3f"></ruby>

                  <p id="bdb3f"><cite id="bdb3f"></cite></p>

                    <p id="bdb3f"><cite id="bdb3f"><th id="bdb3f"></th></cite></p><p id="bdb3f"></p>
                      <p id="bdb3f"><cite id="bdb3f"></cite></p>

                        <pre id="bdb3f"></pre>
                        <pre id="bdb3f"><del id="bdb3f"><thead id="bdb3f"></thead></del></pre>

                        <ruby id="bdb3f"><mark id="bdb3f"></mark></ruby><ruby id="bdb3f"></ruby>
                        <pre id="bdb3f"><pre id="bdb3f"><mark id="bdb3f"></mark></pre></pre><output id="bdb3f"></output><p id="bdb3f"></p><p id="bdb3f"></p>

                        <pre id="bdb3f"><del id="bdb3f"><progress id="bdb3f"></progress></del></pre>

                              <ruby id="bdb3f"></ruby>

                              哎呀哎呀视频在线观看