Join中第二个参数和第三个参数即为两张表关联对应的字段
第四个参数new 后面如果不写Model名,系统会自动生成带字段的list类型
public List<OperatorTrainingReportVM> GetOperatorTrainingReportByStart(int start, int pageSize, out int total, Expression<Func<OperatorTrainingReportVM, bool>> whLamdba)
{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