Linq to Entities question

Question

Is there a (fairly) simple explanation of why I can't do this:

var EmpList = from emp in context.Employees orderby emp.LastName select new { Name = emp.FirstName + " " + emp.LastName };

And further, is it possible to achieve this in the query or do I have to do this kind of processing after, with a foreach or something similar?

Thanks..

Mark Byers · Accepted Answer · 2011-02-13 00:39:33Z

4

You can do that.

However it seems unnecessary to create an anonymous type with only one member. Try this instead:

var employeeNames = from emp in context.Employees orderby emp.LastName select emp.FirstName + " " + emp.LastName;

edited Feb 13, 2011 at 0:39

answered Feb 13, 2011 at 0:34

Mark Byers

844k202 gold badges1.6k silver badges1.5k bronze badges

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

5 Comments

LukLed Over a year ago

Is it necessary to use IQueryable:)?

Mark Byers Over a year ago

No - I changed it to var now. But sometimes it is useful to know what the type is. Especially if you want to return it as a method result.

LukLed Over a year ago

That is not what I meant, but it doesn't matter any more:)

Sleette Over a year ago

@Shawn: I'm not at the computer atm so I can't say exactly what the error was, I'll post later if unresolved @Mark: thanks, I'll check it out later; I just simplified for example but I was sure it was getting hung up on that.. perhaps my error is elsewhere

Sleette Over a year ago

Thanks all. You were, of course, correct. I examined my code and realized my mistake was occurring when I was accessing the members of the anonymous type, not in the query. Thanks again..

Justin Morgan · Accepted Answer · 2011-02-13 00:37:51Z

As far as I know, you can do that. You can also do this:

var EmpList = from emp in context.Employees let name = emp.FirstName + " " + emp.LastName orderby emp.LastName select name;

Haven't tested this in Studio though.

Collectives™ on Stack Overflow

Linq to Entities question

2 Answers 2

5 Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

Comments

Related