How can I get build a query based on array of IDs using EF

Question

I'm trying to build a query selecting all records containing IDs which are stored in the list using that code:

var assistsIds = _context.Assistances.Where(c => c.IdUser == user.IdUser)
                        .Select(x => x.Owner.IdOwner).ToList();

Then I'm going through all the list elements to get a query:

var query = _context.Accounts.Where(_ => _.IsDeleted != 1);

                foreach(var assist in assistsIds)
                {
                    query = query.Where(_ => _.IdOwner == assist);
                }

The result is that I'm getting something like this:

SELECT * FROM Accounts WHERE IdOwner = 1 AND IdOwner = 2 ...etc

Instead of:

SELECT * FROM Accounts WHERE IdOwner = 1 OR IdOwner = 2 ... etc

Is there a way to apply OR operator, or maybe there is some other way to achieve that?

Maybe what you need is something like in this answer https://stackoverflow.com/a/16025457/2494218 — ealvess, Feb 09 '22 at 15:32
A where on top of a where, logically, is an AND. A where alongside a where, would be an OR, but calling where on the result of a where is "on top", not "alongside" — Caius Jard, Feb 09 '22 at 15:52
Do you have navigation properties set up so you can navigate eg Assistance.Owner.Accounts? — Caius Jard, Feb 09 '22 at 15:54

score 0 · Answer 1 · answered Feb 09 '22 at 15:38

0

You could use Contains:

var query = _context.Accounts
                .Where(_ => _.IsDeleted != 1 && assistsIds.Contains(_.IdOwner));

This will return all records which match an Id in the assistsIds list.

answered Feb 09 '22 at 15:38

haldo

14,512
5
46
52

How can I get build a query based on array of IDs using EF

1 Answers1