c#linq to sql迭代左联接结果 [英] c# linq to sql iterating through left join results

问题描述

我有一个如下查询:

var emp = (from activeWO in context.ActiveWOs
                               join activeWOUpdated in context.ActiveWOUpdatedTimes on activeWO.PW_ID equals activeWOUpdated.PW_ID into dj
                               from activeWOUpdated in dj.DefaultIfEmpty()
                               where activeWO.WODC.Contains("IDC") 
                    select new { activeWO.WO_Status,activeWO.PW_ID, activeWO.T_Number, activeWOUpdated.CALCActiveTimeSec });

我在.dbml文件中都映射了两个表，但是正如您在上面看到的那样，我并不是仅提取表类对象，而是仅提取2个表中的3列.

I have both tables mapped out in the .dbml file but as you can see above I am not pulling a table class object just but just 3 columns from 2 tables.

如何遍历emp的结果?

推荐答案

如何遍历emp的结果?

How can iterate through the results of emp?

最简单的是:

foreach(var item in emp)
{
  Console.WriteLine(item.WO_Status);
  //other properties
}

这篇关于c#linq to sql迭代左联接结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！