---
title: "LINQ query for retrieving data from list"  
description: "LINQ query for retrieving data from list"  
author: "Anonymous User"  
published: 2014-08-18  
updated: 2014-08-18  
canonical: https://www.mindstick.com/forum/2044/linq-query-for-retrieving-data-from-list  
category: "c#"  
tags: ["c#"]  
reading_time: 1 minute  

---

# LINQ query for retrieving data from list

I have List [collection](https://www.mindstick.com/articles/1718/collections-in-java) of [Message](https://www.mindstick.com/forum/12802/show-confirmation-message-yes-or-no-in-asp-dot-net) objects.

```
public class Message{    public int Id {get; set; }    public string Body{ get; set; }    public string Sender { get; set; }    public DateTime Timestamp { get; set; }}
```

I want to get only one message with most recent [Timestamp](https://www.mindstick.com/interview/791/what-does-timestamp-on-update-current_timestamp-data-type-do) for each sender. How do I do it using [LINQ](https://www.mindstick.com/articles/12007/language-integrated-query-linq-queries)?

## Replies

### Reply by Pravesh Singh

Hi Ankit, Try this:

var q = from n in table

group n by n.Senderinto g

select g.OrderByDescending(t=>t.Timestamp).FirstOrDefault();


---

Original Source: https://www.mindstick.com/forum/2044/linq-query-for-retrieving-data-from-list

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.