Hi green_green;
You can not reorder the collection that is attached to the topics table so what you can do is to create a result set that has the topic and also contains a list of post ordered in the way you need them.
var query = from t int DataContext.Topics
where t.CategoryId == CategoryId
select new
{
topic = t,
post = t.Posts.OrderByDescending( p => p.SendDate )
}
Fernando
If a post answers your question, please click "
Mark As Answer" on that post and "
Mark as Helpful".