Question

我希望,这一标题非常直截了当。基本上,我有一个数据库,没有安装全文索引。我不是安装全文本索引,而是想到是否与林克一道这样做?

Answer 1

您可以撰写准则问题,在<代码>上使用实例方法。系统。大部分准则提供者都能够将这一发言转换为L.。例如:

from customer in db.Customers
where customer.Name.Contains("foo") || customer.Name.Contains("bar")
select customer;

准则提交实体将改为:

SELECT T1.*
FROM Customers T1
WHERE T1.Name LIKE  %  + @p1 +  % 
OR T1.Name LIKE  %  + @p2 +  %

请注意,在您需要大量文字才能搜寻时,您可使用PredicateBuilder。它使你能够建立含有OR声明的前提。与工会进行联系也是有效的方法。例如:

string[] searchWords;

// Define an empty set.
var customers =
    from customer in db.Customers
    where false
    select customer;

// Union the empty set with a set for a word.
foreach (var temp in searchWords)
{
    var searchWord = temp;

    customers = customers.Union(
        from customer in db.Customer
        where customer.Name.Contains(searchWord)
        select customer);
}

Answer 2

我认为,你是这样:

from xx in table
where uids.Contains( xx.uid.ToString() )
select xx

?

如果你在经过适当搜查后,或许:

string input = "some String";
string[] toSearchFor = GetSearchStrings();
var containsAll = toSearchFor.All(x => input.Contains(x));

友情链接