How to add a second condition in Linq Query [closed]

Question

Closed. This question is not reproducible or was caused by typos. It is not currently accepting answers.

This question was caused by a typo or a problem that can no longer be reproduced. While similar questions may be on-topic here, this one was resolved in a way less likely to help future readers.

Closed yesterday.

Improve this question

I have this linq query in my controller and it is working fine,

var Engineers = dbcontext.Employees.Where(i => i.Department == "Engineers");

but I would like to add a second condition to the query to filter out the results,

var Engineers = dbcontext.Employees.Where(i => i.Department == "Engineers" && i.UserStatus = 1);

Thanks for your help.

That's how you do it. Except you want to use == to compare values instead of = (assignment operator). — nbokmans
Typo. You're trying to assign instead of compare. Use the == operator that you were already using previously. — David

SirMartin SirMartin · Accepted Answer · 2022-07-27T12:48:10

You made a typo, just need to use comparison operator (==) instead of assignation (=)

So it would be like that:

var Engineers = dbcontext.Employees.Where(i => i.Department == "Engineers" && i.UserStatus == 1);

How to add a second condition in Linq Query [closed]

1 Answers