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}
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)