Order by descending : OrderBy « LINQ « C# / CSharp Tutorial

Home
C# / CSharp Tutorial
1.Language Basics
2.Data Type
3.Operator
4.Statement
5.String
6.struct
7.Class
8.Operator Overload
9.delegate
10.Attribute
11.Data Structure
12.Assembly
13.Date Time
14.Development
15.File Directory Stream
16.Preprocessing Directives
17.Regular Expression
18.Generic
19.Reflection
20.Thread
21.I18N Internationalization
22.LINQ
23.GUI Windows Forms
24.Windows Presentation Foundation
25.Windows Communication Foundation
26.Workflow
27.2D
28.Design Patterns
29.Windows
30.XML
31.XML LINQ
32.ADO.Net
33.Network
34.Directory Services
35.Security
36.unsafe
C# / C Sharp
C# / C Sharp by API
C# / CSharp Open Source
C# / CSharp Tutorial » LINQ » OrderBy 
22.10.16.Order by descending
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

    class Employee
    {
        public string Name get; set; }
        public decimal Salary get; set; }
    }

    class Department
    {
        public string Name get; set; }

        List<Employee> employees = new List<Employee>();

        public IList<Employee> Employees
        {
            get return employees; }
        }
    }

    class Company
    {
        public string Name get; set; }

        List<Department> departments = new List<Department>();

        public IList<Department> Departments
        {
            get return departments; }
        }
    }

    class SalaryReport
    {
        static void Main()
        {
            var company = new Company
            {
                Name = "A",
                Departments =
                {
                    new Department 
                    
                        Name = "Development"
                        Employees = 
                        {
                            new Employee Name = "T", Salary = 75000},
                            new Employee Name = "D", Salary = 45000},
                            new Employee Name = "M", Salary = 150000}
                        }
                    },
                    new Department 
                    
                        Name = "Marketing"
                        Employees = 
                        {
                            new Employee Name = "Z", Salary = 200000},
                            new Employee Name = "X", Salary = 120000}
                        }
                    }
                }
            };

            var query = company.Departments
                               .Select(dept => new dept.Name, Cost = dept.Employees.Sum(person => person.Salary) })
                               .OrderByDescending(deptWithCost => deptWithCost.Cost);

            foreach (var item in query)
            {
                Console.WriteLine(item);
            }
        }
    }
22.10.OrderBy
22.10.1.OrderBy: prints an alphabetically sorted version of a string array
22.10.2.string array sorted by the length each element
22.10.3.products sorted alphabetically by the product name
22.10.4.OrderBy with customized Comparer
22.10.5.OrderBy with passing a lambda function
22.10.6.OrderBy Descending
22.10.7.products sorted by the number of units of each product that are in stock
22.10.8.sorted alphabetically in descending order, using a case insensitive comparision.
22.10.9.Using a compound orderby to sort a list of digits first by length of their name, and then alphabetically.
22.10.10.An array of string values sorted first by length, then sorted alphabetically, using a case-insentive comparison.
22.10.11.Using a compound orderby to sort a list of products, first by category, and then by unit price, from highest to lowest.
22.10.12.First OrderBy Prototype
22.10.13.Where with OrderBy
22.10.14.Order Method Syntax
22.10.15.Order Query Results
22.10.16.Order by descending
22.10.17.Sort object by its property
22.10.18.Sorted join query
22.10.19.Sorting strings in a file
22.10.20.Top Five Customers by Sales
22.10.21.Ordered by PetName
22.10.22.Multi Level Ordering
22.10.23.Not in Top Five Customers by Sales
22.10.24.Icecreams with Least Price
22.10.25.Using orderby clause to order result
www.java2java.com | Contact Us
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.