我如何使用LINQ或lambda前pressions加入两个列表 [英] how do I join two lists using linq or lambda expressions

问题描述

我有两个列表列表＆LT;工作单＆GT; 和列表＆LT; PlannedWork＆GT; 我想就加入了两个列表如下面详述的工作单数。换句话说，我有计划的工作清单，但我需要知道的workOrderNumber工作的描述。

我是新来的两个LINQ和lambda前pressions，我还没有完全得到我的头包裹在他们周围还没有。

 类工作单
{
    公众诠释WorkOrderNumber {搞定;组; }
    公共字符串WorkDescription {搞定;组; }
}类PlannedWork
{
    公众诠释WorkOrderNumber {搞定;组; }
    公众的DateTime ScheduledDate {搞定;组; }
}
 

解决方案

这听起来像你想要的东西，如：

  VAR的查询=从订单的工作订单
            参加计划的计划
                 在order.WorkOrderNumber等于plan.WorkOrderNumber
            新选择
            {
                order.WorkOrderNumber，
                order.Description，
                plan.ScheduledDate
            };
 

I have two lists List<WorkOrder> and List<PlannedWork> I would like join the two lists on the workorder number as detailed below. In other words I have a list of planned work but I need to know the description of the work for the workOrderNumber.

I am new to both linq and lambda expressions, and I haven't quite got my head wrapped around them yet.

class WorkOrder
{
    public int WorkOrderNumber { get; set; }
    public string WorkDescription { get; set; }
}

class PlannedWork
{
    public int WorkOrderNumber { get; set; }
    public DateTime ScheduledDate { get; set; }
}

解决方案

It sounds like you want something like:

var query = from order in workOrders
            join plan in plans
                 on order.WorkOrderNumber equals plan.WorkOrderNumber
            select new
            {
                order.WorkOrderNumber,
                order.Description,
                plan.ScheduledDate
            };

这篇关于我如何使用LINQ或lambda前pressions加入两个列表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！