linq jion多张表 group by
来源:互联网 发布:二选一数据选择器 编辑:程序博客网 时间:2024/05/16 11:59
var total = from rua in db.rh_user_attendances
join rpi in db.rh_patient_infos
on rua.UserNumber equals rpi.UserNumber
join rsi in db.rh_student_infos
on rua.UserId equals rsi.Id
join rci in db.rh_course_infos
on rua.CourseAddress equals rci.CourseAddress
select new
{
Id = rua.Id,
teacherName = rpi.UserName,
teacherNumber = rpi.UserNumber,
TrainName = rua.TrainName,
CourseAddress = rua.CourseAddress,
studentName = rsi.UserName,
studentNumber = rsi.UserNumber,
UserRole = rsi.UserRole,
TrainNumber = rci.TrainNumber,
AttendanceTime = rua.AttendanceTime
};
join rpi in db.rh_patient_infos
on rua.UserNumber equals rpi.UserNumber
join rsi in db.rh_student_infos
on rua.UserId equals rsi.Id
join rci in db.rh_course_infos
on rua.CourseAddress equals rci.CourseAddress
select new
{
Id = rua.Id,
teacherName = rpi.UserName,
teacherNumber = rpi.UserNumber,
TrainName = rua.TrainName,
CourseAddress = rua.CourseAddress,
studentName = rsi.UserName,
studentNumber = rsi.UserNumber,
UserRole = rsi.UserRole,
TrainNumber = rci.TrainNumber,
AttendanceTime = rua.AttendanceTime
};
var totalGroup = total.Distinct();
c# 中join多张表,需要group by. 在linq语句中Distinct()函数即可实现该功能。
0 0
- linq jion多张表 group by
- linq group by
- linq group by
- Linq group by 练习
- linq group by 处理
- linq-group by
- 使用right jion on group by 出现的问题
- linq group by 两个值
- linq group by 多列值 实现
- linq group by 多列值 实现
- Linq使用Group By 2
- Linq使用Group By 3
- Linq使用Group By 1
- Linq使用Group By 2
- Linq使用Group By 3
- linq中group by实例
- Linq使用Group By经验总结
- linq group by应用一
- Leetcode 124. Binary Tree Maximum Path Sum
- 【莫比乌斯反演】[BZOJ3529]数表
- Matplotlib 如何显示中文
- nginx上设置禁止通过ip访问服务器,只能通过域名访问
- Leetcode 207. Course Schedule
- linq jion多张表 group by
- Leetcode 210. Course Schedule II
- OMAP3 DSS 初始化过程(1)总线关系
- 【莫比乌斯反演】[SPOJ VLATTICE]Visible Lattice Points
- 用Android搭建客户端 手机和服务器交互开发实例
- windows下taglist的配置
- 基于TCP的文件传输
- Android与服务器端数据交互(http协议整合struts2+android)
- 草稿