entity framework实体框架如何模糊查询某个int?字段

Question

数据库字段若是string字段类型,可以使用  Contains、StartsWith、EndsWith 实现对数据库 like的查询

但是对于 数据库字段是int或者是int?时候,如何使用实体框架来做 like 查询?

想使用contains就的tostring 但是框架不允许,要么就只能完全用==来做完全匹配

_db.table1.Count(l => l.UserId.toString().Contains("1000").); //这样写会出现错误

_db.table1.Count(l => l.UserId==1000); //这样写正常,但是又无法做到 like 查询,

求大神给个解决方案 

Answer 1

你好，

你可以用下面的方法试试。

var results = from e in _db.table1
  where SqlFunctions.StringConvert((double)e.UserId).Contains("1000")
  select e;
var count = results.Count();

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.

Answer 2

谢谢,应该就是这个