Nepethya Rana

Nepethya Rana

  • NA
  • 335
  • 145.9k

Linq to Sql query to search for Accent sensitive name

Aug 27 2016 10:14 PM
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);
 
 
 

Answers (5)