How to return List instead of an object using Lambda and EF

Question

I have this code that returns a single user:

  return RetryWithExpression<User, User>(u => u.FirstOrDefault(x => x.UserEmail == userEmail));

I am trying to convert it so that It returns many users like this:

return RetryWithExpression<User, List<User>>(u => u.Select(x => x.sUserCity == cityId));

This does not compile and I get an error:

Cannot implicitly convert type 'System.Linq.IQueryable<bool>' to 'System.Collections.Generic.List<User>'. An explicit conversion exists (are you missing a cast?)

How do I return a List from this method?

Daniel A. White · Accepted Answer · 2012-09-02 17:06:23Z

4

I think you want Where which filters. Select does a projection. In your case Select would return an IEnumerable<bool>, hence the compilation error.

return RetryWithExpression<User, List<User>>(u => u.Where(x => x.sUserCity == cityId));

Since RetryWithExpression expects a list, call ToList()

return RetryWithExpression<User, List<User>>(u => u.Where(x => x.sUserCity == cityId).ToList());

edited Sep 2, 2012 at 17:06

answered Sep 2, 2012 at 17:00

Daniel A. White

192k49 gold badges389 silver badges473 bronze badges

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

1 Comment

user1615362 Over a year ago

Thanks but this dosen't fix the code. I still get an error: Cannot implicitly convert type 'System.Linq.IQueryable<User>' to 'System.Collections.Generic.List<User>'. An explicit conversion exists (are you missing a cast?)

Collectives™ on Stack Overflow

How to return List instead of an object using Lambda and EF

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related