how to search Unicode value Linq

Question

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 methanks very much!

nguyen hung · Answer

My query join 4 tablelinq+mvc5 so if i use your way web will load very slow.i want to use linq query to search unicode.

Manas Mohapatra · Answer

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(); }