How combine two or more lists into one list

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

Please kindly help me out.

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}

For using the join you need to add the reference between your classes like employee id or employee object in the salary and department class.

For Cartesian product (https://en.wikipedia.org/wiki/Cartesian_product) you can use to linq to get all the combinations.

Check the sample below based on your use case.

// Classes
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 SalaryAmount { get; set; }
}
class Emp
{
public string EmpID { get; set; }
public string EmployeName { get; set; }
public string Gender { get; set; }
}
class Department
{
public string DepartId
{
get; set;
}
public string DepartName { get; set; }
public Emp employee { get; set; }
}
class Salary
{
public string SalaryId { get; set; }
public string SalaryAmount { get; set; }
public Emp employee { get; set; }
}

Now the Method for Joining..

private static bool JoinResult()
{
#region SampleData
Emp emp1 = new Emp()
{
EmployeName ="abc",
Gender ="Male",
EmpID = "1"
};
Emp emp2 = new Emp()
{
EmployeName = "xyz",
Gender = "Female",
EmpID = "2"
};
Emp emp3 = new Emp()
{
EmployeName = "pqr",
Gender = "Male",
EmpID = "3"
};
Department d1 = new Department()
{
DepartId = "1",
DepartName = "HR",
employee = emp1
};
Department d2 = new Department()
{
DepartId = "2",
DepartName = "Purchase",
employee = emp2
};
Department d3 = new Department()
{
DepartId = "3",
DepartName = "Finance",
employee = emp3
};
Salary s1 = new Salary()
{
employee = emp1,
SalaryAmount = "10000",
SalaryId = "1"
};
Salary s2 = new Salary()
{
employee = emp2,
SalaryAmount = "15000",
SalaryId = "1"
};
Salary s3 = new Salary()
{
employee = emp3,
SalaryAmount = "20000",
SalaryId = "1"
};
IList emp = new List();
emp.Add(emp1); emp.Add(emp2); emp.Add(emp3);
IList dept = new List();
dept.Add(d1); dept.Add(d2); dept.Add(d3);
IList sal = new List();
sal.Add(s1); sal.Add(s2); sal.Add(s3);
#endregion
#region JoinCode
// Inner Join Out..
Console.WriteLine("*** Printing Inner Join *** ");
IList finalResult =
(
from e in emp
join d in dept
on e.EmpID equals d.employee.EmpID
join s in sal on e.EmpID equals s.employee.EmpID
select new Final() { EmployeName = e.EmployeName, DepartId = d.DepartId, DepartName = d.DepartName, Gender = e.Gender, SalaryAmount = s.SalaryAmount, SalaryId = s.SalaryId }
).ToList();
finalResult.ToList().ForEach(delegate (Final f)
{
Console.WriteLine($"EmployeeName : {f.EmployeName} \t DepartId : {f.DepartId} \t DepartName : {f.DepartName} \t Gender : {f.Gender} \t SalaryAmount : {f.SalaryAmount} \t SalaryId = {f.SalaryId} ");
});
// Cartesian Product
IList finalResultCart =
(
from e in emp
from d in dept
from s in sal
select new Final() { EmployeName = e.EmployeName, DepartId = d.DepartId, DepartName = d.DepartName, Gender = e.Gender, SalaryAmount = s.SalaryAmount, SalaryId = s.SalaryId }
).ToList();
Console.WriteLine("*** Printing Cartesian Product *** ");
finalResultCart.ToList().ForEach(delegate (Final f)
{
Console.WriteLine($"EmployeeName : {f.EmployeName} \t DepartId : {f.DepartId} \t DepartName : {f.DepartName} \t Gender : {f.Gender} \t SalaryAmount : {f.SalaryAmount} \t SalaryId = {f.SalaryId} ");
});
Console.ReadLine();
#endregion
return true;
}

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Chirag Khabaria8y ago
Accepted answer
For using the join you need to add the reference between your classes like employee id or employee object in the salary and department class.

For Cartesian product (https://en.wikipedia.org/wiki/Cartesian_product) you can use to linq to get all the combinations.

Check the sample below based on your use case.
// Classes

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 SalaryAmount { get; set; }
    }
    class Emp
    {
        public string EmpID { get; set; }
        public string EmployeName { get; set; }
        public string Gender { get; set; }
    }
    class Department
    {
        public string DepartId
        {
            get; set;
        }
        public string DepartName { get; set; }

        public Emp employee { get; set; }
    }
    class Salary
    {
        public string SalaryId { get; set; }
        public string SalaryAmount { get; set; }

        public Emp employee { get; set; }
    }
Now the Method for Joining..
private static bool JoinResult()
        {
            #region SampleData
            Emp emp1 = new Emp()
            {
                EmployeName ="abc",
                Gender ="Male",
                EmpID = "1"
            };

            Emp emp2 = new Emp()
            {
                EmployeName = "xyz",
                Gender = "Female",
                EmpID = "2"
            };

            Emp emp3 = new Emp()
            {
                EmployeName = "pqr",
                Gender = "Male",
                EmpID = "3"
            };

            Department d1 = new Department()
            {
                DepartId = "1",
                DepartName = "HR",
               employee = emp1
            };

            Department d2 = new Department()
            {
                DepartId = "2",
                DepartName = "Purchase",
                employee = emp2
            };

            Department d3 = new Department()
            {
                DepartId = "3",
                DepartName = "Finance",
                employee = emp3
            };

            Salary s1 = new Salary()
            {
                employee = emp1,
                SalaryAmount = "10000",
                SalaryId = "1"
            };

            Salary s2 = new Salary()
            {
                employee = emp2,
                SalaryAmount = "15000",
                SalaryId = "1"
            };

            Salary s3 = new Salary()
            {
                employee = emp3,
                SalaryAmount = "20000",
                SalaryId = "1"
            };

            IList emp = new List();
            emp.Add(emp1); emp.Add(emp2); emp.Add(emp3);

            IList dept = new List();
            dept.Add(d1); dept.Add(d2); dept.Add(d3);

            IList sal = new List();
            sal.Add(s1); sal.Add(s2); sal.Add(s3);

            #endregion

            #region JoinCode

            // Inner Join Out..
            Console.WriteLine("*** Printing Inner Join *** ");

            IList finalResult =
                            (
                                  from e in emp
                                  join d in dept
                                  on e.EmpID equals d.employee.EmpID
                                  join s in sal on e.EmpID equals s.employee.EmpID
                                  select new Final() { EmployeName = e.EmployeName, DepartId = d.DepartId, DepartName = d.DepartName, Gender = e.Gender, SalaryAmount = s.SalaryAmount, SalaryId = s.SalaryId }
                              ).ToList();

            finalResult.ToList().ForEach(delegate (Final f)
            {
                Console.WriteLine($"EmployeeName : {f.EmployeName} \t DepartId : {f.DepartId} \t DepartName : {f.DepartName} \t Gender : {f.Gender} \t SalaryAmount : {f.SalaryAmount} \t SalaryId = {f.SalaryId}  ");
            });


            // Cartesian Product
            IList finalResultCart =
                            (
                                  from e in emp
                                  from d in dept
                                  from s in sal
                                  select new Final() { EmployeName = e.EmployeName, DepartId = d.DepartId, DepartName = d.DepartName, Gender = e.Gender, SalaryAmount = s.SalaryAmount, SalaryId = s.SalaryId }
                              ).ToList();

            Console.WriteLine("*** Printing Cartesian Product *** ");
            finalResultCart.ToList().ForEach(delegate (Final f)
            {
                Console.WriteLine($"EmployeeName : {f.EmployeName} \t DepartId : {f.DepartId} \t DepartName : {f.DepartName} \t Gender : {f.Gender} \t SalaryAmount : {f.SalaryAmount} \t SalaryId = {f.SalaryId}  ");
            });

            Console.ReadLine();


            #endregion

            return true;
        }
0
Santosh Kumar8y ago
Thank bro it might help me
-1