MVC List Query DB

Question

Im trying to learn mvc and im stuck on something silly.

i have a list of int's which are the PK for a domain model. I want to query the db to get all the objects that have their pk's in the list. I cant fiugre out the code to query the db and searching brings all kinds of irellevent answers about drop down lists. Can anyone help?

something like this but this is wrong.

 List<User> userList = db.Users.Where(x => x.UserID == idList);

EDIT The error im getting is this.

Operator '==' cannot be applied to operands of type 'int' and 'System.Collections.Generic.List'

Simon C · Accepted Answer · 2013-11-18 01:14:43Z

1

Try this:

List<User> userList = db.Users.Where(x => idList.Contains(x.UserID)).ToList();

This will translate to the SQL in operator.

answered Nov 18, 2013 at 1:14

Simon C

9,4983 gold badges39 silver badges55 bronze badges

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

3 Comments

loveforfire33 Over a year ago

Hi, thanks for your time. That looks more like what im trying to do. but i get the error Error 1 Cannot implicitly convert type 'System.Linq.IQueryable<Quit.Models.User>' to 'System.Collections.Generic.List<Quit.Models.User>'. An explicit conversion exists (are you missing a cast?)

Simon C Over a year ago

Right. Add a .ToList() at the end.

loveforfire33 Over a year ago

Urgh its been a long day, sorry. Thanks!

Heberda · Accepted Answer · 2013-11-18 01:06:31Z

0

The above looks correct. Have you instantiated your db?

For example: DBContext db = new DBContext;

answered Nov 18, 2013 at 1:06

Heberda

8208 silver badges30 bronze badges

Collectives™ on Stack Overflow

MVC List Query DB

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related