Join more than multiple Tables in Linq using Entity Framework in ASP.Net

Hi nauna,

Refer below code.

Code

C#

protected void Page_Load(object sender, EventArgs e)
{
    NorthwindEntities entity = new NorthwindEntities();
    var result = from o in entity.Orders
                    join c in entity.Customers
                    on o.CustomerID equals c.CustomerID
                    join emp in entity.Employees
                    on o.EmployeeID equals emp.EmployeeID
                    select new { o.OrderDate, c.CustomerID, emp.EmployeeID, emp.FirstName };
}

VB.Net

Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
    Dim entity As NorthwindEntities = New NorthwindEntities()
    Dim result = From o In entity.Orders
                 Join c In entity.Customers On o.CustomerID Equals c.CustomerID
                 Join emp In entity.Employees On o.EmployeeID Equals emp.EmployeeID
                 Select New With {o.OrderDate, c.CustomerID, emp.EmployeeID, emp.FirstName}
End Sub