c# - LINQ 如何创建 BETWEEN 条件

Question

我有一个基于不同规则处理分数计算的模型

    Scoremaster
    ----------
    Grade 
    MinScore
    MaxScore
    GradeRule  

此处提供了一些示例数据

    A1 4.5 5     5
    A2 4   4.5   5
    B1 3.5 4     5
    B2 3   3.5   5
    C  0   3     5
    A1 8   10    10
    A2 6   8     10
    B1 5   6     10
    C  0   5     10
    A1 16  20    20
    A2 12  16    20
    B1 8   12    20
    C  0   8     20 

我规划的算法是这样的

string FindGrade(double score,string rule)
{

 List<Scoremaster> scores=(from p in dbcontext.Scoremasters
                             where p.GradeRule==rule
                             select p).ToList();

//how can i check the score input of the function belongs to which category from this list using Linq

//example   FindGrade(3,5) = B2  FindGrade(4,5) = A2
//example   FindGrade(7,10) = A2  FindGrade(4,10) = C
//example   FindGrade(17,20) = A1  FindGrade(10,20) = B1                             
}

根据输入，我可以过滤到特定的成绩类别。下一步是根据属性 minScore 和 MaxScore 检测分数在哪个范围内，然后返回相应的等级，我正在努力使用 Linq 来做到这一点

Answer 1

像下面那样做:

string FindGrade(double score,string rule)
{  
    List<Scoremaster> scores = (from p in dbcontext.Scoremasters
                         where p.GradeRule==rule && score>= p.MinScore && score<= p.MaxScore
                         select p).ToList();
}

希望对您有所帮助。