Loading

how to search Unicode value Linq

nguyen hung

10y3.4kLINQ

i have page search thread with keyword support unicode

example:keyword hung will display result hùng and hung

my code in linq:

from thread in db.thread .Where(o => (!String.IsNullOrEmpty(key)) ? thread.content.Contains(

key) : true)

i have try add method removeunicode

from thread in db.thread .Where(o => (!String.IsNullOrEmpty(key)) ? removeunicode(thread.content).Contains(

key) : true)

but it's error linq to entities does not recognize the method

Please help me,thanks very much!

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

nguyen hung10y ago
My query join 4 table,linq+mvc5 so if i use your way web will load very slow.i want to use linq query to search unicode.
Manas Mohapatra10y ago
First you have to make column as NVARCHAR in your database.
Then you can use the N' prefix to indicate that you're searching for a Unicode strin
using(varctx=newSchoolDBEntities())
{
    stringquery="SELECT * FROM dbo.tblArticle WHERE name LIKE N'%value%'";

    vars tudentName = ctx.Students.SqlQuery(query).ToList();
}