Wednesday, 28 August 2013

Getting LINQ query result into a list?

Getting LINQ query result into a list?

I'm converting old code to use LINQ. The old code looked like this:
// Get Courses
sqlQuery = @"SELECT Comment.Comment, Status.StatusId,
Comment.DiscussionBoardId, DiscussionBoard.CourseId, Comment.CommentID
FROM Status INNER JOIN Comment ON Status.StatusId =
Comment.StatusId INNER JOIN
DiscussionBoard ON Comment.DiscussionBoardId =
DiscussionBoard.DiscussionBoardId
WHERE (DiscussionBoard.CourseID = 'CourseID')";
var comments = new
List<Comment>(dataContext.ExecuteQuery<Comment>(sqlQuery));
I've converted the above SQL to LINQ:
var db = new CMSDataContext();
var query = from 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
where d.CourseId == "CourseID" select new
{ d.ItemType, c.Comment1, s.Status1, c.DiscussionBoardId, d.CourseId,
c.CommentID };
The problem I've having, though, is with trying to get the results of the
query into the List. Can someone offer me some pointers?
Thanks!

No comments:

Post a Comment