Friday, April 23, 2010

Join with LINQ

AdventureWorksModel.AdventureWorksEntities _db = new AdventureWorksEntities();

List lSales = _db.SalesPerson.ToList();

List lEmp = _db.Employee.ToList();

var EmpDeptJoin =
from sales in lSales
join emp in lEmp on sales.SalesPersonID equals emp.EmployeeID
select new { SalesPerson = sales.SalesPersonID, Employee = emp.EmployeeID };

No comments:

Post a Comment