c# - 如何在 LINQ WHERE 语句中使用 OR 运算符

Question

我只需要一个用 LINQ 编写的与此 TSQL 语句等效的语句。最好在 lambda 语句中，但任何东西都可以。TSQL语句:

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

Answer 1

就像其他 C# 代码一样，使用 || 进行 OR

方法语法:

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

查询语法:

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

查询语法编译成方法语法。

参见: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.

您应该看到:Basic LINQ Query Operations (C#)