.net EF Join 关联表分页查询

Join中第二个参数和第三个参数即为两张表关联对应的字段

第四个参数new 后面如果不写Model名，系统会自动生成带字段的list类型

IQueryable<Operator> operators = operatorService.GetAll();
IQueryable<Training> trainings = trainingService.GetAll();
var list = trainings.Join(operators, a => a.OperatorId, b => b.Id, (a, b) => new OperatorTrainingReportVM
{
EmployeeNO = b.EmployeeNO,
Name = b.Name,
Sex = b.Sex,
AreaName = b.Area.Name,
CostName = b.Cost.Name,
OnBoardDate = b.OnBoardDate,
ShiftName = b.Shift.Name,
DirectorNO = b.Director.EmployeeNO,
DirectorName = b.Director.Name,
ConfirmDate = b.ConfirmDate,
IsDimission = b.DimissionDate != null ? true : false,
DimissionDate = b.DimissionDate,
ServiceDays = (int)DbFunctions.DiffDays(b.OnBoardDate, DateTime.Now),
PositionName = b.Position.Name,
PositionLevelName = b.PositionLevel.Name,
DimissionName = b.Dimission.Name,
DimissionReason = b.Dimission.Reason,
StartDate = a.StartDate,
EndDate = a.EndDate,
ExamineDate = a.ExamineDate,
ExpireDate = a.ExpireDate,
Enginner = a.Enginner,
Trainer = a.Trainer,
Score = a.Score,
StandardScore = a.StandardScore,
Result = a.Result,
CourseName = a.Course.Name,
OperationLevelName = a.OperationLevel.Name,
Enabled = b.Enabled
}).Where(whLamdba);
total = list.Count();
var result = list.OrderBy(t => t.EmployeeNO).Skip(start).Take(pageSize).ToList();

其中Join部分具体是inner join还是left join，EF会自动根据查询条件生成相应的SQL

巴特西

.net EF Join 关联表分页查询

最新文章

热门文章