联表查询

首先，我们在数据库里看一下这些表的关系：

查询的代码是这样的：
var listUser = (from tbUser in myModel.S_User
join tbUserTypeDetail in myModel.R_UserTypeDetail on tbUser.UserID equals tbUserTypeDetail.UserID
join tbUserType in myModel.S_UserType on tbUserTypeDetail.UserTypeID equals tbUserType.UserTypeID
select new
{
UserID = tbUser.UserID,
UserName = tbUser.UserName,
UserCode = tbUser.UserCode,
Password = tbUser.Password,
UserTypeID = tbUserType.UserTypeID,
UserType = tbUserType.UserType,
typeClass = tbUserType.typeClass
}).ToList();
上面的“tb**”是范围变量（自定义表名）之后的就是查询的表名
“equals”使前后的两个表的主键和外键相等。
“select new{}”中括号里就是你需要查询的字段。