在多个where条件下使用Linq [英] using Linq with multiple where conditions

问题描述

我有一个表示数据库中已定义表的类:

I have a class representing a table on database that is defined:

public class MyClass{
    public int MyClassId{get;set;}
    public string Name{get;set;} 
    public string LastNamw{get;set;}
    public DateTime From{get;set;}
    public DateTime To{get;set;}
}

我要在其上对oracle数据库运行一些搜索查询.

On which I want to run some search query against oracle database.

现在的问题是:

var list = context.MyClass
    .Where(x => x.From>= FromMyDate)
    .Where(x => x.To <= ToMyDate);


var list = context.MyClass
    .Where(x => x.From>= FromMyDate && x.To <= ToMyDate);

在where条件或一个条件中使用多个行是否更好?以及为什么...请

据我了解，当我要搜索第一个条件的结果时，会使用多个where子句.

As far as I understand, I use multiple where clauses when I want to search on result of the first condition.

推荐答案

我将关注Vossad01发布的John Skeet答案.

I will be following John Skeet answer as posted by Vossad01.

正确的Linq where子句

这篇关于在多个where条件下使用Linq的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！