asp.net - Getting LINQ query result into a list? -

i'm converting old code use linq. old code looked this:

// courses sqlquery = @"select comment.comment, status.statusid, comment.discussionboardid, discussionboard.courseid, comment.commentid             status inner join comment on status.statusid = comment.statusid inner join                 discussionboard on comment.discussionboardid = discussionboard.discussionboardid              (discussionboard.courseid = 'courseid')";  var comments = new list<comment>(datacontext.executequery<comment>(sqlquery)); 

i've converted above sql linq:

var db = new cmsdatacontext(); var query = c in db.comments                 join s in db.status on c.statusid equals s.statusid                 join d in db.discussionboards on c.discussionboardid equals d.discussionboardid                 d.courseid == "courseid"                 select new                       {                     d.itemtype,                     c.comment1,                     s.status1,                     c.discussionboardid,                     d.courseid,                     c.commentid                 }; 

the problem i've having, though, trying results of query list. can offer me pointers?

thanks!

enclose whole query in parentheses , add .tolist() @ end.

or add line:

var list = query.tolist();