“如果任何包含任何" (DbExpressionBinding需要输入) [英] "If Any Contains Any" (DbExpressionBinding requires an input)

问题描述

我正在尝试建立一个简单的搜索，并在其中传递关键字列表.但是，一旦我将任何包含关键字"作为列表而不是字符串添加到列表中，我就会得到:

I'm trying to build a simple search where I pass a list of keywords. But soon as I add the "any contains keywords" as a list instead of a string I get:

"DbExpressionBinding requires an input expression with a collection ResultType."

我对IQueryable<Inspector>进行了扩展:

 public static IQueryable<Inspector> Search(this IQueryable<Inspector> qry, List<string> keywords)
 {
    return from i in qry
           where
             i.LastName.Any(x => keywords.Contains(i.LastName)) ||
             i.FirstName.Any(x => keywords.Contains(i.FirstName)) ||
             i.City.Any(x => keywords.Contains(i.City)) ||
           select i;
 }

当我称呼它时，我使用:

And when I call it I use:

return qry.Search(keywords).ToList();

我应该如何解决此问题?

How should I fix this issue?

推荐答案

我认为您正在尝试做到这一点:

I think you're trying to get at this:

return from i in qry
    where keywords.Contains(i.LastName) ||
        keywords.Contains(i.FirstName) ||  
        keywords.Contains(i.City)
    select i;

这将返回任何在关键字列表中有名字，姓氏或城市的记录.

This will return you any records where the FirstName, LastName, or City is in your keyword list.

这篇关于“如果任何包含任何" (DbExpressionBinding需要输入)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！