Querying multiple data using System.Linq

Question

I am new to .Net Framework and am no expert in any programming language. I am just learning new things.

I want to get a list of objects from my database with Ids of 2, 6, and 9 and also all objects with Ids greater than 20. Here is my code.

int [] toRemove= { 2, 6, 9 };
var contributions = dbContext.FoodMenu
    .Where(x => toRemove.Contains(x.Id))
    .ToList();

As you see, the query with all Ids that are greater than 20 is not yet included. Is there a way I can add to the list with a single query only? How can I do that? Thank you so much.

Yong Shun · Accepted Answer · 2023-01-25 06:37:58Z

1

Add || or condition for Id is greater than 20.

The query will fetch either the Ids within (2, 6, 9) or greater than 20.

int [] toRemove= { 2, 6, 9 };
var contributions = dbContext.FoodMenu
    .Where(x => toRemove.Contains(x.Id)
        || x.Id > 20)
    .ToList();

answered Jan 25, 2023 at 6:37

Yong Shun

54.5k6 gold badges38 silver badges66 bronze badges

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

Collectives™ on Stack Overflow

Querying multiple data using System.Linq

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related