Getting LINQ query result into a list?

Question

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!

myermian · Accepted Answer · 2013-08-28 14:59:25Z

4

Try adding the ToList() method at the end of the query.

answered Aug 28, 2013 at 14:59

myermian

32.6k26 gold badges135 silver badges222 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Yaakov Ellis · Accepted Answer · 2013-08-28 14:59:55Z

2

Enclose the whole query in parentheses and add .ToList() at the end.

Or add another line:

var list = query.ToList();

answered Aug 28, 2013 at 14:59

Yaakov Ellis

41.7k27 gold badges135 silver badges185 bronze badges

1 Comment

Kevin Over a year ago

Awesome! That worked perfectly! I had no idea about the ToList method (I'm just now learning LINQ). Thanks so much! As soon as timer is up, I'll mark answer.

james · Accepted Answer · 2013-08-28 14:59:34Z

2

How about the ToList method: query.ToList() ?

answered Aug 28, 2013 at 14:59

james

13.4k9 gold badges50 silver badges74 bronze badges

Comments

Justin Niessner · Accepted Answer · 2013-08-28 15:01:50Z

1

You'll need to do two things.

First, change your select to create a new instance of Comment instead of an anonymous type.

Second, either wrap the whole query in a call to ToList() or store the results in a temporary variable and call ToList() on that variable to get the List<Comment> as a result.

answered Aug 28, 2013 at 15:01

Justin Niessner

246k40 gold badges416 silver badges546 bronze badges

Comments

Timothy Shields · Accepted Answer · 2013-08-28 15:02:00Z

1

Either (A) wrap the entire call with Enumerable.ToList(<your query>), (B) surround the entire query with parentheses and call the ToList extension method at the end, or (C) call query.ToList() as a separate statement.

answered Aug 28, 2013 at 15:02

Timothy Shields

80.3k21 gold badges127 silver badges173 bronze badges

Collectives™ on Stack Overflow

Getting LINQ query result into a list?

5 Answers 5

Comments

1 Comment

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related