Get Top Five Customers by Sales in CSharp
Description
The following code shows how to get Top Five Customers by Sales.
Example
//from ww w. java 2s . c o m
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
class Customer
{
public string ID { get; set; }
public string City { get; set; }
public string Country { get; set; }
public string Region { get; set; }
public decimal Sales { get; set; }
}
class Program
{
static void Main(string[] args)
{
List<Customer> customers = new List<Customer> {
new Customer { ID="N", City="Los Angeles", Country="USA", Region="North America", Sales=5000 },
new Customer { ID="O", City="Cairo", Country="Egypt", Region="Africa", Sales=6000 },
new Customer { ID="R", City="Beijing", Country="China", Region="Asia", Sales=9000 },
new Customer { ID="T", City="Lima", Country="Peru", Region="South America", Sales=2002 }
};
var queryResults =
from c in customers
orderby c.Sales descending
select new { c.ID, c.City, c.Country, c.Sales }
;
Console.WriteLine("Top Five Customers by Sales");
foreach (var item in queryResults.Take(5))
{
Console.WriteLine(item);
}
}
}
The code above generates the following result.