62,046
社区成员
发帖
与我相关
我的任务
分享linq sum()求和问题
linq 中的求和问题
假如sum(字段) 有的字段的值为null 计算出来却为null 怎么把字段为null的值转换为0 啊？
高手们指点一下
假如sum(字段) 有的字段的值为null 计算出来却为null 怎么把字段为null的值转换为0 啊？
高手们指点一下
...全文
请发表友善的回复…
发表回复
wuyq11 2010-02-02
- 打赏
- 举报
(p.partWeight==null?0:p.partWeight)
wuyq11 2010-02-02
- 打赏
- 举报
var q = db.A.Select(o => o.AA).Sum();
对应SQL：
SELECT SUM([a].[AA]) AS [value]
FROM [dbo].[A] AS [a]
var sr = from k in db.User
group by k.Name into g
select new
{
Name = g.Key,
(S= g.Sum(k => k.a))==null?0:S)
}
对应SQL：
SELECT SUM([a].[AA]) AS [value]
FROM [dbo].[A] AS [a]
var sr = from k in db.User
group by k.Name into g
select new
{
Name = g.Key,
(S= g.Sum(k => k.a))==null?0:S)
}
xiaoliang_run 2010-02-02
- 打赏
- 举报
from p in db.tblParts
group p by p.partName into g
select new {
partName = g.key,
totalWeight = g.Sum(p => p.partWeight)
}
p.partWeight 有时候为null 但是怎么把null转换为0
group p by p.partName into g
select new {
partName = g.key,
totalWeight = g.Sum(p => p.partWeight)
}
p.partWeight 有时候为null 但是怎么把null转换为0
