Loading

like command

like command

10y1.1kLINQ

please give me this query into Linq

select * from emp where ename Like '%s'

i had writen

pub List GetLike()

{

var x=from n in db.emps

where n.ename=='%s'

select n;

return x.tolist();

}

please Guide me

7 Replies

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

Ranjit Powar10y ago
Accepted answer
pub List GetLike()
{
var x=from n in db.emps
where n.ename.EndsWith("s")
select n;
return x.tolist();
}
+1
10y ago
Thank you Bro
0
Ranjit Powar10y ago
public List GetLike()
{
var x=from n in db.EMPs
//where n.ENAME.StartsWith("A")
where where n.ename.ToLower().EndsWith("s")
select n;
return x.ToList();
}
}
+1
10y ago
no bro it through an Erroer like
LINQ to Entities does not recognize the method 'Boolean EndsWith(System.String, System.StringComparison)' method, and this method cannot be translated into a store expression.
THIS IS MY QUERY
public List GetLike()
{
var x=from n in db.EMPs
//where n.ENAME.StartsWith("A")
where n.ENAME.EndsWith("s", StringComparison.OrdinalIgnoreCase)
select n;
return x.ToList();
}

}

0
Ranjit Powar10y ago
pub List GetLike()
{
var x=from n in db.emps
where n.ename.EndsWith("s",StringComparison.OrdinalIgnoreCase)
select n;
return x.tolist();
}
0
10y ago
Hello Ranjith your code working fn but its Case sensitive cant we write with out case sensitive
0
Manas Mohapatra10y ago
Try with below code:

pub List GetLike()
{
List x = (from n in db.emps
               where n.ename[n.ename-1] == 's'
               select n).ToList;

   return x;
}
0