Hey guys,
I am having problems expressing a query in Linq to NH. Basically, I
have a discussion forum. On the home page I want to display the
threads that have been discussed the most in the last week; not the
threads with the most posts overall - the ones with the most posts in
the last week.
I can do it easy in SQL like so:
select threadid, COUNT(*) from dbo.forummessages where date >
'02/07/2009' group by threadid order by 2 desc
but I can't seem to be able to express it in LINQ - can anyone help me
out?
Here is my best effort:
var newthreads = from m in forumMessageDao.Messages
where m.Date > DateTime.Now.AddDays(-7)
group m by m.Thread
into t orderby t.Count() select new {Thread = t.Key,
PostsThisWeek = t.Count()};
but I get an exception could not resolve property: Key of:
Core.Domain.ForumMessage
Any ideas?
Kevin.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/nhusers?hl=en
-~----------~----~----~----~------~----~------~--~---
