Entity Framework - async select with where multiple conditions

Question

I'm using ASP.NET Core with Entity Framework.

I have found this working command on Stackoverflow

var d = await db.Employee.Where(x => x.FirstName == "Jack").ToListAsync();

at the following link : Entity Framework - async select with where condition

Please tell me how can I load the table records into a list based on multiple where conditions.

I want something like that :

var d = await db.Employee.Where(x => x.LastName == "Smith" 
                                     and x => x.Country == "UK" 
                                     and x => x.Age == 45 etc)

Serge · Accepted Answer · 2021-10-07 21:13:00Z

2

You are almost there

var d = await db.Employee.Where(x => x.LastName == "Smith" 
                          && x.Country == "UK"
                           && x.Age == 45)
                          .ToListAsync();

answered Oct 7, 2021 at 21:13

Serge

44.4k4 gold badges26 silver badges53 bronze badges

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

2 Comments

Tom Cat Over a year ago

It is working ! Thank you very much !

Serge Over a year ago

You are welcome!

Collectives™ on Stack Overflow

Entity Framework - async select with where multiple conditions

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related