Dynamic List of Messages

Question

select MessageText from Messages order by MessageTime

I'm trying to make LINQ to SQL query from this SQL query.

What i wan´t to do is to return a LIST of all the messages in my Messages table in my db ordered on MessageTime(datetime). But how do I do this to a Linq query?

Table is called Messages Rows MessageText(string) and MessageTime(datetime).

public IList<MessageByUser> GetAllMessages()
{
    var messlist = (m => m.MessageTime)
        .Select(m => OrderByDescending(y => y.MessageTime)
        .FirstOrDefault())
        .OrderByDescending(m => m.MessageTime);
}

I'm lost.... Any suggestions?

Answer 1

 var me = (from m in chat.Messages
                  orderby m.MessageTime descending
                  select new MessageByUser() { MessageText = m.MessageText }).ToList();
        return me;

This one worked finally for me.

Thank you all for your examples! I got me thinking and trying different methods. :)