c# - 2 列范围之间的 Linq 值

Question

我在创建复制以下 SQL 语句所需的 linq 时遇到了一些困难。

    SELECT TOP (1000) [Id]
      ,[Price]
      ,[ThicknessFrom]
      ,[ThicknessTo]
      ,[WeightFrom]
      ,[WeightTo]
  FROM [dbo].[MyTable] 
  WHERE (8 between [ThicknessFrom] and [ThicknessTo])
  AND (100 between [WeightFrom] and [WeightTo])

我拥有的数据示例:

id: 1, price: 1, thicknessFrom: 0, thicknessTo: 10, weightFrom: 0, weightTo: 125
id: 2, price: 2, thicknessFrom: 11, thicknessTo: 20, weightFrom: 126, weightTo: 250

我想从上面的 linq 语句返回查询，该语句将返回基于 2 个输入、重量和厚度的数据，这将返回 id = 1。

谢谢

Answer 1

MyTable.Where(entities => entities.ThicknessFrom <= 8)
       .Where(entities => entities.ThicknessTo >= 8)
       .Where(entities => entities.WeightFrom <= 100)
       .Where(entities => entities.WeightTo >= 100)
       .Take(1000);

我们在上面所做的是链接多个谓词以保持内容清晰/易于阅读，直到执行 .Take() 方法才真正执行查询。