var hydropsPositionsQry = from a in _smartWaterOneMapContext.HydropsPosition.Where(s => s.IsDeleted == false)
join b in _smartWaterOneMapContext.StStbprpB.Where(s => s.IsDeleted == false)
on a.Stcd equals b.Stcd into temp1
from t1 in temp1.DefaultIfEmpty()
select new
{
Hp = a,
Status = t1 != null ? t1.Status : null
};
C# linq select new all table object
最新推荐文章于 2023-01-09 20:27:36 发布
这段代码展示了在C#中使用查询表达式(LINQ)进行数据查询和联接的操作。IsDeleted为false的HydropsPosition和StStbprpB实体被筛选并进行联接,然后通过DefaultIfEmpty处理可能的空结果,最后选择包含HydropsPosition实体和Status信息的对象集合。
摘要由CSDN通过智能技术生成