Linq query 'and' 'or' operators

Question

I have written a LINQ query with 'or' condition and 'and' but its not working well.

from x in db.fotoes.Where(x => x.uid == NewsId && 
x.ukat == 'fukat1' || x.ukat == 'fukat2')

i cant figure out why its not working,can anybody help me to fix this problem?

Answer 1

Just try like this, you need to use parentheses to group your conditions:

from x in db.fotoes.Where(x => x.uid == NewsId && 
(x.ukat == 'fukat1' || x.ukat == 'fukat2'))

Answer 2

Group your conditions by adding parentheses:

from x in db.fotoes.Where(x => (x.uid == NewsId) && 
                         (x.ukat == 'fukat1' || x.ukat == 'fukat2'))

Answer 3

from x in db.fotoes.Where(x => x.uid == NewsId && (
x.ukat == 'fukat1' || x.ukat == 'fukat2'))

Is it what you're trying to do? You can group a set of conditions by having them inside parenthesis.