只是闲来无事对Linq的一些笔记,不是什么技术分析文章。以简单的例子来展示Linq之美
1.简单示例来展示多表查询(t_user 客户经理表 ,t_customer 客户表 1对多的关系)
var result = from q in db.t_user //查询客户经理表
from o in q.t_customer //q
where q.username == "tom"
select o;
2.左外链接
var userlistIQue1 = from u in myteref.m_distributor
join g in myteref.m_check on u.username equals g.username into check // 结果重命名为check
from g in check.DefaultIfEmpty()//遍历结果
select new userlist { Username = u.username, Wangwang = u.wangwang, Phone = u.phone, Creditrating = u.creditrating, Mainbusiness = u.mainbusiness };//userlist为定义的类