LINQ GroupBy getting a specific element

Question

I have the following Object Structure

List<Order> orders = new List<Order>
        {
            new Order(){OrderId=1,UserId=1,OrderQuantity=10, OrderDescription="Desc", OrderDate=new DateTime(2012, 4, 16)},
            new Order(){OrderId=2,UserId=1,OrderQuantity=10, OrderDescription="Desc", OrderDate=new DateTime(2012, 4, 17)},
            new Order(){OrderId=3,UserId=1,OrderQuantity=10, OrderDescription="Desc", OrderDate=new DateTime(2012, 4, 18)},
            new Order(){OrderId=4,UserId=4,OrderQuantity=10, OrderDescription="Desc", OrderDate=new DateTime(2012, 4, 16)}
        };

I want to group by UserId and get only to the latest order for each user.  For example if I take UserId=1 then I want to get only OrderId=3 since that is the latest.  How can I do this using LINQ?

Answer 1

This might help you.

 class Program
    {
        static void Main(string[] args)
        {
            List<Order> orders = new List<Order>()
                {
            new Order(){OrderId=1,UserId=1,OrderQuantity=10, OrderDescription="Desc", OrderDate=new DateTime(2012, 4, 16)},
            new Order(){OrderId=2,UserId=1,OrderQuantity=10, OrderDescription="Desc", OrderDate=new DateTime(2012, 4, 17)},
            new Order(){OrderId=3,UserId=1,OrderQuantity=10, OrderDescription="Desc", OrderDate=new DateTime(2012, 4, 18)},
            new Order(){OrderId=4,UserId=4,OrderQuantity=10, OrderDescription="Desc", OrderDate=new DateTime(2012, 4, 16)}
                };

          var result= orders.Where(r => r.UserId == 1).Max(s => s.OrderId);
          Console.WriteLine(result);
        }


    }

    public class Order
    {
        public int OrderId { get; set; }

        public int UserId { get; set; }
        public int OrderQuantity { get; set; }
        public string OrderDescription { get; set; }
        public DateTime OrderDate { get; set; }
    }

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 2

orders.GroupBy(order => order.UserId)
.Select(group => new
{
  UserId = group.Key,
  LatestOrder = group.Max(order => order.OrderId),
});

Answer 3

I'd use this:

var results = from Order o in orders
                group o by o.UserId into g 
                select g.OrderByDescending(og => og.OrderDate).First();

Answer 4

Check following links, it may help you.

1. http://msdn.microsoft.com/en-us/library/bb386922.aspx
2. http://stackoverflow.com/questions/6827381/group-by-specific-time-ranges-in-linq
3. http://stackoverflow.com/questions/6827381/group-by-specific-time-ranges-in-linq

Answer 5

Based on Madirai`s class, you can do:

int _userID = 1;//your variable
int _oderID = orders.Where(w => w.UserId == _userID).OrderByDescending(o => o.OrderDate).Select(s => s.OrderId).First();

---

Mitja

Answer 6

I didn't check if it's more efficient but I find it more intuitive to select the order with the max OrderDate rather than selecting the first after ordering:

var results = from Order o in orders
                group o by o.UserId into g
                let max = g.Max(og => og.OrderDate)
                select g.First(og => og.OrderDate == max);