c#linq to sql迭代左联接结果 [英] c# linq to sql iterating through left join results
本文介绍了c#linq to sql迭代左联接结果的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有一个如下查询:
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屋!
查看全文