如何使用SQL“LIKE'与LINQ到实体? [英] How to use SQL 'LIKE' with LINQ to Entities?
问题描述
我有一个文本框,允许用户指定搜索字符串,包括通配符,例如:
I have a textbox that allows a user to specify a search string, including wild cards, for example:
Joh*
*Johnson
*mit*
*ack*on
在使用LINQ到实体,我有一个存储过程,而把这个字符串当作参数,所做的:
Before using LINQ to Entities, I had a stored procedure which took that string as parameter and did:
SELECT * FROM Table WHERE Name LIKE @searchTerm
然后,我只想做一个与string.replace('*','%')传递给它之前。
And then I would just do a String.Replace('*', '%') before passing it in.
现在使用LINQ到实体我试图完成同样的事情。我知道有StartsWith,和的endsWith包含的支持,但不会支持它,我需要的方式。
Now with LINQ to Entities I am trying to accomplish the same thing. I know there is StartsWith, EndsWith and Contains support, but it won't support it in the way that I need.
我读到SqlMethods.Like,并试图这样的:
I read about "SqlMethods.Like" and tried this:
var people = from t in entities.People
where SqlMethods.Like(t.Name, searchTerm)
select new { t.Name };
但是我收到以下异常:
However I am getting the following exception:
LINQ to Entities does not recognize the method 'Boolean Like(System.String,
System.String)' method, and this method cannot be translated into a store
expression.
我该如何获得使用LINQ到实体此相同的功能?
How would I get this same functionality using LINQ to Entities?
推荐答案
<一个href=\"http://social.msdn.microsoft.com/Forums/en-US/adodotnetentityframework/thread/6529a35b-6629-44fb-8ea4-3a44d232d6b9/\">http://social.msdn.microsoft.com/Forums/en-US/adodotnetentityframework/thread/6529a35b-6629-44fb-8ea4-3a44d232d6b9/
var people = entities.People.Where("it.Name LIKE @searchTerm", new ObjectParameter("searchTerm", searchTerm));
这篇关于如何使用SQL“LIKE'与LINQ到实体?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!