CODEWITHSUNDEEP
linqlinq-to-entitiesentity-framework-4.1
Jatin
Jatin

Reputation: 4063

Getting Entities whose keys match list(or array) of ids

I am using CodeFirst EntityFramework. I have a IQueryable<User> Entities that are returned using context.Users; where context is DbContext of EntityFramework. From this list I have to choose those whose Id is contained in an array of Ids (long). Id is primary key of User entity. I have tried the following but getting compiler error.

IQueryable<User> users = GetQueryableUsers(); 
long [] ids = GetSelectedIds(); //array of long representing Ids key of User entities
users.Intersect(ids); // compilation error
users.Where(user => ids.Contains(user.Id)); //compilation error

Compilation error is (no definition found for Intersect/Contains) Note: System.Linq is already imported.

Upvotes: 12

Views: 22411

Answers (2)

Bob Vale
Bob Vale

Reputation: 18474

Make sure you are referencing System.Linq

e.g. using System.Linq

Then user.Id must be of type long. You've stated in comments that it is long? because you believed that is how you needed to use the primary key. The solution is to use long and make use of the autogenerate id options of the entity framework.

Alternatively a more general case for non primary keys that could be null would be to use the contains option with the value or default operator.

users.Where(user=>ids.Contains(user.id??0));

Upvotes: 19

thekip
thekip

Reputation: 3768

Your problem is you can't intersect users on long ids. Intersect can only be used on IEnumerables of the same type.

You should use user.Id.GetValueOrDefault() because your ID is long? instead of long.

Upvotes: -1

Related Questions