linq to entity 动态拼接问题
1
悬赏园豆：20
[待解决问题]
有个Employee表，我想根据EmployeeID 进行模糊查询（EmployeeID 是string类型）；
我获得了 一个string[] empID={"111","222","333"}，要用数组里的数据去查出Employee表的数据，最好用linq to entity 去写。
所有回答(2)
0
from e in Employee where empID.Contains(e.EmployeeID) select e;
生成的sql语句为：
select*from Employee as e where e.EmployeeID in {"111","222","333"}
0
var query=entities.Employee.where(c=>empID.contains(c.EmployeeID));
