Linq to Sql query to search for Accent sensitive name

Question

How do i write given query into Linq to Sql Query SELECT * FROM employees WHERE name COLLATE Latin1_general_CI_AI Like '%Nino%' COLLATE Latin1_general_CI_AI. This is my code queries.Add(from e in context.employees where e.name == nameParam select e);

Pradip Pandey · Answer

Hi Try this code employees=fromemp in ourContext.Employee where empname .Contains(ent.empname[0]) selectemp;

Kap Shivhare · Answer

http://www.dotnetlearners.com/linq/linq-to-sql-like-operator.aspx

Nepethya Rana · Answer

Please check my another question friends. Thank you for help.

Midhun T P · Answer

Hi Try this code - var employees = from e in context . employees where e. name .Contains( nameParam) select e; Please check below link - http://www.dotnetlearners.com/linq/linq-to-sql-like-operator.aspx

Manas Mohapatra · Answer

Try with below code: List bookList = new List () { new Book { Name= man  Description = test } new Book { Name= Man  Description = Test } }; bookList = (from rec in bookList where rec.Name.Contains( Man ) select rec).ToList();