How can I write this LINQ query as a Lambda expression?

Question

Here's my query expression:

ddCourse.DataSource = (from c in db.COURSE_MASTERs
                       orderby c.COURSE_TITLE 
                       select new { c.COURSE_ID, c.COURSE_TITLE }).ToList();

Just for the sake of knowledge, I'd like to know how to write this as a Lambda expression. Here is what I have so far:

ddCourse.DataSource = db.COURSE_MASTERs
                        .OrderBy(c => c.COURSE_TITLE)
                        .Select(c => {c.COURSE_ID, c.COURSE_TITLE})
                        .ToList();

Of course, what I have is wrong so I'm hoping that someone can help point me in the right direction? Again, the only reason I'm doing this is for the sake of knowledge.

Read (and post) the error messages. In this case the "red squiggle" would have given a good indication of where/what the issue was. (I'm really not sure why this is getting voted up :>) — user2246674
– user2246674, Commented Sep 18, 2013 at 20:59

dtb · Accepted Answer · 2013-09-18 20:58:20Z

7

You forgot new:

.Select(c => new { c.COURSE_ID, c.COURSE_TITLE })

answered Sep 18, 2013 at 20:58

dtb

218k37 gold badges413 silver badges438 bronze badges

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

1 Comment

Kevin Over a year ago

That was it! My thanks! I'll mark the answer as soon a the timer is up. I appreciate it!

Erik Philips · Accepted Answer · 2013-09-18 20:58:30Z

1

Missing the new keyword:

ddCourse.DataSource = db.COURSE_MASTERs
  .OrderBy(c => c.COURSE_TITLE)
  .Select(c => new {c.COURSE_ID, c.COURSE_TITLE})
  .ToList();

answered Sep 18, 2013 at 20:58

Erik Philips

54.9k11 gold badges133 silver badges158 bronze badges

Collectives™ on Stack Overflow

How can I write this LINQ query as a Lambda expression?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related