How to use OR operator in LINQ WHERE statement

问题:

I just need an equivalent of this TSQL statement written in LINQ. Preferably in lambda statement but anything will work. TSQL statement:

select *
from Table1 as t1
where t1.Column1 = a OR t1.Column2 = b

回答1:

Just like other C# code use || for OR

Method Syntax:

var query = db.Table1
              .Where(r=> r.Column1 == a || r.Column2 == b);

Query Syntax:

var query = from r in db.Table1
            where r.Column1 == a || r.Column2 == b
            select r;

Query Syntax compiles into Method syntax.

See: Query Syntax and Method Syntax in LINQ (C#)

Most queries in the introductory Language Integrated Query (LINQ) documentation are written by using the LINQ declarative query syntax. However, the query syntax must be translated into method calls for the .NET common language runtime (CLR) when the code is compiled.

You should see: Basic LINQ Query Operations (C#)