Loading

Like operator in linq

Ami Kar

I have to select all names between a to r using linq from my table? Select all student whose name lies in betweeb a to r ?

3 Replies

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

Sachin Singh5y ago
Accepted answer
use this then
var res = db.Students.ToList();
var filter= from stu in res
where stu.Name[0] >= 'A' && stu.Name[0] <= 'R'
select stu;
+1
Ami Kar5y ago
Throwing error stating method char is not convertable
0
Sachin Singh5y ago
from a in context.Students
where a.Name[0]>='A' && a.Name[0]<='R'
select a;
0