Introduction
In this article we will learn how to use join using Lambda Expression in C#. Join example with Lambda Expression using LIST collection.
Previous Updates
In previous articles we have learnt Maintain state of dynamic added userConrol in asp.net using c#.Arrange Distinct Elements Of A List In Ascending Order Using LINQ
Description:
Here i am using the List collection to store the temporary/static data. In your case may be it will the database data.
Below is My two class just like two tables Student and Department.
static void Main(string[] args)
{
List<Emp> liEmp = new List<Emp>();
liEmp.Add(new Emp { EmpID = 1, EmpName = "JP" });
liEmp.Add(new Emp { EmpID = 2, EmpName = "GurujiPoint" });
liEmp.Add(new Emp { EmpID = 3, EmpName = "PointGuruji" });
liEmp.Add(new Emp { EmpID = 6, EmpName = "DE" });
liEmp.Add(new Emp { EmpID = 8, EmpName = "EF" });
List<Dep> lstDep = new List<Dep>();
lstDep.Add(new Dep { DepID = 1, Department = ".Net", EmpID = 1 });
lstDep.Add(new Dep { DepID = 2, Department = "PHP", EmpID = 2 });
lstDep.Add(new Dep { DepID = 3, Department = "ASP", EmpID = 3 });
lstDep.Add(new Dep { DepID = 4, Department = "Android", EmpID = 4 });
lstDep.Add(new Dep { DepID = 5, Department = "GD", EmpID = 5 });
lstDep.Add(new Dep { DepID = 6, Department = "UI", EmpID = 6 });
//INNER JOIN Using Lambda Expression
var lamdaData =
liEmp.Join(lstDep, emp => emp.EmpID, dep => dep.EmpID, (emp, dep) => new
{
emp.EmpID,
emp.EmpName,
dep.Department
});
foreach (var data in lamdaData)
{
Console.WriteLine("EmpId = " + data.EmpID
+ ",Emp Name = " + data.EmpName +
",Department = " + data.Department);
}
Console.ReadLine();
}
|
Output:
Removing duplicate records from SQL Table
Removing duplicate records from SQL Table
EmpId = 1,Emp Name = JP,Department = .Net
EmpId = 2,Emp Name = GurujiPoint,Department = PHP
EmpId = 3,Emp Name = PointGuruji,Department = ASP
EmpId = 6,Emp Name = DE,Department = UI
|
