返回查询的最大值

本文关键字：最大值 查询 返回 | 更新日期: 2023-09-27 17:59:50

我想找到哪个员工的订单最多：这段代码带来了所有用户的所有订单计数：

    public void GetBestEmployeeFromDates(DateTime fromDate, DateTime toDate)
    {
        using (NorthwindDataContext db = new NorthwindDataContext())
        {
            var query =
                from z in db.Employees
                select new
                {
                    OrderNumber = z.Orders.Where(x => x.OrderDate > fromDate.Date).Count()
                };
        }
    }

我该怎么做？

返回查询的最大值

尝试使用MaxBy(http://code.google.com/p/morelinq/)：

var maxOrders = query.MaxBy(o => o.OrderNumbers);

您也可以调整您的查询以包括客户名称：

var query =
            from z in db.Employees
            select new
            {   
                Customer = z.CustomerName,
                OrderNumber = z.Orders.Where(x => x.OrderDate > fromDate.Date).Count()
            };
var person = query.OrderByDescending(o => o.OrderNumber).Select(c=>c.Customer).First();
Console.WriteLine("The customer with the most orders is: " + person);

我在想这样的事情：

using (NorthwindDataContext db = new NorthwindDataContext())
{
 var query =
   (from z in db.Employees
   select new
   {
      OrderNumber = z.Orders.Where(x => x.OrderDate > fromDate.Date).Count(),
      Employee = z
   }).OrderByDescending(x => OrderNumber).Select(x => x.Employee).FirstOrDefault()
}
相关文章：