Linq like or other construction
- by Yauhen Kavalenka
I have DB oracle in my solution.
I want to have some results in this query.
Query example:
select * from doctor where doctor.name like '%IVANOV_A%';
But if i do it at LINQ i cannot get any result.
from p in repository.Doctor.Where(x => x.Name.ToLower().Containsname))
select p;
Where 'name' is variable of string parameter.
Web layout request next string: "Ivanov a" or "A Ivanov"
But i suggest for user choose you pattetn for query.
How i can to get "patient by name" if name consist of "First name" and "Last name" but user doesn't know your doctor's full name?
