Linq模糊查询
EF中使用的linq查询语句,这里需要进行模糊查询。
在linq中进行模糊查询非常的简单,使用Contains即可。
把前端的字符串,传到后台之后,在写linq语句的时候使用Contains即可。
public List<QueryResultViewModel>FuzzyQuery(string Content)
{
try
{
//引用上下文
excellentmcoinEntities DBcontext = new excellentmcoinEntities();
List<QueryResultViewModel> Department = newList<QueryResultViewModel>();
//查询全部
Department = (from a in DBcontext.t_accumulate
wherea.accumulateDescription.Contains(Content)
select newQueryResultViewModel()
{
accumulateID= a.accumulateID,
accumulateDescription =a.accumulateDescription,
departmentID= a.departmentID,
accumulateStates = a.accumulateStates,
userID =a.userID,
date = a.date,
operaterID =a.operaterID,
operaterDate= a.operaterDate,
}).ToList();
return Department;
}
catch (Exception e)
{
throw e;
}
}
其中,一句代码就可以解决
a.accumulateDescription.Contains(Content)