LinQ链表查询 中 添加where 条件
0
最佳答案
1
from c in db.t_leave join p in db.t_employee on c.fk_employee equals p.pk_employee where p.name='name' select c;
收获园豆：80
其他回答(6)
0
p.name.Contains("关键词") like查询
0
from c in db.t_leave
join p in db.t_employee
on c.fk_employee equals p.pk_employee
where p.name.Contains("name")
select c;
0
字符串匹配方面Linq可以翻译
Contains("xx") 为 like "%xx%"
StartWith("xx") 为 like "xx%"
EndWith("xx") 为 like "%xx"
0
string _name= t_employee.Where(t=>t.你的条件==某个值).Select(t.name).First() //这是外键表的第一条符合你的条件的数据(如果没有会因为.First()报错，这点LZ权衡下吧)
list<t_leave> ls_t_l= t_leave.Where(t=>t.name==_name).tolist(); //name=外键表结果的对象集合
0
var poco = from A in db.t_leave join left B db.t_employee on A.fk_employee equals B.pk_emplpyee
where A.name = B.name
0
var datas = t_employee.Include("t_leave").where(f => f.name.Contains(查询的值)).ToList();