How to write "OR" in Linq to Sql.Where ()

Question

I want to get all WHERE entries (s.override == 1 OR (s.override == 2 AND s.approved == 1))

How can I do this with .Where x.subcontracts.Where(s ==> ??)

Answer 1

Use standard C # binary operators:

x.subcontracts
  .Where(s => s.override == 1 || (s.override == 2 && s.approved == 1))

Answer 2

Here is the where clause you need:

x.subcontracts.Where(s => (s.override == 1) || (s.override == 2 && s.approved == 1))