如何将三个或更多列表组合到一个列表中。

问题描述

Hi Friends,

I am having a requirement like below.

class Final
{
public string EmployeName{get;set;}
public string Gender{get;set;}
public string DepartId{get;set;}
public string DepartName{get;set;}
public string SalaryId{get;set;}
public string Salary{get;set;}
}

class Emp
{
public string EmployeName{get;set;}
public string Gender{get;set;}

}

class Department
{
public string DepartId{get;set;}
public string DepartName{get;set;}
}
class Salary
{
public string SalaryId{get;set;}
public string Salary{get;set;}
}
Having the list of Final, Emp, Department and Salary like below

lstFinal, lstEmp,lstDepartment,lstSalary


Want a linq query with  final list to be a combination of lstEmp, lstDepartment,lstSalary

Like below table.
Please kindly help me out.

------------------|------|--------|----------|--------|------|-
|-EmployeName-----|Gender|DepartId|DepartName|SalaryId|Salary|
|                                                            |
|                                                            |

What I have tried:

var result= from e Emp
  join d in dept on e.EmployeName equals e.EmployeName
 join g in gend on g.Gender equals g.Gender
select new Final(){EmployeName=e.EmployeName, Gender=e.Gender, DepartId=d.DepartId, DepartName=d.DepartName,SalaryId=s.SalaryId,Salary=s.Salary}

推荐答案

这篇关于如何将三个或更多列表组合到一个列表中。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！