c# - 将 LINQ 与 MVC 结合使用，如何将多个参数包含到 where 子句中？

Question

我正在尝试运行下面的代码，它可以正常工作，直到我在使用逗号添加一个新值并添加到值数组后尝试添加第二个搜索值。在 SQL 术语中，我基本上想在每次循环迭代后添加“AND”关键字。这有可能吗？

var query = from s in db.Items 
                    join c in db.Categories on s.Category equals c.ID into cats from c in cats.DefaultIfEmpty()
                    join ma in db.Makes on s.Make equals ma.ID into maks from ma in maks.DefaultIfEmpty()
                    join mo in db.Models on s.Model equals mo.ID into mods from mo in mods.DefaultIfEmpty()
                    join st in db.Status on s.Usage_Status equals st.ID into stats from st in stats.DefaultIfEmpty()
                    join d in db.Departments on s.Department equals d.ID into deps from d in deps.DefaultIfEmpty()
                    select new { item = s, cat = c, make = ma, model = mo, status = st, department = d };

if (!String.IsNullOrEmpty(searchString))
{
    string[] searchValues = searchString.Split(',');

    for (var x = 0; x < searchValues.Length; x++)
    {
        var value = searchValues[x];
        query = query.Where(s => s.item.Asset_Tag_Nbr.Contains(value)
                           || s.item.Serial.Contains(value)
                           || s.cat.Name.Contains(value)
                           || s.make.Name.Contains(value)
                           || s.model.Name.Contains(value)
                           || s.item.Assigned_User.Contains(value));
    }
}

Answer 1

事实证明，代码可以正常工作，只是开发人员的错误。输入搜索词时，我在逗号后添加了一个空格。将 var value = searchValues[x] 更改为 var value = searchValues[x].Trim() 可以解决问题并清除两端的空白区域。