Simple Examples of joining 2 and 3 table using lambda expression
85,890
Solution 1
Code for joining 3 tables is:
var list = dc.Orders.
Join(dc.Order_Details,
o => o.OrderID, od => od.OrderID,
(o, od) => new
{
OrderID = o.OrderID,
OrderDate = o.OrderDate,
ShipName = o.ShipName,
Quantity = od.Quantity,
UnitPrice = od.UnitPrice,
ProductID = od.ProductID
}).Join(dc.Products,
a => a.ProductID, p => p.ProductID,
(a, p) => new
{
OrderID = a.OrderID,
OrderDate = a.OrderDate,
ShipName = a.ShipName,
Quantity = a.Quantity,
UnitPrice = a.UnitPrice,
ProductName = p.ProductName
});
Thanks
Solution 2
try this one to join 2 tables using lambda expression
var list = dataModel.Customers
.Join( dataModel.Orders,
c => c.Id,
o => o.CustomerId,
(c, o) => new
{
CustomerId = c.Id,
CustomerFirstName = c.Firstname,
OrderNumber = o.Number
});
Author by
Arian
Please vote-up this thread: RDLC Report Viewer for Visual Studio 2022
Updated on May 28, 2020Comments
-
Arian almost 4 years
Can anyone show me two simple examples of joining 2 and 3 tables using
LAMBDA EXPRESSION(
for example using Northwind tables (Orders,CustomerID,EmployeeID)?